DDS is exit; use SQL to create your files, indexes and views. Use iSeries Navigator to convert your DDS files to SQL statements (right-click on the file you want to convert). Create new files using iSeries Navigator and generate the SQL statements. Copy & paste your SQL statements to a script. Add a CREATE- or SET SCHEMA command on top of your script, so you can create new schemas/collections/libraries as you wish. Use new SQL functions as DATALINK, user defined (table) functions and get the feel of SQL. Use embedded SQL (ODBC/JDBC) to access your files. The core message of this tip: DDS is dead, use SQL!
================================== MORE INFORMATION ON THIS TOPIC ==================================
The Best Web Links: tips, tutorials and more.
Ask your programming questions--or help out your peers by answering them--in our live discussion forums.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.
This was first published in February 2003