Page 1 of 1

JDBC Connections Anyone?

Posted: Tue Aug 11, 2009 9:38 am
by skilletrx2
Hi there, is anyone using JDBC to connect to data sources within a datastage job? I would be interested in seeing how its done/ your experiences with it.

thanks in advance.

Posted: Tue Aug 11, 2009 11:03 am
by lstsaur
I am using JDBC in my Java stage. JDBC enables you to handle difficult tasks such as Ref Cursor or BLOB easily.

Posted: Tue Aug 11, 2009 6:48 pm
by skilletrx2
lstsaur wrote:I am using JDBC in my Java stage. JDBC enables you to handle difficult tasks such as Ref Cursor or BLOB easily.
Hi lstaur, do you have any examples or sites / references that helped you get started w/ the JAVA Stage? Seems like you have to write java class for it right?

Posted: Wed Aug 12, 2009 10:24 am
by lstsaur
For verson 8.x it doesn't include any documentation for Java stage. But for version 7.5.x, it comes with the DS_Java_Pack_Designer.pdf file if you have purchased Java PACK.