Get started
Bring yourself up to speed with our introductory content.
DB2 UDB universal databases
Making a file with an automatic key in iSeries with DDS keyword
If you want to create an automatic key using a DDS keyword on AS/400, Kent Milligan explains that any native writes performed against an SQL table created with an identity table will result in DB2 generating identity values. Continue Reading
WebSphere Development Studio Client (WDSC)
WebSphere Development Studio Client (WDSC) is a set of application development tools designed for the IBM (International Business Machines) iSeries server. The WDSC basic edition offers user-friendly, easy-to-learn tools to help providers optimize ... Continue Reading
AIX (Advanced Interactive eXecutive)
AIX is an open operating system from IBM that is based on a version of UNIX. Continue Reading
-
Accessing MS SQL Server database from the iSeries
An ITKE member recently was looking for some information on the best way to execute a SQL statement on the iSeries. Fellow iSeries users offered advice. Continue Reading
Run multiple SQL statements
-
Definitions to Get Started
View All Definitions CHAR fields vs. VARCHAR
Physical Reads and Logical Reads
What ports need to be open within the firewall?
Developing a system with Delphi to connect to the DB2/400
ROWID data type in V5R2
-
Why do I keep getting SQL error SQL0204?
Can RUNSQLSTM run if you don't have SQL/400?
Is it possible to access the results of a call to a stored procedure from the "green screen" side?
How can I transfer an XML file to a physical file?
Full text indexing in DB2/400
Unexpected results after doing OVRDBF then SQL
Store an image file in the iSeries
Get the most out of your database
IBM's plans for DDS with DB2
Using REUSEDLT on physical files