Problem solve

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

• 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

• 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

• 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