Home > IT Answers > PACKED FIELDS
vibgyor
280 pts.
 PACKED FIELDS
Packed field data
How the packed field be represented in AS400? I see some special characters where the data type is packed. How can i see the actual value of the data in this packed field?

I tried an F10 & F11. But finding the data in hex.

IS there any way to get my data as it is?

 

 



Software/Hardware used:
AS400
ASKED: May 7, 2012  7:07 AM
UPDATED: May 8, 2012  12:11 AM
RELATED QUESTIONS
Answer Wiki:
If you use different viewer it will unpack it for you. Query SQL DSPDTA DBU (if you have it) Else you can just read the Hex value.
Last Wiki Answer Submitted:  May 7, 2012  12:59 pm  by  CharlieBrowne   32,825 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,825 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I tried an F10 & F11. But finding the data in hex.

That’s because the data is in hex.

IS there any way to get my data as it is?

You’re already seeing it as it is — it is in hex.

Now, if you want to see it formatted, then apply a report to it and format it in whatever way you choose. Usually, the easiest way is to use the RUNQRY command and specify the name of the file in the QRYFILE() parameter.

Tom

TomLiotta
 107,915 pts.