Articles & Content

Archives

Oh - It's Dynamic ! Should I consider to PANIC ? (G09)

Topic: DB2 for z/OS

Subtopic: 2005



DATE: 2005-10-25 (13:30 - 14:30)
SPEAKERS: Frank Petersen (Bankdata)

This presentation will cover problems with Dynamic SQL on Z/os. It will try to evaluate the well known problems and describe possible reliefs for these. As most Dynamic SQL today are from JDBC and ODBC,it will try to cover this as well. There will be coverage of drivers, DataSources and connection pooling in WebSphere as many are struggling with this. There will be shown and handed out examples using JDBC, SQLJ and MS VB.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

The old well-known problems in dynamic SQL.

What can be done as circumvention for these ?

SQL from Java (JDBC and SQLJ) and MS VB (ODBC).

Driver handling and DataSources in WebSphere.

Conclusions.



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.