PACKED FIELDS

280 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following