convert from number to binary

Peytot · Post by **Peytot** » Tue Nov 25, 2003 9:11 am

Hello,
I would like to get the lenght of a field and put the result in a binary field.

ex: Len(name), but when I do this the result is not in Binary format even if I define the field bin.

thank you.

Pey

Amos.Rosmarin · Post by **Amos.Rosmarin** » Tue Nov 25, 2003 9:28 am

Do you mead 010010101..... like they use in computers

You can use Oconv ( number , "MB" )

to the opossite direction use Iconv (xx , "MB")

HTH,
Amos

Peytot · Post by **Peytot** » Tue Nov 25, 2003 9:48 am

Thank you Amos,
I didn't think that It was so easy to do.

Pey

ray.wurlod · Post by **ray.wurlod** » Tue Nov 25, 2003 5:23 pm

You might also like to investigate the "MX0C" conversion, which converts each byte into two hex characters. For example, "ABC" becomes "313233".

lebos · Post by **lebos** » Wed Nov 26, 2003 11:26 am

I could be wrong, but both of these solutions seem to give only a character representation of the desired result, at least when written to a Sequential File stage. For example:

oconv("9","MB") = "1001", not a true binary field, but rather an ASCII character field. (In hex it would be x31303031, I believe).

Is it possible to achieve a true binary field? So that the result would be x09? I have tried several combinations of oconv and iconv with no success.

Larry

ds_developer · Post by **ds_developer** » Wed Nov 26, 2003 11:44 am

lebos wrote:I could be wrong, but both of these solutions seem to give only a character representation of the desired result, at least when written to a Sequential File stage. For example:

oconv("9","MB") = "1001", not a true binary field, but rather an ASCII character field. (In hex it would be x31303031, I believe).

Is it possible to achieve a true binary field? So that the result would be x09? I have tried several combinations of oconv and iconv with no success.

Larry

You are correct; as far as I know DataStage cannot convert a numeric string to binary. We had to write our own utility.
John

Teej · Post by **Teej** » Wed Nov 26, 2003 12:47 pm

My kingdom for a Server Row Generator!

*grumbles about not able to test this easily*

-T.J.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 27, 2003 7:41 am

lebos wrote:I could be wrong, but both of these solutions seem to give only a character representation of the desired result, at least when written to a Sequential File stage. For example:

oconv("9","MB") = "1001", not a true binary field, but rather an ASCII character field. (In hex it would be x31303031, I believe).

Is it possible to achieve a true binary field? So that the result would be x09? I have tried several combinations of oconv and iconv with no success.

Larry

Didja try the "MX" conversion specification?

lebos · Post by **lebos** » Mon Dec 01, 2003 9:00 am

Yes, I did Ray. It returns a character representation of the hex also, not an actual hex (binary) field. At least that's what it looks like to me.

Larry

ray.wurlod · Post by **ray.wurlod** » Tue Dec 02, 2003 9:24 am

Yes, it tends to be one-way traffic. You can convert from binary data into equivalent string representation (which is DataStage's internal representation) but not, it seems, the other way.
I'm certain there is a way, but can't remember right now (10:30pm in a Bangkok hotel, without DataStage) how to go about it.