[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.
Search found 22 matches
- Fri Dec 15, 2006 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Stage
- Replies: 15
- Views: 7317
- Tue Dec 12, 2006 11:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HowTo parametrize dataset?
- Replies: 12
- Views: 5808
- Fri Dec 01, 2006 11:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with FTP PLUGin stage when used for FIXED Width file
- Replies: 9
- Views: 4573
- Fri Dec 01, 2006 11:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: before record and after record !
- Replies: 4
- Views: 2103
before record and after record !
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...
- Fri Jan 20, 2006 12:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence
- Replies: 5
- Views: 3236
Sequence
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.
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.
- Thu Jan 19, 2006 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple record structure flat file
- Replies: 16
- Views: 9847
multiple record structure flat file
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.
My emailID is bsreenu@yahoo.com, please send me if you have any sample jobs.
- Wed Jan 18, 2006 2:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sample parallel job with cff
- Replies: 6
- Views: 2099
sample parallel job with cff
I need one too. If you can send it to me at bsreenu@yahoo.com that would be great.
- Wed Jan 18, 2006 12:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: creating multiple output record layouts based on rec type
- Replies: 15
- Views: 10657
CFF-creating multiple output record layouts based on rec typ
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..!
- Wed Jan 18, 2006 10:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transpose a row Question in Parallel jobs
- Replies: 18
- Views: 9740
Transpose a row Question in Parallel jobs
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...
- Wed Jan 18, 2006 9:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File Stage(DS 7.5) - Decimal data types
- Replies: 5
- Views: 5740
Complex Flat File Stage(DS 7.5) - Decimal data types
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...
- Mon Jan 16, 2006 4:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File Stage(DS 7.5) - Decimal data types
- Replies: 5
- Views: 5740
Complex Flat File Stage(DS 7.5) - Decimal data types
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.
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.
- Fri Jan 13, 2006 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File Stage(DS 7.5) - Decimal data types
- Replies: 5
- Views: 5740
Complex Flat File Stage(DS 7.5) - Decimal data types
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...
- Thu Jan 06, 2005 8:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to stop PX jobs
- Replies: 1
- Views: 1568
How to stop PX jobs
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...
- Thu Jan 06, 2005 7:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to run multiple instances of sequencer using dsjob
- Replies: 4
- Views: 5137
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...
- Thu Jan 06, 2005 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to run multiple instances of sequencer using dsjob
- Replies: 4
- Views: 5137
How to run multiple instances of sequencer using dsjob
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...