Results 1 to 3 of 3

Thread: SQL Query (One World 9.2.1) returning garbage data

  1. #1

    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:

    0xE2D260C1C4D5E2F3E2F3D840404040404040404040404040 40 (hexadecimal)?

    I wish to Thank You in Advance!

    Thanks & GOD Bless!
    Attached Images Attached Images

  2. #2
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,740
    Chad,

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

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  3. #3
    Quote Originally Posted by DBohner-(db) View Post
    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!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.