473,508 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

The use of an hexadecimal variable

1 New Member
Hi I have an issue.
We have a db2-clumn in UTF-16, vall it COL, when I select it like
SELECT HEX(COL) FROM MYTBL
I receive the result
E38199E381B0353030E38289E38197E3818432332D3938
So far so good.

If i do a select like this:

SELECT HEX(COL) FROM MYTBL
where col = x'E38199E381B0353030E38289E38197E3818432332D3938'
The result is fine too
BUT what I really want is to have the value in a variable, in this case COBOL LIKE
MYHEX PIC X(25) VALUE
X'E38199E381B0353030E38289E38197E3818432332D3938*

And do a select like

SELECT HEX(COL) FROM MYTBL
where col = :MYHEX

BUT does nnot work. :(
Mar 6 '15 #1
0 1072

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1819
by: thomasp | last post by:
I have not had any luck with this on other groups so I am posting it here. I created a .rtf file using MS Word that included text and graphics(.png file) . I then viewed this file with notepad. ...
12
3924
by: bollod | last post by:
Is there any benefit to declaring a variable: x = (1<<12); instead of: x = 4096; (besides the geek appeal of course ;-) )
11
2544
by: sara | last post by:
Hi everybody, can anyone tell me how to convert decimal number into hexadecimal of the folloxing format. If I give deciaml value of num=100, I need the output in the hexa decimal form as 0x64....
2
4439
by: Mike OKC | last post by:
VB.NET 2003 I'm new to VB.NET, so this should be an easy fix. My integer variable showing &HA when I hover the mouse pointer over the variable, and also shown in Locals, Name: intLoop Value: &HA...
7
19191
by: elliotng.ee | last post by:
I have a text file that contains a header 32-bit binary. For example, the text file could be: %%This is the input text %%test.txt Date: Tue Dec 26 14:03:35 2006...
0
2199
by: Metalpalo | last post by:
Hello everybody I created small batch file in MSDOS. In this batch file i need to print hexadecimal value of some env. variable. For example: I enter value via command :set /P PAR=Enter...
6
14333
by: Andrea | last post by:
Hi, suppose that I have a string that is an hexadecimal number, in order to print this string I have to do: void print_hex(unsigned char *bs, unsigned int n){ int i; for (i=0;i<n;i++){...
6
16883
by: sweeet_addiction16 | last post by:
hello Im writin a code in c... can sum1 pls help me out in writing a c code to convert decimalnumber to hexadecimal number.The hexadecimal number generated has to be an unsigned long.
8
2613
by: scad | last post by:
I have a file that has blocks of data that can vary in length. The first 2 bytes of the block are a Hex number telling me how many bytes long the block is (including those 2 bytes). I need to be...
10
26642
by: Bil M | last post by:
I want to be able to add two hexadecimal numbers . Below is the code. This code is for converting from hexadecimal to decimal, so what I want is that when I enter the second Hexadecimal value, it...
0
7115
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7377
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7036
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5624
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5047
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4705
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1547
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
414
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.