Email Alerts
-
Fast guide to SQL on iSeries quiz
Is your SQL knowledge on iSeries lacking? Brush up on our fast guide to SQL on iSeries and follow it up with this quiz. Quiz
-
Fast guide to iSeries SQL
Need SQL tips and advice? We've compiled some novice iSeries SQL tips and expert advice, as well as more advanced iSeries SQL information, in this Fast Guide to iSeries SQL. After you've spent some time with the material, test your knowledge with our... Learning Guide
-
Know-IT-All Chapter Quiz: SQL concepts & facilities
Think you know all there is to know about SQL? We challenge you to test your skills by taking our latest quiz. Quiz
-
Know-IT-All Chapter Quiz: SQL Built-In Functions
Think you know all there is about built-in functions? We challenge you to test your skills by taking our latest quiz. Quiz
-
How to: Output SQL script to a text file from an AS/400
Transferring data from SQL queries directly to a .txt file in a Windows environment is the desired outcome of one AS/400 user. Inserting the output of a SELECT statement into a physical file and then using CPYTOIMPF to transfer to a .txt file is a l... News | 04 Dec 2008
-
How to use an embedded SQL statement and display the result in a subfile
Are you looking for a way to load a file based on several search criteria and then display the file in a subfile? John Blenkinsop provides the needed RPG code to get it done on the AS/400. News | 04 Sep 2008
-
IBM steps up iSeries, pSeries overlap
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. Article | 12 Apr 2005
-
Connecting multiple iSeries systems through DDM
Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed data management (DDM). Tip
-
Enhancing RPG with external SQL stored procedures
Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data. Tip
-
Tracking data changes on IBM i with triggers
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. Tip
-
Introduction to SQLRPGLE on IBM i: Making a report
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. Tip
-
Making the most of RPG data handling on IBM i
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. Tip
-
Database drivers on the i: MySQL vs. IBM Toolbox
Which reads data from i faster: MySQL or IBM Toolbox drivers? Joe Pluta put the drivers to the test in both an AS/400 and a Windows environment. The conclusion: MySQL over its own database performs roughly as well as IBM's Java Toolbox over DB2 data,... Tip
-
Using SQL on System i to create multicolored comment lines
When using SQL to color source code on the AS/400, it is also possible to create multicolored comment lines. This System i tip provides the queries to do so. Tip
-
Using SQL on System i to color source code and inline comments
Without use of an advanced emulator, how do you color source code? SQL. This tip provides a complete table of valid hex values for display colors and the SQL queries to implement it on your system. Tip
-
Stored procedures allow you to balance network loads – Part II
In part two of this series on SQL stored procedures, Ron Turull explores how it can help optimize client/server applications, among other things, without bogging down the server. Isn't that the reason you went to client/server in the first place? Tip
-
SQL defined database: Enjoy the view
Paul Tuohy provides a simple example to show you how SQL defined views may be of benefit in an existing environment. The easiest way to start using views is with iSeries Navigator, which is what I will be using in the following examples. I will also ... Tip
- See more Tips on iSeries SQL commands and statements
-
Running AS/400 query to find records based on date
Learn about a quick way of running an AS/400 query to select records based on current sysdate. Answer
-
SQL server error message -321
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor using dynamic SQL. Ask the Expert
-
Choose which column names are returned via ODBC when working with DB2 files
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. Ask the Expert
-
When is the YES option for 'reuse deleted files' function the best choice?
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 ... Ask the Expert
-
Monitoring members 'stuck' within a physical file on an EDI system
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 t... Ask the Expert
-
Creating a host variable of the 'where in' statement in SQL
Create a host variable of the where in statement on the fly with dynamic SQL. Ask the Expert
-
Convert a numeric physical file to a character in SQL without leading zeros
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. Ask the Expert
-
Inserting data from a CTE into a file in SQL
To insert data from the CTE into a file in SQL, the common table expression definitions need to be declared within the nested SELECT statement when using a SQL insert statement. Ask the Expert
-
Implement variables in SQL when creating an alias
Use dynamic SQL to implement variables at runtime in order to build the CREATE ALIAS statement, or embed the PREPARE and EXECUTE statements in a high-level language. Ask the Expert
-
Disable SQL query optimizer tool that removes trailing blanks
When working with the length function used in a WHERE or ORDER BY clause, disable the DB2 SQL query optimizer from removing trailing blanks by changing the variable length optimization settings. Ask the Expert
- See more Expert Advice on iSeries SQL commands and statements
-
Running AS/400 query to find records based on date
Learn about a quick way of running an AS/400 query to select records based on current sysdate. Answer
-
Connecting multiple iSeries systems through DDM
Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed data management (DDM). Tip
-
Enhancing RPG with external SQL stored procedures
Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data. Tip
-
Tracking data changes on IBM i with triggers
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. Tip
-
Introduction to SQLRPGLE on IBM i: Making a report
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. Tip
-
Making the most of RPG data handling on IBM i
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. Tip
-
SQL server error message -321
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor using dynamic SQL. Ask the Expert
-
Choose which column names are returned via ODBC when working with DB2 files
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. Ask the Expert
-
When is the YES option for 'reuse deleted files' function the best choice?
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 ... Ask the Expert
-
Monitoring members 'stuck' within a physical file on an EDI system
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 t... Ask the Expert
- See more All on iSeries SQL commands and statements
About iSeries SQL commands and statements
Get iSeries SQL commands and statements news, tips and advice in this topic, including updates on iSeries SQL output, built-in functions and stored procedures.