Problem solve
Get help with specific problems with your technologies, process and projects.
iSeries database management
Deleting records in SQL database files when fields are duplicated in another file
To delete a file that contains fields duplicated elsewhere, you need to code a subquery on your SQL statement. Continue Reading
Using CHGPF to change file attributes of core application files
Manually recompiling RPG programs and AS/400 queries is necessary when using the CHGPF command to alter attributes of database files. Continue Reading
How to summarize an alias reference outside of SQL views and MQTs
Apply a user-defined table function to summarize an alias reference and reference the UDTF on a SELECT statement. Continue Reading
-
-