Email Alerts
-
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 many customers who use and benefit from the reuse of deleted records.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
-
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 the QSYS2 schema.Ask the Expert
-
Access path and an open data path differences
On AS/400 DB2 an access path describes the order in which the rows are retrieved from a database file. The open data path (ODP) is the path through which all input and output operations are performed on a database file. As data is retrieved from or inserted into the file, the ODP will use an access path to navigate to a row within in the file.Ask the Expert
-
Database performance comparisons on IBM i
Testing performance of RLA in the IBM Java Toolbox against JDBC and native I/O for the AS/400 revealed that RPG on System i is the most efficient language, and DB2 is taken for granted. Joe Pluta built some benchmarks to compare different aspects of database performance to one another and he provides the results of his testing. Although MySQL is popular and provides an option for prepackaged applications with less stringent database requirements, it won't likely replace DB2 anytime soon.Tip
-
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
-
Simplify the process of converting a spool file from iSeries into an Excel spreadsheet
To simplify and accelerate the process of converting a spool file from iSeries into an Excel spreadsheet, eliminate the creation of the spool file and instead create a CVS text file, which can easily be loaded into Excel.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
-
Control and fix date format problems on AS/400 SQL
To avoid date format problems on the DB2 for iSQL interface, specify a date format that supports a four-digit year value with the DATFMT parameter in the SQL precompiled commands.Ask the Expert
-
Uniquely matching two fields in an SQL table to fields in a different table
Use an UPDATE statement in SQL to match fields in one SQL table on AS/400 to fields in another SQL table.Ask the Expert
- VIEW MORE ON : DB2 UDB (universal databases)
-
Oracle boasts 11g on SPARC is faster than IBM DB2 on Power 595
At Oracle Open World in San Francisco, the company shared new speed marks for its application server and database as the company's Fusion Middleware took center stage. A $10-millon prize was offered to anyone who can show that a Sun-Oracle configuration doesn't run at least twice as fast as a comparable setup from IBM.News | 13 Oct 2009
-
Debating DB2 versus Oracle
Contributor Andrew Borts has a little fun with a mock debate between DB2 and Oracle. Addressing misconceptions about DB2's functionality and integration with OSes outside of i5, Borts concludes that DB2's advantages mostly lie in return on investment and the fact that it's an integrated database in his favorite OS, i.News | 21 Oct 2008
-
DB2 trivia challenge
Test your knowledge!Article | 10 Nov 2005
-
Oracle and the iSeries: Understanding nulls
This user discovered that in converting an application from using Oracle 8i to using DB2/400, Oracle behaves differently when concatenation nulls.Tip
-
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
-
Securing query definitions
A better way of granting users access to query definitions.Tip
-
New, undocumented Query function can boost your productivity
If the use of Query for iSeries is a part of your daily iSeries chores, then a new function introduced in V5R3 could spell big gains.Tip
-
Is the SQL Path being used?
Ask the Expert
-
Get the system to recognize a date separator
Ask the Expert
-
Populate a Lotus Notes database with iSeries data
Ask the Expert
- VIEW MORE ON : Oracle on iSeries
-
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 many customers who use and benefit from the reuse of deleted records.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
- VIEW MORE ON : iSeries SQL commands and statements