DSXchange

As far as I know - you don't setup DataStage for this, you setup your pc. What NLS_LANG setting is your pc set to? My Computer / Properties / Advanced / Environment Variables I have no NLS_LANG setting on my client machine, on unix server machine for dsadm user there is NLS_LANG=POLISH_POLAND.EE8IS...

Thanks a lot. I will start using ASSIGNED and UNASSIGNED functions regurarly.

Best regards,
Piotrek

Ascen - say again? The INDEX function will return a 0 if the 1-char len value of the variable "cp" is not found in the string otherwise it will return a value. An condition in DataStage BASIC evaluates to 0 or '' as being the equivalent of false and anything else to be TRUE. But I think i...

Is "default" in the Nvl function a hard coded value or a variable? If it's a variable, does it have a value assigned on every possible path through the code? default - an argument of the routine When I wrote post about that the phantom was caused by value returned by another routine, I wa...

ArndW wrote:"IF INDEX('ASQMN',cp,1) THEN Ans='' ELSE RETURN('yourtext')"

What is doing that "IF" statement?

If you look at that phantom message, and post it here, we could tell you what it is saying. Chances are that your If statements are referencing variables that don't exist within the function. account_type,book_code, counterparty_code, etc are not declared, are you passing them as arguments? upsss, ...