Month: May 2024

​[[{“value”:”- SELECT * FROM QSYS2.PTF_INFO
– SELECT * FROM QSYS2.PTF_INFO WHERE PTF_ID = ‘???????’;”}]] Read More 

​[[{“value”:”Non-printable characters can sneak into our records for various reasons, and to prevent issues, we can run an SQL query that uses the LOCATE() function.
This query uses the REPLACE function to substitute the non-printable characters ‘0D’ (Carriage Return) and ’25’ (Line Feed) with a blank space in the CLNOM0 field.”}]] Read More 

​[[{“value”:”Has anyone implemented Valence App Builder into their system to build web applications? I’ve been testing the trial and hoping to hear from current or past customers on their experience.
https://cnxcorp.com/valence/
submitted by /u/danielharner[link][comments]”}]] Read More 

​[[{“value”:”* source member QZIPUTIL present in QSYSINC/QRPGLESRC location having prototypes defined
/copy qsysinc/qrpglesrc,qziputil”}]] Read More 

​[[{“value”:”Unzip file in ifs using IBM i command CPYFRMARCF and how to resolve CPFA0A2 error Information passed to this operation was not valid.
. : Information passed to this operation was not valid.”}]] Read More