Articles & Content


Create, Deploy and Debug DB2 9 for z/OS native SQL stored procedures using IBM Data Studio Developer (I06)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-13 (11:00 AM - 12:00 PM)
SPEAKERS: Marichu Scanlon (I B M Silicon Valley Lab)

Discuss the power of IBM Data Studio Developer for developing native SQL stored procedures for DB2 for z/OS v9. This presentation will discuss the advantages of using native SQL stored procedures. A step-by-step presentation of how to use the tool to develop native SQL SPS will be discussed, and in the end, we will discuss the use of the Unified Debugger for debugging native SQL SPs.

EXP. LEVEL: Beginner,Intermediate


Introduce IBM Data Studio as a tool for developing native SQL stored procedures

List the advantages of using native SQL stored procedures, and compare them to external SQL stored procedures.

Present the wizards and dialogs used when developing native SQL stord procedures

Discuss the capabilities for debugging native SQL stored procedures

Discuss advanced capabilities the customer can do with native SQL SPs such as binary deploy, versioning, package variation, and converting an external SQL stored procedue to a native SQL stored procedure.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.