DSXchange

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..

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.

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.

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.)

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

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