I need a little help from you. I wrote a sort job which had to copy records on the basis of sort criteria to an output file.
The input file was in HEX format.
The input file was a vsam with VB structure.
The output file was a PS with VB format.
When I got the output I could see all in 'HEX' format. But I wanted all to appear in char format so that I can download it to my desktop. Please advise how to proceed in such case.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
yes, you are right...i need to do a "HEX ON' to see data.
That's it. That's all you can offer? Is that supposed to help us figure out what the data is? It doesn't.
The data could be anything in that case. For example, it could be PD values or BI values or FI values or ZD values. Or it could be something else. You need to know the starting position, length and format of each value before you can determine how to convert it to meaningful printable characters. If you don't know that, you could copy some lines from your screen with HEX ON and post it here as William suggests and we can take guesses at what the fields represent.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
yes, you are right...i need to do a "HEX ON' to see data.
Ok, so you need to do HEX ON to "see" the data.
Now, post a bit of the HEX ON data (copy/paste) that you see. Do not try to post the entire screen, just a few lines of the "hex on" data.
What you have done is very much like calling a mechanic and saying "There is something wrong with my car. How do i fix it?". How could the mechanic have any idea what "something wrong" means?
Hi All....Thanks all for your time..i am really sorry for being so inexplicit...here are few details what you want...
after doing 'hex on' in output file i see below ...
----------------------------------------------
...........2.--.12.--............-.% 00..T109010/500 121 UBS AG ZURICH
10100200001F0771FF0781000000000017064FF00EFFFFFF6FFF44FFF4444ECE4CC4EEDCCC4
20104C0000C2003C12000C0000C00001675C0000C3109010150000121000042201709499380
--------------------------------------------------------------------------
...........2.--.62.--............-.% 00..T109010/500 121 UBS AG ZURICH
10100200002F0771FF0781000000000017064FF00EFFFFFF6FFF44FFF4444ECE4CC4EEDCCC4
20104C0000C2003C62000C0000C00001675C0000C3109010150000121000042201709499380
----------------------------------
i would like to see the data in the below format...
-----------------
12001100042 73168 2 70808 62 70821 0.00 2400000.00 0 0 T243844/500 112 UBS AG ZURICH TC B2B, ZH
12001100042 73169 2 70820 12 70821 0.00 114743.28 0 0 T 03363/500 121 UBS AG ZURICH TC B2B, ZH
--------------------------
I have this sort cond:
SORT FIELDS=COPY
INCLUDE COND=(5,6,CH,EQ,X'12001100042C')
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
You have "normal" mainframe records that have packed-decimal numbers in addition to displayable numbers, letters and other characters. I've aligned your input and "Coded"ed it (using the "Code" tab near the top of the reply panel) so that the hex values are under the "display" characters.
Code:
----------------------------------------------
...........2.--.12.--............-.% 00..T109010/500 121 UBS AG ZURICH
10100200001F0771FF0781000000000017064FF00EFFFFFF6FFF44FFF4444ECE4CC4EEDCCC4
20104C0000C2003C12000C0000C00001675C0000C3109010150000121000042201709499380
--------------------------------------------------------------------------
...........2.--.62.--............-.% 00..T109010/500 121 UBS AG ZURICH
10100200002F0771FF0781000000000017064FF00EFFFFFF6FFF44FFF4444ECE4CC4EEDCCC4
20104C0000C2003C62000C0000C00001675C0000C3109010150000121000042201709499380
----------------------------------
Please review this "input" and what you posted as desired oujtput - the values in your output do not match the values in this input.
Re-post some input and output that are for the same data.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
malayajena,
That's better. It appears you have PD fields and CH fields intermixed.
The output you say you want doesn't actually correspond to the input fields. For example, your second input field is P'1' and P'2', but you show the output as 73168 and 73169 ... I don't know where those came from.
At any rate, here's a DFSORT job that should give you the idea of how to do what you want.