DSXchange

vskr72

There are other tables in that schema that can be loaded withgout issues. I was just wondering how there could be an issue just for this one.

vskr72

I am getting the follwoign error when I am tryign to load data into a Ora table using Oracle Connector. The table does exst. The same jobs worked using Enterprise stage. Theconnector is running on 2 nodes. I am trruggling with this error: DACT_DAILY,1: The OCI function OraOCIStmtExecute returned sta...

vskr72

I have a column from a text file as '0000000045788999' and I need to do the following: 1. need to perform a decimal validation on it for decimal[18,2]. 2. For this I am dividing it by 100 to see if its a valid decimal 3. then set T or F based on the outcome. When I divide by 100, its becoming as 4.5...

vskr72

I have a simple job which loads data from a EBCDIC file to a table. I have a Pivot stage between SRC file and Target table. This is a horizontal pivot. When I try to compile I get this error. I have other jobs which compile good. So its not a compiler issue. Any inputs pls. Thanks. Output from trans...

vskr72

I have a job that read a Seq file and some transformation before the data loads into a table. This job is parameterized to read 2 types fo files (lets say A and B). Some times based on the availability of A and B file, the job could have two run instances at the same time. Other times it could be se...

vskr72

I have the following recrods from a file. (I am showing only 1 colunmn for simplicity). I haev to perform a Date validation and if it fails, then I need to write it to a flat/reject file. The data is coming from a fixed with file. The constraint I have is like this: NOT(Isvalid ("date", Da...

vskr72

We have a requirement to do the following in our project: - Poll for file. If it does not come by X secs, then send a DList , then continue to poll. If it does not come by Y secs send an email to different Dlist and continue to poll. If it does not come by Z secs, then continue to poll and exit. - O...

vskr72

Thank you Ray. No wonder you are called the 'Guru'.

vskr72

We are using datastage 8.5 and I have a script that calls the datastage job. There is no issue calling the job and executing it. But after the sucessful run I am not getting the correct return code. The followiong is the DS job call I have in the script sudo -u dsadm -g dstage ${DSHOME}/bin/dsjob -r...

vskr72

GIves me this msg:

Code: Select all

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory

vskr72

GIves me this msg:

Code: Select all

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory

vskr72

Without the Sudo I realized that I do not have permissions and I requested. So they said they gave me permission and that it will only work with the sudo option. The way they suggested is before you call the dsjob command put 'sudo -l -u dsadm'. This the little background.

vskr72

THis is what I get in the TmpFile

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -wait -warn 0 -jobstatus -mode NORMAL DEV_EDW master

vskr72

THis is what I get in the TmpFile

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -wait -warn 0 -jobstatus -mode NORMAL DEV_EDW master

vskr72

The user that I log into does not have permissions. So, I as suggested to use sudo to implement it. When I used sudo, and see the output, I get the return code value as 0 and the job is not running. Not sure what this means. Does this implementation ever work? sudo -l -u dsadm ${DSHOME}/bin/dsjob -r...

DSXchange

Search found 126 matches

Oracle Connector issue

Decimal Validation

Issue with CFF stage

Multi Instance Job

Help in constraint for Date validation

Implementation Diffferences Shell Script vs Datastage

Datastage Return code

Running job with dsjob when user does not have permissions