Search found 5 matches

by ColinGorman
Tue Apr 28, 2009 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading the file names in a directory
Replies: 6
Views: 3514

Re: Reading the file names in a directory

A simple script will do. Go to the source directory

$ls >> tgt_path/tgt_file
by ColinGorman
Tue Apr 07, 2009 9:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Running AWK
Replies: 14
Views: 6380

Re: Error Running AWK

Try to use a simple awk command like, to print "Hello World" and check to make sure awk is working.
by ColinGorman
Tue Apr 07, 2009 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Running AWK
Replies: 14
Views: 6380

Re: Error Running AWK

Where is the DataStage Server residing? i.e., Unix or Windows.
by ColinGorman
Tue Apr 07, 2009 4:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Running AWK
Replies: 14
Views: 6380

Re: Error Running AWK

Where is the DataStage Server residing? i.e., Unix or Windows.
by ColinGorman
Fri Feb 20, 2009 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Invalid date from the source file
Replies: 5
Views: 4024

Re: Removing Invalid date from the source file

PX:: There is function ""IsValid"" under Type Conversion Functions to check if its valid date or not. If you can use basic transformer or basic routine...... ---- Here Arg1 is your InputColumn. If Arg1 = Oconv(Iconv(Arg1,"D/MDY[2,2,4]"), "D/MDY[2,2,4]") Then x...