DSXchange

Thanks for you suggestions.

Regards,
-Sumit

Hi All, I have a job that reads a sequential file. The sequential file has a column called TRANSACTION_ID and the input file is sorted by TRANSACTION_ID. I need to split the input file into as many files as the number of distinct TRANSACTION_ID in the source file. What I am doing right now is the I ...

Hi All, I have a sequencer in which I am using the LOOP stages (introduced in version 7.5). With in the loop I have a Routine Activity stage and a Job Activity Stage. In the Routine activity stage I read a hash file. The value returned by the Routine activity stage is used by Job activity stage to c...

Thanks Ray, I could find that in the manual.

Thanks and Regards,
-Sumit

Ray, I could not find SADD function anywhere. Where do we have it.

Regards,
-Sumit

Thanks wdudek. That makes it very clear.

Thanks,
-Sumit

Thanks Baha.

-Sumit

Try using a stage variable and in its description apply the logic to select one of the two different fields. Now pass the value of this stage variable to the shared container. Thanks and Regards, -Sumit I am using a shared container to look up a surrogate key for a given natural key. However, the pr...

Baha, the files will be in the same network. You could also do a similiar script from the Unx side so that datastage fires off the ftp command to get the fiels from the windows server. wdudek, from the Unix machine can I open an FTP connection to any Windows machine in the network OR it is something...

Hi Ketfos, "Open" does not seem to be a recognised command in DOS. Is it required for the Windows system to host an FTP server to be able to understand this command? OR is this command recognised only when issued using a bat file?

Thanks and Regards,
-Sumit

Thanks Ketfos. What I understand by going through it is that using NFS the Source File owners should be able to post the file directly to the DataStage host machine. Now this becomes a security issue because a lot people would then be accessing the AIX box. I would still look forward for the suggest...

If they can post the files to a windows server running ftp, you could use datastage and the command stage to ftp the files off of the windows server and back to the unix environment. We do the opposite in our environment going from datastage on nt to Unix. You could also set up and NFS drive on the...

Hi All, In our project we have a lot of jobs that read data from a sequential file. These source files are provided to us by a different team through an email OR they post them to a Shared Drive in a Windows platform. We then need to FTP these files to the DataStage host system which is an AIX box. ...

Thanks Craig.

-Sumit

Thanks a lot. One more clarification. "First line is column names" in the Output\Format tab means that while reading the sequential file it will ignore the first record and start the data processing from the second record. Am I correct?

Thanks and Regards,
-Sumit