• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL Query (One World 9.2.1) returning garbage data

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

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!
 
Top