Hi,
What is the Special Character there.
Thanks & Regards,
Sudhakar
Special Characters In Stage Variables.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
Re: Special Characters In Stage Variables.
i need to know datastage
Re: Special Characters In Stage Variables.
After looking at the "special character" in your statement - it seems that those are carriage returns in the statement to add some formatting. Which would make it look like this if you clicked multi-line editing.kondeti wrote: IF (specialcharacter) IsNotNull (LNK_TstData.METHOD_ID) And (Len (Trim (LNK_TstData.METHOD_ID)) <> 0) (specialcharacter) THEN (specialcharacter) IF Len(LNK_TstData.METHOD_ID) > 80 (specialcharacter) THEN 'Field METHOD_ID Is too large' ELSE '0' ELSE 'Mandatory field METHOD_ID contains NULL'
Code: Select all
IF
IsNotNull (LNK_TstData.METHOD_ID) And (Len (Trim (LNK_TstData.METHOD_ID)) <> 0)
THEN
IF Len(LNK_TstData.METHOD_ID) > 80
THEN 'Field METHOD_ID Is too large' ELSE '0' ELSE 'Mandatory field METHOD_ID contains NULL'
No - if it is a carriage return it isn't causing the NULL - its just for formatting. I'm not certain about the logic in the IF statement, it looks a bit suspect, but that is hard to diagnose without understanding more of the application.kondeti wrote:Just want to understand whether this special character is causing the NULL value?
Can you post the follwing?
1) exact error message (Cut and Paste)
2) datatype of the variable involved? Is it a CHAR field?
3) exact text of line(s) affecting that variable in the transformer.