Search found 5 matches
- Thu Sep 10, 2009 4:01 am
- Forum: General
- Topic: Use account name option in Hashfile stage
- Replies: 2
- Views: 2616
Use account name option in Hashfile stage
Hi, I have a job that writes data into a hashfile. When I look into the hashfile stage, the use account name option is used and the file name in the input stage is a job parameter. I can view the contents of the hashfile using view data option but where can I actually find this file? Thanks for all ...
- Wed May 06, 2009 6:33 am
- Forum: General
- Topic: Job fails due to unable to open a file error
- Replies: 6
- Views: 2721
Thanks for your reply. The EXIT command is just used to withdraw from the current DOS session. I tried using The EXIT command with the replace command(I was replacing a huge file which would obviously take some time) on command prompt and it seems to me that the EXIT command is executed only after t...
- Tue May 05, 2009 6:57 am
- Forum: General
- Topic: Job fails due to unable to open a file error
- Replies: 6
- Views: 2721
Job fails due to unable to open a file error
We have a job with a before job subroutine ExecDOS and Input value START REPLACE \\PATH A\*.* \\PATH B /a &EXIT & This job runs everyday as part of a scheduled batch but sometimes it fails with below error DSD.SEQOpen Failed to open A.txt in directory PATH B STATUS = 2. Unknown error ocurred...
- Fri Nov 21, 2008 6:11 am
- Forum: General
- Topic: Copy column and derivation in Transformer stage to document
- Replies: 6
- Views: 6759
- Wed Nov 19, 2008 11:53 pm
- Forum: General
- Topic: Copy column and derivation in Transformer stage to document
- Replies: 6
- Views: 6759
Copy column and derivation in Transformer stage to document
We are documenting details regarding our datastage jobs.Sometimes we need to copy columns and their derivatons in the transformer stage to a word document or excel sheet. If a table has 50-100 columns,it is difficult to copy these columns and their derivations one by one.Is there a way that we can c...