Hi,
Check in the Stage Properties of the Sequential File, In that you can find that Line Termination:
Unix Style
Dos Style
None
In those select the opton None.
This is what Kumar trying to say...
Search found 33 matches
- Fri Dec 15, 2006 1:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reading sequential file as a single field
- Replies: 14
- Views: 4790
- Mon Dec 11, 2006 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to handle the warnings when using the stingTodate
- Replies: 8
- Views: 3286
- Mon Dec 11, 2006 10:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Integer
- Replies: 3
- Views: 2015
- Mon Dec 11, 2006 1:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Avoiding of Job Abortion
- Replies: 1
- Views: 857
- Mon Dec 11, 2006 1:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: oracle stage array size
- Replies: 4
- Views: 1523
Hi, Array size determines the number of rows to be read from the database or number of rows write to the database at a single time. For example, for reading data from database, if it is 1, then for each and every row it will read the data from the database. If the array size is 10 for writing, then ...
- Mon Dec 04, 2006 11:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: file name
- Replies: 9
- Views: 3334
Hi Srini, Do you mean that passing values (file names) at run time. If yes, you can follow this way: 1) Choose Edit-->Job Properties-->Parameteres 2)In the dialog box you can create your new parameters and also you can assign default values to them. 3)Assign those parameters to the stages. 4)You can...
- Thu Nov 30, 2006 6:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage
- Replies: 12
- Views: 8240
- Thu Nov 30, 2006 3:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing Values to a After-SQL.
- Replies: 3
- Views: 1188
- Thu Nov 30, 2006 2:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UNION ALL v/s FUNNEL Design Issue
- Replies: 6
- Views: 13238
Balaji, I think it is better to use your first option ie by using the UNION ALL command in DB2 API Stage for combining your tables. Or otherwise if you are using Funnel stage then it is better to use the 'Sequence funnel' bcoz this property copies whole data from first table and loads into target an...
- Tue Nov 28, 2006 6:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: is sorting before joining mandatory?
- Replies: 4
- Views: 3399
- Mon Nov 27, 2006 7:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Info regarding DSJ.INSTROWCOUNT
- Replies: 2
- Views: 1362
- Sun Nov 26, 2006 11:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading XML files:XSLT Error
- Replies: 10
- Views: 3616
- Fri Nov 24, 2006 2:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: EXCEPTION HANDLER not working.
- Replies: 4
- Views: 3112
- Wed Nov 22, 2006 6:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need to enter job run details to audit table
- Replies: 8
- Views: 3145
- Wed Nov 22, 2006 2:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation error for Tranformer in windows
- Replies: 3
- Views: 1382