|
| Hi
I am utilizing the SQL adapter to pull data out of SQL2K and send it to
BT2K4. The MQ Series Adapter isused to send data from BT to MQ Series
Queue Manager.
I am sending a positional flat file data to MQ Series Queue Manager. In
the Map I am using same positional flat file schema as source schema
and target schema.
In the Map I am using hexadecimal functoid.
The data is coming from SQL look like this:
1770DL2020 06300001VEDSDOS005 0000000001
I need the result like this
..... DL2020 06300001VEDSDOS005 0000000001
the output should be like this
Pos Hex ASCII
1: 00 0
2: B1 177
3: 00 0
4: 00 0
5: 44 D
6: 4C L
7: 32 2
8: 30 0
9: 32 2
10: 30 0
I need to convert integer to hexadecimal
177 - HEX"00B1"
0 - HEX "0000"
In the positional flat file schema position length of
177 is 2 bytes and position length of 0 is 2 bytes.when i am using
hexadecimal functoid i am getting B1 (Hexadecimal value) but i need to
get 00B1 (2 bytes)and 0000(2 bytes) and i need to send to MQ Queue
manager
I checked in google and groups there is no help.
can any one help me out on this. It is kind of urgent.
thanks
wask
|
|