Results 1 to 2 of 2

Thread: Using WINSQL with JDE E1 9.1 to interrogate tables

  1. #1

    Using WINSQL with JDE E1 9.1 to interrogate tables

    Hello,
    I’m looking for a bit of technical advice. I have many years of JDE World experience and am very familiar with the JDE Database. However I am currently doing a short term contract with a JDE E1 9.1 customer , writing some technical specs. Whilst I am aware of data browser my preferred method of accessing the JDE E1 data I need is via SQL. With DB2 I would often have a series of SQL queries written in WINSQL Lite. I am hoping to be able to do the same in JDE E1 9.1. That is my question. Can I run a statement like "Select * from f4801 where wadrqj>118220 and wadrqj<118227” in WINSQL to retrieve the data that I require.

    regards
    Pat

  2. #2
    Member Tom_Davidson's Avatar
    Join Date
    Nov 2000
    Location
    Wisconsin, USA
    Posts
    725
    I don't know why not. all you should need is the proper credentials and ODBC driver.

    Tom
    Cleindori Consulting
    8.12/8.98.4.4, 9.1/9.1.5.3, 9.2/9.2.0.5/6
    IBM i, WebLogic on Windows, DBCS, Global installations.

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 and, or Oracle.