Hi Craig,
Thank you for your response.
the maximum number of columns are 150 columns.
Thanks and Regards,
Cheru.
Search found 44 matches
- Mon Nov 30, 2015 9:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field wise record count for different Files
- Replies: 4
- Views: 4436
- Mon Nov 30, 2015 7:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field wise record count for different Files
- Replies: 4
- Views: 4436
Field wise record count for different Files
Hi, Very good wishes to all! Could you Please assist on the question on Datastage technically for the below question. My question: Source file: Field1 Field2 Field3 abc 12f sLm 1234 hjd 12d Hyd 34 Chn My target file should generate the record count on field wise as below: Field1 has 4 values and fie...
- Thu Jul 31, 2014 5:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Explanation requested for standard schema file
- Replies: 1
- Views: 2162
Explanation requested for standard schema file
Hi, My application is reading fixed width data file thru sequential file stage with file pattern read method. The stage refers a schema file as shown below. Can anyone tell me the meaning of width in {} against the fields ? record {record_delim='\n', record_length=fixed, charset='UTF-16LE', delim=no...
- Tue Mar 04, 2014 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reading consecutive delimited fields as single field
- Replies: 5
- Views: 3178
reading consecutive delimited fields as single field
Hi, Please find the query below. Datastage = 8.5 (Parallel) OS = windows. Source data: ename,deptno,company,mobile rajesh,swami,10,IBM,99999 Expected output to be as shown below: ename = rajesh,swami deptno = 10 company = IBM mobile = 99999 Please suggest how to set the formate as comma delimer in s...
- Mon Apr 29, 2013 1:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get 30 days old date from current date
- Replies: 5
- Views: 4969
- Fri Apr 26, 2013 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get 30 days old date from current date
- Replies: 5
- Views: 4969
- Fri Apr 26, 2013 6:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get 30 days old date from current date
- Replies: 5
- Views: 4969
how to get 30 days old date from current date
Hi,
Please help how to get 30 days old date from current date .
Thanks and Regards,
Please help how to get 30 days old date from current date .
Thanks and Regards,
- Tue Mar 12, 2013 3:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Assign value for more then one record
- Replies: 3
- Views: 2749
- Tue Mar 12, 2013 3:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Assign value for more then one record
- Replies: 3
- Views: 2749
Assign value for more then one record
Hi, I have a requirement as shown below: Input Records: Coulmn1 Column2 123 AF XC RG qw aa POP aa RT NN FM AF OutPut Records: Coulmn1 Column2 123 XX XC RG qw XX POP XX RT NN FM XX If values for Column2 input file has repeated vlaue like more then one then those records should replace with 'XX', if u...
- Thu Oct 18, 2012 7:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mq stage for pulling .xml large files
- Replies: 2
- Views: 2319
Mq stage for pulling .xml large files
Hi, I am using Mq stage to pull the .xml files and store it to local path. if the .xml files size is small then the file is going good as expected. But when using the .xml files in mq more size for example 82.7 KB the file in the local path is truncating the records and when checked it has only 1024...
- Wed Oct 17, 2012 5:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get data before commas and pipe
- Replies: 5
- Views: 3174
To get data before commas and pipe
Hi, I have a quesion as below: IPfield Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012 should get a data like this below OPfield Nafta|Cafta|bafta Please note the IPfield data can more with pipes. for example i can also have data like: Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012|Cafta,no2,2012|bafta,n...
- Thu Oct 04, 2012 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To stop records after the value *
- Replies: 16
- Views: 9975
- Wed Oct 03, 2012 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To stop records after the value *
- Replies: 16
- Views: 9975
- Wed Oct 03, 2012 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To stop records after the value *
- Replies: 16
- Views: 9975
- Wed Oct 03, 2012 5:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To stop records after the value *
- Replies: 16
- Views: 9975
To stop records after the value *
Hi,
I have a question as below:
Input records:
SeqNo ValRecd
1 a
2 b
3 *
4 z
Should get out as below:
SeqNo ValRecd
1 a
2 b
The intension is not to process the records after the values '*' for ValRecd
Could please help to resolve... Thanks
I have a question as below:
Input records:
SeqNo ValRecd
1 a
2 b
3 *
4 z
Should get out as below:
SeqNo ValRecd
1 a
2 b
The intension is not to process the records after the values '*' for ValRecd
Could please help to resolve... Thanks