DSXchange

I have a dsenv file such as and i added the following for oracle connectivity; # Environment variables added or modified for Oracle connectivity # TNS_ADMIN=/usr/lib/oracle/10.1.0.2/client export TNS_ADMIN LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/10.1.0.2/client/lib export LD_LIBRARY_PATH OR...

Datastage gurus help please

tx
Mark

when i try to view the data from Oracle EE stage i get the following mesg; Could not load module IBM/../../InformationServer/../DSComponents/bin/orchoracle.o However I have orchoracle.o file in this directory; IBM /../../InformationServer/../DSComponents/bin/orchoracle10g.o DS version: 8.0.1 Os: aix...

welcome aboard my friend :D

[quote="keshav0307"]what does ls -l *orchoracle* return[/quote]

It returned:

*orchoracle* not found

Thanks
Mark

[quote="keshav0307"]you must be having liborchoracle10gi686.so file then create a soft link using ln -s liborchoracle10gi686.so orchoracle.so[/quote] Thanks. Dshome/../PXEngine/lib ls -ltra *liborchoracle10g* *liborchoracle10g* not found I do not have liborchoracle10g in my PXengine/lib di...

[quote="ray.wurlod"]I believe that you can only compile a Build stage from within the stage properties dialog. ...[/quote] Hi All, CAn anyone please suggest any work around for my problem. I am not able to find a custom wrapped stage type in the compilation wizard.So i am not able to compi...

[quote="keshav0307"]ah, the same error i faced. you need to create another soft link orchoracle for the actual library file which is pointing to the oracle 10g library file at $DSHOME/../PXEngine/lib i have not connect now, so unable to give you the exact name.[/quote] I verified the PXEng...

[quote="ray.wurlod"]I believe that you can only compile a Build stage from within the stage properties dialog. ...[/quote] from v8.0; from designer --tools ---> multiple job compile ---> opens data stage compilation wizard --> i selected compile custom stage buildops -->i could not find my...

Hi All, We are using DataStage 8.0.1 and Oracle 10G Data Base. When I try to view the data from oracle enterprise edition stage from a data stage job I am getting following error message; "main_program: PATH search failure: main_program: Error loading "orchoracle": Could not load &quo...

Hi All, I am working in data stage version 8.0.1 I have a custom built stage in my respository. however when i am not able to find it in the data stage compilation wizard when I am trying to compile the custom built stage. I am able to find rest of the custom built stages in the compilation wizard a...

[quote="keshav0307"]DELETE FROM DS_JOBS WHERE NAME='<exact job name> and then import the job[/quote] I executed the following i was able to execute the stmt SELECT * FROM DS_JOBS WHERE NAME='<exact job name>' it is giivng me a message no records exist. I imported the job again from the des...

[quote="keshav0307"][quote]where do I type this SQL stmt. from oracle. [/quote] in datastage administrator command[/quote] i was able to execute the stmt SELECT * FROM DS_JOBS WHERE NAME='<exact job name>' and it is showing me the job exist. however i am not able to find the job in the rep...

[quote="ray.wurlod"]This suggests that the export file from which you are trying to import has job executables only, not design-time information. Create a new export, WITH design-time information, and import from that ...[/quote] Actually I am re-importing the job with actual design job. I...

[quote="keshav0307"]try this query
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'

what does it return?[/quote]

where do I type this SQL stmt. from oracle.

can you please explain.

Thanks
Mark