Articles & Content

Archives

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

Topic: 2005 EU

Subtopic: DB2 for z/OS



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.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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