DSXchange

Posted: **Tue Sep 07, 2010 6:53 am**

Hi,

What is the Special Character there.

Thanks & Regards,
Sudhakar

Posted: **Tue Sep 07, 2010 7:15 am**

I can't copy that symbol. But it is Concatenated with 2 vertical boxes.

Posted: **Tue Sep 07, 2010 7:48 am**

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'

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.

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'

You should be able to delete the carriage returns and not have any effect on the statement.

Posted: **Tue Sep 07, 2010 8:21 am**

Code is in production. Just want to understand whether this special character is causing the NULL value ? Can you please share your thoughts? Thank you.

Posted: **Tue Sep 07, 2010 8:54 am**

kondeti wrote:Just want to understand whether this special character is causing the NULL value?

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.

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.

DSXchange

Special Characters In Stage Variables.

Re: Special Characters In Stage Variables.

Re: Special Characters In Stage Variables.