408162

Creating & Managing Database Objects Using SQL

Speaker(s):
Skip Marchesani Custom Systems Corporation


Are you aware that IBM has recently stated that all future enhancements to DB2/ 400 will be made only via the SQL interface and that the native interface (CL, DDS, etc.) will be stabilized? Do you know that most of the database enhancements in Version 4 are available only through the SQL interface? You can use SQL to create, manage and manipulate your database objects. And, a combination of both DDS and SQL can be a vital tool.

In this session, learn:
1. How SQL plays a role in managing your DB2/ 400 database.
2. The SQL statements including CREATE and DROP to create and delete physical and logical files.
3. How to create and save SQL scripts that provide function similar to DDS and CRTPF or CRTLF.

An understanding of DB2/ 400, DDS, SQL basics is required.


47MI: Wednesday, 05:00-06:15 pm, A209Add To My Personal Grid

One & 1/4 hrs
Course of Study: DB2 UDB for the iSeries