DSXchange

[quote="shilpa79"]Can anyone comeup with any answer for the above error:[/quote]

I really doubt if you can use FTP stage for XML files. Because FTP stage can not interpret XML files. May be you can use Unix FTP for file transfer, and by using XML stage you can interpret the XML file.

May be you can do something like this... 1) LISTFILE= <parameter values created by 1st job> 2) Shell Script: Prepare comma delimited parameter string SWITCH=0 while read NextValue do if [ $SWITCH -eq 1 ] then ParameterX="$ParameterX," fi SWITCH=1 ParameterX="$ParameterX\'$NextValue\'&...

I heard that there are some issues with FTP stage in PX. I'm not sure if this is one of the issues.

Why don't you use regular FTP. I mean unix FTP. Write a shell script and transfer the file.

Sreeni.

I think you can do this in 2 passes. 1- I think we need to merge both the good and bad . 2- then sort the good and bad based on some commom key ! 3- assign some surrogate key to track the records . i.e assign a sequence number 4- collect the bad records and good records into a2 seperate files. 5- Ta...

Which version of DS you are using? In DS 7.5 this feature is available.
In the sequencer job, go to properties and check the box for "Add checkpoints so sequence is restatable on failure". I believe this feature is available from DS 7.5, not before.

Kumar, Have you ever used CFF stage in PX job? Would it be possible for you to share a sample job? Because I have tried a lot with just simple data and I could not make it work. Any help would be greatly appreciated.

My emailID is bsreenu@yahoo.com, please send me if you have any sample jobs.

I need one too. If you can send it to me at bsreenu@yahoo.com that would be great.

We have the same situation as described above and we are unable to use CFF stage (in PX). Is there any solution yet? I want to know if CFF stage(in PX) can handle multiple record types?And how? Each record type has a different record layout. And each records is delimited by newline char (\n) Thanks..!

I'm not sure you guys have any solution yet, but I had a same situation and I did this in a different way. The job was processed 400million rows in less than 20min. This is how i did in PX 1) Sort the data on key column and "Hash" partition the same data on key column (using Sort stage). T...

Thanks Brad..! We are getting the file from a unix system (as FTPed) from a different source. We do not have any control the way we are getting the file from different source. I'm able to convert these decimal data to actual display format using sequential file stage. But I could not do this using C...

Thanks Brad..! Thanks for your informaion.

But my input is Text-ASCII. I still don't know how to fix it in CFF. So I'm handling this data using seqiential file stage. And I'm not sure CFF stage can handle if the file has five different variable length records (or segments). Any help would be great.

Hi, I'm getting a some error while reading decimal data in CFF stage. Here is an example: Column=Salary Decimal (5,2) Sign on Trailing Currently this column is configured as Cobol layout= PIC S9(3)V9(2) Sign is trailing Record type= Variable Data format= text Character Set= ASCII 1) Input data= 9875...

We have a sequesncer which starts 10 PX datastage jobs at the same time. If any one of the PX job abends, we want to stop all the remaining running jobs. We have been using the routine "UtilityAbortToLog" for killing all the running jobs. But that doesn't seems to work as desired. Can some...

Every run of the sequencer will have a new input every hour. So we need to run the sequqncer and the corresponding 5 px jobs(whcih are started by sequencer) ever hour. We are able to pass the invocation id to the sequencer. How do we pass the invocation id to the lower level 5 px jobs. We can see an...

We have a sequencer which starts 5 Parallel Datastage jobs. The sequencer is started every 1 hour from a shell script using 'dsjob' command. What is the command to run multiple instance of the sequencer? Will the sequencer be able to start all the 5 datastage jobs which may be already running throug...