SQL to retrieve data from a JDE Library/File/Member

Allora

Member
Hi,

We are creating a report where the JDE user ID/PW is passed as a parameter so that it will retrieve the data from the JDE Library/File/Member where Member is the JDE user ID. My current SQL is:
SELECT POCODJ3."SH", POCODJ3."SHAD1", POCODJ3."SHAD2", POCODETJ."OLLNID", POCODETJ."DRDL02 FROM "S10F60DC"."DATAXFER"."POCODJ3" POCODJ3 LEFT OUTER JOIN "S10F60DC"."DATAXFER"."POCODETJ" POCODETJ ON POCODJ3."PHDOCO" = POCODETJ."OLDOCO"

My current SQL is retrieving data from the first member file it finds and it's not retrieving from my own member file.


In JDE SQL it looks like below how the userID as a parameter is appended to the SQL.
SELECT *.01, oamlnm.02 COLHDG("Vnd Name Override") NAME(nmover)oaadd1.02 COLHDG("Address 1 Override") NAME(add1ov)
FROM dataxfer/podocj(&cuser), f4006

I'd like to know how to do this in SQL Server SQL or if I can make it work through the IBM iSeries Access for Windows.

Thanks for any help.
 
Back
Top