New Feature REDIS_KEYS

[M11VCS]

Hi ,
I just downloaded and tested Redis400.
You did a really great job! Well done and really appreciated.
I would like to know if it's possible to add a new UDF , i.e. REDIS_KEYS, to retrieve all values for a specific KEY or all KEYS like Redis command KEYS *.

Giovanni

[krakonos-tatransky]

Hi Giovanni,

Thank you so much for your kind words — I’m really glad you tested Redis400 and found it useful!

Adding a UDF like REDIS_KEYS is definitely a great idea. It would make it easier to explore or debug Redis data directly from SQL on IBM i. I’ll look into implementing this function to support both a filtered key pattern (e.g., KEYS myprefix*) and a full key list (KEYS *).

In the meantime, if you’d like to contribute or have a preferred output format (e.g., returning key names only, or including their values), feel free to share your thoughts — I’d be happy to align it with your use case.

Thanks again for the feedback and suggestion!
Ernest

[M11VCS]

Hi Ernest, Yes, I would like to test it . Unfortunately I’m just a RPGLE developer and can’t help you with C programming. Best regards, Giovanni Michielin Victoria Computer Services LTD The Bradfield Centre 184 Cambridge Science Park Rd Cambridge CB4 0GA United Kingdom

…

On 12 Nov 2025 at 21:24 +0100, Krakadin ***@***.***>, wrote: krakonos-tatransky left a comment (krakadin/redis400#2) Hi Giovanni, Thanks for the kind words — really appreciate it! Yes, REDIS_KEYS is a great idea. I’ll add a UDF like: SELECT REDIS_KEYS('MYCONN', '*') FROM SYSIBM.SYSDUMMY1; Returns matching keys (one per row). Will use KEYS for simplicity, with a SCAN option later. Coming in the next release (~1 week). Want to test it when ready? Just let me know. Thanks again! Ernest — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[M11VCS]

Hi Ernest ,
were you able to add REDIS_KEYS udf ?
Cheers
Giovanni