DSXchange

Hi All, I have a field named AREA2 ( char 40 bytes). Say it has the following value " JT4VN13G4W36280604 98686" and I need to check whether the first 2 bytes are spaces and replace it with another string say "AB'. I tried the following in my transformation. If AREA2 [1,2] = ' ' then (...

nsubbarao wrote:

chulett wrote:Hmmm... ok. What if you quote the comparison?

Code: Select all

If STW_EFFECTIVE_DATE > "9606" Then

...

Let me try !!!

Still no luck chulette.

chulett wrote:Hmmm... ok. What if you quote the comparison?

Code: Select all

If STW_EFFECTIVE_DATE > "9606" Then

...

Let me try !!!

Not a conversion thing, I'd wager. What's in your AREA2 field? If either of those substrings return a null, all you'll end up with is a null after concatenation. ... STW_EFFECTIVE_DATE = 9607 STW_NEW_STAT_AREA2 = 92 5 40119500725114 012003031196607 19150000 9 0 000000002 0050 These are the input co...

Just do the comparison. Server isn't picky about data types so no 'conversion' is necessary. ... I tried it but it is not giving me the desired output. STW_EFFECTIVE_DATE - 9607 The condition goes like this : If STW_EFFECTIVE_DATE > 9606 Then (STW_NEW_STAT_AREA2[1,48] : "1" : STW_NEW_STAT...

Hi All, I have a database field EFFECTIVE_DATE - Char 4 bytes and it has a value 9607 and my requirement goes like this. I have to compare this EFFECTIVE_DATE against a value to check whether it is greater than 9607. I need to convert the EFFECTIVE_DATE to numeric and compare it against 9607. Could ...