Use SQL instead of DDS

DDS is dead and SQL in, according to some.

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

Dig deeper on iSeries CL programming

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close