DSXchange

Thanks for your valuable inputs Mike..

so, is any command available to export the jobs by category wise in ds8.1? also my requirement is the out put dsx will be in readable format..

Please advise..

Hi All, My requirement is - export all the jobs by folder wise and remove the passwords which are hard coded in the dsx. all should be done in command mode. I exported the folder with istool export command, but it's not a readable format to remove the passwords in the dsx Could you please advise. Th...

I am getting the error 40812Unable to create stage editor object whiloe i was opening the job properties.
I uninstallle datastage and insatlled it for couple of times.But i am getting the same error.
Please suggest me on this error.
Thanks in advance.

regards,
srikanth
8805598302

Yaaaaaaaaa...I got it.

I did Tools\Clear Status File..now I am able to compile..

I got the below log in the job.

Message:
Clearing file RT_STATUS2525

Thanks for your all help.

Regards,
Srikanth

Hi All, I have a requirement to capture the reference data which is not matching with the master data set. How could we implement in DataStage using a single stage means either Transformer or Lokkup or Join or Merge? definitely we can use the merge stage to capture the secondary(i.e ref ) dataset b...

Server routines are written in Basic language and called in server job environment but the Parallel routines are written in c++ language(not in basic level language) and called din parallel job environment......

No Kalyan, I am working in production server. is there any other way please.

Thanks Kalyan..

Yesterday I did same kalyan.. save as the job and its finished successfully. but the problem is why the original job unable to compile.

Thanks for Reply... I checked with ds.tools in admin, there is no locks for this job. please find the below more details. 1. previous run I did some changes in the select query, then I ran the job and its finished successfully. 2. Now I replaced with old query and successfully saved it, but I am una...

Hi Team, I am getting below error when compiling one server job. "Cannot get execlusive access to executable file for job <job name> - job may be being monitored. and when I click Show Error tab.. I am getting below. (40908) A request for an object with a NULL ID was made Please advise and Than...

For eg: I dont know exact job name..in this case how to find!!

Hi,

How to find a particular job in datastage director.

Hai,

I am getting below error when reading from oracle table. please let me know.

main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG

Thanks in advance

For eg. If we are using Auto partition. the datastage takes depending on the data and depending on stages it selects best partion method. My question is, is there any method to chek which partition datastage is using.

When we are having reference table contain more data than primary file, we will use sparse lookup. make sure before doing lookup trim the ADDRESS_LINE_4 field.