New & Notable
iSeries SQL commands and statements News
April 12, 2005
IBM announced Tuesday the latest in a series improvements to its iSeries line, which analysts say is evidence of a trend towards an increased overlap with the pSeries.
iSeries SQL commands and statements Get Started
Bring yourself up to speed with our introductory content
Learn about a quick way of running an AS/400 query to select records based on current sysdate. Continue Reading
Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing data inserts, deletes or changes. Continue Reading
In SQL, when converting a numeric physical file to digits, pass the results of the DIGITS function through the STRIP function in order to avoid leading zeros. Continue Reading
Evaluate iSeries SQL commands and statements Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC because SQL-based interfaces use the long column name by default. Continue Reading
IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing applications that may have dependencies on deleted records that are not being used. However, there there are... Continue Reading
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output file that can be analyzed, or occasionally run queries against the SYSPARTITIONSTAT catalog view in ... Continue Reading
Manage iSeries SQL commands and statements
Learn to apply best practices and optimize your operations.
Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed data management (DDM). Continue Reading
You may think that blocking access to SQL line commands will protect your data. However, Carol Woodbury warns that object level security is the only real way to keep your data safe from unwanted manipulation. Continue Reading
Problem Solve iSeries SQL commands and statements Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data. Continue Reading
Using RPG ILE with embedded SQL can be a fast way to make database reports on the IBM i. Joe Pluta shares the code of his first SQLRPGLE program. Continue Reading
By virtue of being bult-in to the AS/400, RPG has speed for some operations that SQL cannot touch. Learn how RPG works with indexing to retrieve data from your IBM i. Continue Reading