Problem solve
Get help with specific problems with your technologies, process and projects.
iSeries database management
Change from a Julian date to a "true" date for a search criteria index
Use an SQL index statement or view to write a query, or change your physical file definition to convert the Julian date column into a real date column. 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
-
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
-