DataStage Enterprise - Oracle 10gR2 - AIX - HELPPPPP

juanc.martinez · Post by **juanc.martinez** » Thu May 15, 2008 9:22 pm

Good evening to every body

I starting to work in DataStage, my SW architecture is DataStage Enterprise, Oracle 10GR2 and AIX 5.3, I need to use oracle SQLLDR into my DSJobs, but the client from 32bits don't has the bin directory, how can I use the bin files from the 10G oracle client?

Thanks for all

Regards

Juan C. Martinez
Colombia

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2008 7:03 am

Welcome aboard. Make sure that Oracle's lib32 appears before lib in the shared library search path (LD_LIBRARY_PATH environment variable). Files in bin ought not to be involved, but you can do the same thing with the command search path (PATH). Set these in the dsenv script.

juanc.martinez · Post by **juanc.martinez** » Fri May 16, 2008 9:03 am

ray.wurlod wrote:Welcome aboard. Make sure that Oracle's lib32 appears before lib in the shared library search path (LD_LIBRARY_PATH environment variable). Files in bin ought not to be involved, but you can do the s ...

Hello Ray, thanks for your collaboration,, one question do you know how can I do the sqlldr?

thanks again
Juan Carlos

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2008 4:05 pm

The easiest way is to use Oracle Enterprise stage with write mode set to Write (or Load, depending on your version). If you want to keep the sqlldr invocation separate from DataStage ETL processing, simply specify the full pathname of the sqlldr command (and make sure your Oracle environment variables are correctly set).