DSXchange

Hi All, I got a situation where I need to perform sub string operation. Can any one tell me how to do a substr action in Transformer ? Sample data: 2004041 xxx yyy34 This is a fixed length data. the desired out put is Output: year month week name code rowNo 2004 04 1 xxx yyy 34 So needs to perform a...

Thankyou for all the replies. i am closing the thread

ray.wurlod wrote:Environment variables set through the Designer client are stored in the DSParams file in the project. You can read from that. However passwords are stored in encrypted form, so you would need to be able to decrypt it.

can you please tell me how to decrypt the password

Is there a way that we can read the database parameters defined in the datastage adminstator through shell script. i wanted to invoke SQL from shell script and i need Dbname,dbusername,password from environemntal varibales

Thanks
AK

yes i want to test how job sequences handle job aborts

There are lot of sequencer jobs and i need to test them by executing them with various test cases.I saw in one of the forumn that we need to specify all cases in which every job in a sequencer aborts.But how actually we do that ..I mean we need to write any sql queries or something else

I am new to Datastage.My job is to execute test cases in front end testing.Can anyone give me procedure to do that.