JDBC Connections Anyone?

skilletrx2 · Post by **skilletrx2** » Tue Aug 11, 2009 9:38 am

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.

lstsaur · Post by **lstsaur** » Tue Aug 11, 2009 11:03 am

I am using JDBC in my Java stage. JDBC enables you to handle difficult tasks such as Ref Cursor or BLOB easily.

skilletrx2 · Post by **skilletrx2** » Tue Aug 11, 2009 6:48 pm

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?

lstsaur · Post by **lstsaur** » Wed Aug 12, 2009 10:24 am

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.