Is it possible to Hexadecimal or Binary Value as the input to WHERE clause in query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen - 07 Feb 2005 10:49 GMT

Hi,

I am a newbie in DB2 and mainframe technology. While compiling a query
I cam across a situation where I had to give a Hex value as the input
to a query; i.e. WHERE file_status = x'00'. Is this correct.

More over if I were to give a BINARY as the input instead, How is it
done?

Please forgive if my question is baseless and silly. Guide me please.

Thank you very much.

Reply to this Message

RdR - 07 Feb 2005 19:32 GMT

Hi,

You can try this:

"Select * from <table_name> where HEX(file_status)=x'00';" .

similar to "select HEX(file_status) from <table_name>;"

Hope this helps,

JWK(RdR)

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thank you very much.

Reply to this Message

RdR - 07 Feb 2005 19:39 GMT

Ooops,

It should be without the "x" in between "=" and the first single quote:

"Select * from <table_name> where HEX(file_status)='00';"

Thanks,

RdR

> Hi,
>
[quoted text clipped - 19 lines]
> >
> > Thank you very much.

Reply to this Message

Praveen - 08 Feb 2005 05:13 GMT

Thanks a zillion RdR. That was really helpfull.

Reply to this Message