URGENT!!! file field decoder generated on AS/400

pts.
Tags:
Application development
AS/400
IBM DB2
REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ NAL T TQ NAL M 1 �1 ? K 2NO RET 2% Q NR NAL T NR NAL M 1 �1 � K 3RET 2% Q R NAL T R NAL M 1 �1 � K 4AGUAS 8% Q AGUAS NAL T AGUAS NAL M 1 �1 ? K 5ISOT 3% Q ISOT NAL T ISOT NAL M 1 �1 � 5 1 91060 9999906 9801011L 980101 1 1051116 102 103 100 MAKRO MAKRO MAKRO 0 1 0 11 K 1TQ 3% Q TQ NAL T TQ NAL M 1 �1 � K 2NO RET 3% Q NR NAL T NR NAL M 1 �1 � K 3RET 3% Q R NAL T R NAL M 1 �1 � K 4AGUAS 3% Q AV-LIQ-AGUA T AV-LIQ-AGUA M 1 �1 � K 5ISOT 3% Q ISOT NAL T ISOT NAL M 1 �1 � 5 1 91070 9999907 9801011L 980101 1 1021107 102 103 100 MCDONALD'S MCDONALD'S MCDONALD'S 0 1 0 11 K 1LAT-8Z 20% Q LATA Y 8Z NAL T LATA Y 8Z NAL M 1 �1 ? K 220 OZ 20% Q 20 OZ NAL T 20 OZ NAL M 1 �1 ? K 3FAM NR 25% Q FAM NR NAL T FAM NR NAL M 1 �1 K 4RET 20% Q R NAL T R NAL M 1 �1 ?

Answer Wiki

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

assuming you mean PACKED field

First, the “little squares” are the way your application’s display shows an unprintable character (meaning the hex value does not correspond to a known symbol).

So somehow, you need to get your application to show you the HEX values for the packed fields. Then it is a matter or reading it out properly.

Second, you must not be using a native data retrieval method, as the system i automatically converts the packed data unless you are displaying the raw member contents.

To read packed data (once you have the HEX value) you read it bit wise from the left.

123 in a packed 3,0 field depending on application display is

12 3F (note:F is positive, D is negative)

or

13
2F

-123.4 in a packed 4,1 field is
01 23 4D (note: even length packed fields get a place holder 0 so that the sign F or D can be added. decimal points are not displayed; they must be positioned after extracting the digits.)

or

024
13D

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
  • Rbeethe
    Is this data in a file? In DSPPFM (Display Physical File Member) F10=Display Hexadecimal. I also picked up a hex editor for my PC a long time ago so I could look at bits. I see hex in messages we get sometimes in messages that get placed into data queues -- I have a utility to dump the data in the queue or I have also used DMPOBJ.
    10 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