DSXchange

Thanks Chulett for your reply! It is very simple query. it used to returns ~ 10 rows from source table. DBA said that DB is active and no problem in their end. I just wonder what could cause for hangs and no error message as well. Any standard steps to isolate the issue? So OCI directly look up tnsn...

Hi Gurus! In designer, I tried to view the data(Oracle Stage), as soon as i gave credentials, it hangs forever! Can expertise tell me what i should check first? like troubleshoot ODBC connectivity using ./ivtestlib? Do we have anything for oracle trouble shooting steps? Thanks Basheer Ahamed Malik

Thanks Guru!

Hi Gurus, Can we have two odbc entries with the same DB name only difference is server name? Thanks for your effort and time. I appreciated it. KFT_4875_STGQ29=NetezzaSQL Driver=/opt/nz/lib/libnzodbc.so Description=NetezzaSQL ODBC Servername=<serer1> Port=5480 Database=KFT_4875_STGQ29 CancelAsFreeSt...

Thanks for the information... Now I got it... Actually.. i have included both "- wait" as well as "- jobstatus". but it was given broken pipe error. so i decided to remove "- wait" option. I have got Error 81002 waiting for job Broken pipe.. without - wait or jobstatus....

Thanks for your reply.... i have script.... which follows first.ksh [ ... ... echo $DSHOME/bin/dsjob -run -param inputFile=${STRIPPED_FILE} -jobstatus ogip sortNMR > $SCRIPT/runCommandNMR `chmod 770 $SCRIPT/runCommandNMR` $SCRIPT/runCommandNMR echo "Procesing the script now" ksh $SCRIPT/sp...

Thanks for the reply....

I thought... dsjob -wait option would be applicable for another dsjob command not for script.

So its doesnt matter.. whether you are callling DSjob or script

Thanks for clearing my doubt...

Hi Everybody, I have question.. can anybody help regarding my problem. we have main script called first.ksh first.ksh [... ... .... $DSHOME/bin/dsjob -run -wait -param inputFile=${STRIPPED_FILE} -jobstatus ogip sortNMR ksh second.ksh output.txt .... ] dsjob will create one file.. which will be used ...

Hi ray

i checked that already...in that case i get the message " job is being accessed by another user".

This looks stange to me

Thanks

Hi all, I am using a server shared container in my parallel job. my job aborted because of some reasons (look up failure)...after correcting this i tried to compile my job and i got the following error message :CANNOT GET EXCLUSIVE ACCESS TO EXECUTABLE FILE FOR JOB another strange thing i found was ...

column length has been varied in the output Oracle table...

Hi, i am trying to create a oracle temporary table from datastage job. Oracle table should contain 3 columns with datatypes NUMBER (10) NUMBER (5) NUMBER (2) So, i am using the following datatypes in the DS job NUMERIC (10) NUMERIC(5) NUMERIC(2) Now, my job creates a table with the following datatyp...

ArndW wrote:That particular post only had a couple more words to it, but it is certainly worthwhile getting a premium membership.

Sure...Thanks for your help :D

The "EREPLACE" function doesn't exist in the PX transform stage, so the external sed function, perhaps in a wrapper, will work but might be just as slow as using a BASIC transform stage. In that case, ... Hi Arndw, your suggesstions are not appearing till the end...Some premium content ic...

This is more along the lines of a buildop in PX. If you can use server jobs then you could do some string manipulation in a loop, I'd use INDEX(In.Col,' OR ') to find the "or" statement, then go back ... Yes...Index function is returning the position of my "AND" Keywords... Plea...