Search found 24 matches
- Tue Dec 28, 2010 1:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Special Characters in a String
- Replies: 6
- Views: 9462
- Mon Mar 01, 2010 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: creating a fixed width file with different header size
- Replies: 1
- Views: 1466
creating a fixed width file with different header size
Need to create a fixed width file with a header record, followed by detail records and followed by a trailer record in a same file with different header size. Ex:- header record should be with of 120, detail records size should be 80 and trailer record width of 80. These all should go to same file. ...
- Thu Aug 20, 2009 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date column
- Replies: 7
- Views: 2983
Re: Date column
[quote="reshma11"]How to add 2 years to system current date.
Thanks.
only 2 years increment and the format should be YYMM
Thanks.
only 2 years increment and the format should be YYMM
- Thu Aug 20, 2009 1:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date column
- Replies: 7
- Views: 2983
Date column
How to add 2 years to system current date.
Thanks.
Thanks.
- Thu Aug 20, 2009 10:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Column format
- Replies: 1
- Views: 1239
Column format
How do I get last 7 digits of a given number.
For ex: 1234567892
I need only last 7 digits 4567892
Thanks
For ex: 1234567892
I need only last 7 digits 4567892
Thanks
- Tue May 26, 2009 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
it is working
#!/bin/ksh
$var
var=`cat /***/***/test.txt | wc -l`
echo "row count : $var" > /***/**/test1.txt
cat /***/***/test1.txt >> /****/***/test.txt
Thank you.
$var
var=`cat /***/***/test.txt | wc -l`
echo "row count : $var" > /***/**/test1.txt
cat /***/***/test1.txt >> /****/***/test.txt
Thank you.
- Thu May 21, 2009 1:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
- Thu May 21, 2009 1:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
- Thu May 21, 2009 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
- Thu May 21, 2009 12:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
- Thu May 21, 2009 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
Error
I am getting this error
Test1..AfterJob (ExecSHSilent): Error when executing command.
*** Output from command was: ***
/**/***/***/test.ksh[2]: var: not found
cat: input/output files '/***/***/test.txt' identical
Test1..AfterJob (ExecSHSilent): Error when executing command.
*** Output from command was: ***
/**/***/***/test.ksh[2]: var: not found
cat: input/output files '/***/***/test.txt' identical
- Thu May 21, 2009 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
- Thu May 21, 2009 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row count header to the sequential file
- Replies: 17
- Views: 6037
row count header to the sequential file
I need a header to a target sequential file showing how many records getting from source to target sequential file whenevery this job runs. How can I do this. Any help on this would be appreciated.
Thanks.
Thanks.
- Wed May 20, 2009 9:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to get all flat files into one flat file
- Replies: 6
- Views: 2493
can do it in sequential file stage
In sequential file stage options filter = awk ' BEGIN { print "#pHEADER#"; } { print; } END { print "#pTRAILER#"; } '
Thanks
Thanks
- Tue May 19, 2009 12:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to get all flat files into one flat file
- Replies: 6
- Views: 2493