DSXchange

Dear All, Our company is in process of upgrading DB2 version 8 to DB2 version 9.5, just need to find out is DataStage version 7 is compatible withe DB2 version 9.5. I have seen few post on the forum mentioning that you can connect with Db2 Api Stage but not with DB2 Enterprise Stage, just want to ge...

Hi CNGUYEN,

Did you manage to get DB2 EE stage working, if yes, is it possible to get the patch number please.

Many Thanks And Regards
Jay

Dear All I'm getting following error message while running job with MQ Stage. WebSphere_MQ_Connector_7,4: [IIS-CONN-WSMQ-000005] System call dlopen() failed with OS error 2 (No such file or directory) (CC_WSMQUtil::resolveMqiMethodPointers(), file CC_WSMQUtil.cpp, line 335) [IIS-CONN-DAAPI-000050] M...

datisaq,

Where is your DataStage server installed.



Regards
Jay

Are you reading and writing to the same dataset.

Chullett

Thanks for your reply.

I'll mark the post as solved.

Dear All

Is it possible to export DataStage job without Exporting job executables using dscmdexport.

Please advise.

Regards
JK

Raghu, I think you are getting this message because you are performing calculation on a non numeric data. Please check you data. Regards Jay Hi All, I am getting this warning message while running the datastage job. "DataStage Job 2611 Phantom 16948 Program "JOB.46533426.DT.1435533317.TRAN...

Mfanas, You can achieve this using LINK COLLECTOR only if the metadata is same on all the files. Regards JK Hi guys, I need to load more than one file into DB2 tables using Datastage, I tried using the Folder stage but everything was written into one line and my sql script to extract substrings in t...

Ken


Thanks for the reply.

Could you please give the name of the parameters needs changing i UVCONFIG file.

Many Thanks

JK

Dear All

I'm getting the following error while running 10 multiple instance jobs simultaneously via Unix script.


Error running job

Status code = -14 DSJE_TIMEOUT
Echoing:
The return code is: 99

Thank you
JK

Ray/Craig


Thank you very much for your reply.

Permission issued has been solved.


Regards
JK

Craig When i drop the table from UVSH i get the following message on the screen. >DROP TABLE CUS_REF_99; Dropping Table CUS_REF_99 rm: directory /usr/users/khartij/datastage/hash/CUS_REF_99 not removed. Permission denied Could not delete file CUS_REF_99. continuing ... rm: /usr/users/khartij/datasta...

Craig


I tried using TCL in Before-job subroutine, but the job aborts.

TCL = DROP TABLE TEST_01


Many Thanks

JK

Craig


Can we use (DROP TABLE TABLE_NAME;)
in server routine or in Befor-job and After-job subroutine. Please advise.


Many Thanks
JK