SQL Query (One World 9.2.1) returning garbage data

Chad-Ligon

Member
Hello,

I am attempting to research Parent/Child BOM relationships in 'kitted' parts. I am able to successfully execute this query with the specific string data however the output does not display the data only some garbage data? I am certain someone will know what I am doing wrong and be able to assist in a timely fashion.

As you can see in the attachment the data searched for and found is:
SELECT * FROM KFPDTA.F3002 WHERE KFPDTA.F3002.IXKITL ='SK-ADNS3S3Q'AND KFPDTA.F3002.IXMMCU=300;

The output in column IXKITL is only showing:

0xE2D260C1C4D5E2F3E2F3D84040404040404040404040404040 (hexadecimal)?

I wish to Thank You in Advance!

Thanks & GOD Bless!
 

Attachments

  • Toad Query - Garbage Data.jpg
    Toad Query - Garbage Data.jpg
    32.3 KB · Views: 15
  • Toad Query - Garbage Data2.PNG
    Toad Query - Garbage Data2.PNG
    6.5 KB · Views: 11
Chad,

What database are you using?
Which Query Tool are you using?

(db)
 
Chad,

What database are you using?
Which Query Tool are you using?

(db)

I am using a product called TOAD Data Point on our iSeries DB2 database. I had the same results of my query using MS Query (Excel) so I then recreated the ODBC connection to the iSeries. This resolved my problem and all is well in SQL'ville... :) Thanks & GOD Bless!
 
Back
Top