DSXchange

You can use convert function in transformer stage.

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. ...

[quote="reshma11"]How to add 2 years to system current date.

Thanks.

only 2 years increment and the format should be YYMM

How to add 2 years to system current date.

Thanks.

How do I get last 7 digits of a given number.
For ex: 1234567892
I need only last 7 digits 4567892

Thanks

#!/bin/ksh
$var
var=`cat /***/***/test.txt | wc -l`
echo "row count : $var" > /***/**/test1.txt
cat /***/***/test1.txt >> /****/***/test.txt

Thank you.

I correted it to #!/bin/ksh var = `cat /runway/interfaces/test.txt | wc -l` echo "row count : $var" > /runway/interfaces/test.txt cat /runway/interfaces/test.txt >> /runway/interfaces/test.txt run the job, but getting this error bash-3.00$ sh test.ksh test.ksh: var: not found cat: input/ou...

I am kind of novice in writting unix scripts, please excusme me if i am doing any wrong.

#!/bin/ksh
$var
var = 'cat /***/***/test.txt | wc -l'
echo "row count : $var" > /***/**/test.txt
cat /***/***/test.txt >> /****/***/test.txt

Thanks for your help

I am kind of novice in writting unix scripts, please excusme me if i am doing any worng.

#!/bin/ksh
$var
var = 'cat /***/***/test.txt | wc -l'
echo "row count : $var" > /***/**/test.txt
cat /***/***/test.txt >> /****/***/test.txt

Thanks for your help

Getting same error in unix too. something problem with script.

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

I have a source oracle table,transformer and sequentail file. when i run this job i want to see number of records count + all records in sequentail file.

row count: 2

column1 column2
1 XXXX
2 XXX

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.

In sequential file stage options filter = awk ' BEGIN { print "#pHEADER#"; } { print; } END { print "#pTRAILER#"; } '

Thanks

I am generating them separately and I need to combine them afterwards. How can I do that.