Search found 230 matches

by naren6876
Thu Mar 01, 2007 8:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: awk command
Replies: 11
Views: 3607

I don't understand why that you didn't get a syntax error when you issued: awk '{ printf }' x.xml > y.xml I ran the above statement on the command line; I got the following: awk: Syntax error Context is: >>> { printf } <<< If I put a space between 'print' and 'f', awk '{ print f }' x.xml > y.xml, i...
by naren6876
Wed Feb 28, 2007 8:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: awk command
Replies: 11
Views: 3607

You need at least a format string. ... i have been using awk '{ printf }' x.xml > y.xml for the past 6 months without any problem. i have changed the code to awk '{ print $0 }' x.xml > y.xml and its working fine now.But, i dont know how to explain it to my boss. he is asking why it has worked till ...
by naren6876
Wed Feb 28, 2007 8:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: awk command
Replies: 11
Views: 3607

A printf action looks like this: { printf format-string, value, value, ... } The format-string indicates the output format. The given values give the data to be displayed. That's why you got "Insufficient arguments" error for awk '{printf}'. can't we use awk '{ printf }' without arguments...
by naren6876
Wed Feb 28, 2007 6:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: awk command
Replies: 11
Views: 3607

kumar_s wrote:It may be restriction of awk input argument that limited to 199.
Since $0 reads as whole line, you might not got it. Anyway whats is the error that you get? ...
Insufficient arguments for awk '{printf}'.
by naren6876
Wed Feb 28, 2007 6:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: awk command
Replies: 11
Views: 3607

$0 returns the whole line. Where I guess, printf receives each word as argument and prints out. So the alignment might vary. But I dont think you get the work truncated. Btw, where are you using this, and whats your effect of output? I'm using it in a shell script. My source is a XML file and it ha...
by naren6876
Wed Feb 28, 2007 5:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: awk command
Replies: 11
Views: 3607

awk command

Hi, when i use the following command awk '{ printf }' x > y data is truncating. when i use the following command awk '{ print $0 }' x > y data is not truncating. is something related with new line character or anything else? what could be the reason?. please shed some light on this. thanks in advance.
by naren6876
Wed Jan 24, 2007 12:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to compile Sequence job variable 'Trim' not defined
Replies: 13
Views: 2158

ArndW wrote:It sounds like you have a corrupted or edited DSParams file - can you find the reference to the "Trim" function in there or is it gone?
it's gone.

I didn't see anything else other than 'Alpha'

thanks.
by naren6876
Wed Jan 24, 2007 11:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to compile Sequence job variable 'Trim' not defined
Replies: 13
Views: 2158

DSguru2B wrote:That should not happen. You should be able to see all the function under String. Do you see the same behaviour in your Dev box? ...
i can see all the functions in my Dev box.
by naren6876
Wed Jan 24, 2007 11:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to compile Sequence job variable 'Trim' not defined
Replies: 13
Views: 2158

I can't see anything wrong there at all, except that the SUBSTRINGS function is meant to be used with dynamic arrays; it will work here because you only have one element; but I would prefer to see "BeginLoop.$Counter[1,1] = 'Z'" used instead - neverthe less it shouldn't affect your error....
by naren6876
Wed Jan 24, 2007 11:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to compile Sequence job variable 'Trim' not defined
Replies: 13
Views: 2158

ArndW wrote:Naren6786, my only thought right now is that we still don't know the exact syntax or your ds version. ...
I'm using ds 7.5 server edition.

Trigger expression is:

Trim(BeginLoop.$Counter) = 'x.sh' Or Trim(BeginLoop.$Counter) ='y.sh' Or Substrings(BeginLoop.$Counter,1,1) = 'Z'


Thanks,
by naren6876
Tue Jan 23, 2007 12:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to compile Sequence job variable 'Trim' not defined
Replies: 13
Views: 2158

Could you please post the code in your trigger condition; it sounds like you might have some sort of a syntax error. same job is working fine in Dev region. When i checked for functions by right click.. I can see only 'Alpha' under String functions. Why is that so?. Any idea please. Thanks in advan...
by naren6876
Tue Jan 23, 2007 11:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to compile Sequence job variable 'Trim' not defined
Replies: 13
Views: 2158

Not able to compile Sequence job variable 'Trim' not defined

I have used a Nested condition activity in my sequence job. In that expression link i have user 'Trim' and 'Substrings' functions. When i tried to compile that job it gaves some error message like: Activity Nested_condition1: Trigger Expression lnk_aa - Variable 'Trim' not defined. what does it mean...
by naren6876
Thu Dec 28, 2006 5:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of DataStage
Replies: 7
Views: 1949

DSguru2B wrote:In one of the results roy got the same error. All he did was re-compile the job and that took care of it. Try that. ...
If it is in production, how do you explain it to yoour boss?
I can't say like just need to re compile right.
we need to give the permanant solution.

Thanks.
by naren6876
Wed Dec 27, 2006 8:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of DataStage
Replies: 7
Views: 1949

Search is your friend. Do an exact search on "Layer type is BASIC run machine" ... I went through all the posts. In my job ,i'm reading the BLOB object from oracle table and place that in a folder. This is the forst time it got aborted in last 6 months. Is this related with BLOB issue?. s...
by naren6876
Wed Dec 27, 2006 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of DataStage
Replies: 7
Views: 1949

Abnormal termination of DataStage

Hi, I am getting the following error. From previous run DataStage Job 258 Phantom 20761 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program DSP.Open at address 4d4. what would be the reason and how i can fix it?. any clues would be hi...