Char(254) value for @FM

allavivek · Post by **allavivek** » Wed Jan 25, 2012 10:56 pm

Hi All,

In DS , @FM/@AM represents char(254) . Is it Ascii value for 254 which was black square character ?

I used the variable@FM in sequencer to to replace spaces to "" , which was output from command activity stage .

So In Datastage char(254) is space or black square (according to ASCII )?

Thanks..

ray.wurlod · Post by **ray.wurlod** » Thu Jan 26, 2012 2:38 am

How @FM is represented depends entirely on the viewer that you happen to be using. In many utilities it displays as the Icelandic thorn character. It may be displayed as an open rectangle, or a filled rectangle, or anything else, but it's always the same single-byte value on the server.

chulett · Post by **chulett** » Thu Jan 26, 2012 6:51 am

No, it's not a space and would not be useful in removing them. For a space, you can simply use " " or CHAR(20) if you prefer.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 26, 2012 2:51 pm

Oops! Char(32) is space. (Craig's mixing it up with its hex representation 0x20, which you might use in APT_STRING_PADCHAR environment variable.)

chulett · Post by **chulett** » Thu Jan 26, 2012 6:51 pm

D'oh! Thanks for the catch... always thinking in hex for that kind of thing, it seems.

qt_ky · Post by **qt_ky** » Fri Jan 27, 2012 12:10 am

100000 in binary... if everyone programmed in binary, we wouldn't need all these new-fangled systems like decimal, hexadecimal, sexatrigesimal, etc.