Creating and Managing Database Objects Using SQL
Skip Marchesani
Creating and Managing Database Objects Using SQL
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 V4R2, R3, R4, and R5 are available only through the SQL interface? Do you know that you can use SQL to create, manage and manipulate your database objects, or use a combination of both DDS and SQL? If the answer to any of these questions is No, you need to come to this session to see how SQL will play a role in managing your DB2/400 database. You will explore the use of several SQL statements including CREATE and DROP to create and delete physical and logical files. You will also learn how to create and save SQL scripts that provide function similar to DDS and CRTPF or CRTLF. An understanding of DB2/400, DDS, and SQL basics is required.
Skip Marchesani retired from IBM after 25 years and is now a consultant with Custom Systems Corp, an IBM Business partner. Recognized as an industry expert on DB2/400 and author of the book 'DB2/400': The New AS/400 Database', he specializes in providing customized education for any area of the AS/400, does database design and design reviews, and general AS/400 consulting for interested clients. He has been a speaker for user groups, technical conferences, and AS/400 audiences around the world. Skip is an award winning COMMON speaker and has received their Distinguished Service Award.