DSXchange

Andyrids,
Ogmios is right, you should use folder stage as input to the XML input stage. Aslo check the style sheet settings.

Thanks,
Abhi.

Malin666,
Check your column descriptions, do you have /text() at the end of the column description.

Abhi.

Hi Shivan,
Hash Files can be used for manythingd, search for Hash Files and u will find a lot of information about it.

Thanks,
Abhi.

Hi lagrangeusa,
Use Tag.To.Date and I think it would sove ur problem.

Thanks,
Abhi.

Hi,
Ray I promoted the jobs using version control and have the same configurations.
Sai, I tried connecting to ouside DS and I am able to connect to the DataBase.

Thanks,
Sai.

Thanks Ray,
But I have the same privileges I have in the test box. The job is running with warnings in test and its fatal in prod. What exactly needs to be done with system tables.

Sai.

I know its not important but just wanted to add something that I learned recently.
If you are using DB2 plugin as a source or reference and ur using env variables as parameters then to view he data u need to select the user defined option to view the data.

Thanks,
Abhi.

Hi Devula,
Thanks for the reply, but I know how to set an user defined env variable, I am sorry for my miscommunication but I just wanted to know is that enough or did u do something more as I my job is still getting aborted after doing that.

Thanks,
Abhi.

Hi , Devula Can you please explain it elaborately as to how to set this env variable as i gave the env variable as you said but the job is still aborting, yes we are using DB2 version 8 And Ray i checked with my DBA and she says the privileges are the same in both boxes. If anybody had a similar pro...

Hi All, When I run a job in test box I get the following message as warning but the job runs successfully where as I get the same message in the prod box the job aborts, can anybody tell me what needs to be done. I am usng DB2 plugin stage. Error Message: [IBM][CLI Driver][DB2] SQL0471N Invocation o...

Hi All, When I run a job in test box I get the following message as warning but the job runs successfully where as I get the same message in the prod box the job aborts, can anybody tell me what needs to be done. I am usng DB2 plugin stage. Error Message: [IBM][CLI Driver][DB2] SQL0471N Invocation o...

ArndW,
Thanks a lot Arnd, I need simple coding for masking the SSN and EmpNames.

Thanks,
Abhi.

ArndW,
Can you be more elaborate as to how to mask the data or if have already built some jobs can you post some codes for me.

Thanks,
Sai.

Hi All,
Is there any technique in DataStage that will allow us to masked Productional data to create test data? We have a project that consists of sensitive data - ssn, hourly wage, name, address, etc. We would like to use good test data that is not production data.

Thanks,
Abhi.

Welcome itcconsulting,
I think thats how it should be, can you be more specific with ur problem.

Thanks,
Abhi