Evaluate

Evaluate

Weigh the pros and cons of technologies, products and projects you are considering.

• V6R1 upgrade planning checklist

  When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been installed. Continue Reading

• Analyze the health of your IBM i server with iScore

  While more comprehensive services exist, iScore from Vision Solutions offers a free and general introductory analysis of your system's health. Continue Reading

• Researching high availability for your System i shop

  Interested in a high availability solution for the AS/400? Before you delve into implementation, do your due diligence and ensure that your environment has the proper policies, resources and protocols in place. Continue Reading

• Putting data from IBM i on Amazon S3 using i2S3

  Kisco Systems i2S3 allows transfer of data from the AS/400 to Amazon S3 storage in the cloud. With familiar CL commands, the product is easy to use, and can fill storage needs. The danger is the security of S3 cloud storage, with no guarantee from ... Continue Reading

• 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. Continue Reading

• 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.Continue Reading

• Developing tables in a parent-child relationship in DB2

  When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to maintain over time.Continue Reading

• 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...Continue Reading

• 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 ...Continue Reading

• 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.Continue Reading

• 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...Continue Reading

• EGL Rich UI on IBM i: Do you Dojo?

  Taking advantage of the Rich UI features of EGL architecture on the AS/400 can save you time and complexity. Rich internet applications can be difficult to write, even with Java and Webspher. EGL eliminates the need for programmers to learn ...Continue Reading

• 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...Continue Reading

• 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.Continue Reading

• 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.Continue Reading