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

naren6876 · Post by **naren6876** » Tue Jan 23, 2007 11:25 am

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

Any input will be highly appreciated.

Thanks in advance.

ArndW · Post by **ArndW** » Tue Jan 23, 2007 11:31 am

Could you please post the code in your trigger condition; it sounds like you might have some sort of a syntax error.

chulett · Post by **chulett** » Tue Jan 23, 2007 12:02 pm

And post your exact 7.x version of DataStage.

naren6876 · Post by **naren6876** » Tue Jan 23, 2007 12:03 pm

ArndW wrote: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 advance.

ArndW · Post by **ArndW** » Tue Jan 23, 2007 12:49 pm

Naren6786, my only thought right now is that we still don't know the exact syntax or your ds version.

chulett · Post by **chulett** » Tue Jan 23, 2007 12:50 pm

Exactly... neither question was answered.

naren6876 · Post by **naren6876** » Wed Jan 24, 2007 11:17 am

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,

ArndW · Post by **ArndW** » Wed Jan 24, 2007 11:40 am

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.

Is this expression in one of the output conditions? The error indicates that "TRIM" is not detected by they compiler as a keyword. This can happen if you do something like "TRIM['string']" by mistake where the compiler will try to interpret it as an array (but usually the error message is different).

Are you having other problems with jobs promoted from Dev to wherever they are now?

naren6876 · Post by **naren6876** » Wed Jan 24, 2007 11:52 am

ArndW wrote: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.

Is this expression in one of the output conditions? The error indicates that "TRIM" is not detected by they compiler as a keyword. This can happen if you do something like "TRIM['string']" by mistake where the compiler will try to interpret it as an array (but usually the error message is different).

Are you having other problems with jobs promoted from Dev to wherever they are now?

after deleting the SUBSTRINGS function from there,still it gives the same compilermessage.

variable 'Trim' not defined.

I have checked the available functions by right click in the expression box and under functions- under String i didn't see any function other than Alpha.

any clue pls.

thanks in advance.

DSguru2B · Post by **DSguru2B** » Wed Jan 24, 2007 11:55 am

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?

naren6876 · Post by **naren6876** » Wed Jan 24, 2007 11:56 am

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.

ArndW · Post by **ArndW** » Wed Jan 24, 2007 12:10 pm

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?

naren6876 · Post by **naren6876** » Wed Jan 24, 2007 12:12 pm

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.

ArndW · Post by **ArndW** » Wed Jan 24, 2007 12:22 pm

Assuming you aren't trying your job in production, you might try to copy your development DSParams file to this location and see what happens; make a copy of this possibly corrupt DSParams file just to be on the safe side. Can you see the Date/Time modified for this file and try to figure out who or how it was corrupted?