DSXchange

Use the Complex File Format DataStage, specify the input file as EBCDIC for the NLS setting. Then you can use OConv(Iconv()) function in transformation to convert to decimal. Hope this will work.

Regards,

Thanks to all. Special Thanks to Guru (Kim). It's working. Once again thanks to all.

Thiruma Valavan.

Craig,
I want to write a server Job using Script only. I am having the problem is how to specify a fixed width file in a script. Please help me on this issue.

Regards,

Thiruma Valavan.

Hi, I am getting back a status file. I have to open the file and check the exact position of the record in the file and based on this I have to other action like (sending mail if it is not success or change the status of the processed record if it is success) The file name is StatusSpot.txt And reco...

Hi, This is what I did as same as your requirement. First, I created a job using the Folder Stage with output column (1) Docname (filenames) to a sequential file then I transferred this to a hash file in the same Job. Then, I created another Job (Job3), which will accept the File name & File pat...

Kenneth,
Thanks again. I used the Parameter itself. It's working fine. Thank for your guidance.


Best Regards,
Thiruma Valavan

Kenneth, This command line ' NTcmd="dir ":YourDirectoryPathParameter:"*.dat /b" ' is the ":YourDirectoryPathParameter:" is a Parameter. For eg. My Path is "D:OFDMWingsDaily" and the file names doesn't have any extension like "DAT". How will you hard ...

nvkravi,
Usually, I use to reboot the server.

Regards,

Best Regards,
Thiruma Valavan

I created a Job for to conversion of a flat file. But the file name is not fixed. So I created another Job to get the file names in the directory and moved to the Hash file. Now, how to read the hash file in a loop and call the Job and pass the value for all the file name in the Hash file. I Hashkey...