Listing JDE Users

Hello,

Does anyone know what the API functions/Business Functions should be used to list JDE users. Is there a way to do this programatically without contacting the backend database directly?

Thanks,
Kevin.

JDE Business Functions cannot return a set of data (ie list), so I don't
think you'll find a business function to give you what you want. I'm not
very familiar with API's, but I don't think they will do it either (An
API expert can correct me if I'm wrong).



So, from outside of JDE you would have to connect to the database and
pull the data yourself.

From inside JDE, you can get around this limitation by using work
tables.



Ellen Deak

Senior Systems Developer

Cooper Standard Automotive

JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R2M0,
Citrix Clients

Re: RE: Listing JDE Users

Thanks for the reply. I was hoping I could use something like B9600430 since it has methods like OpenTable DoSelect DoFetch etc. to collect the information, but I was not sure if it would work or was the right thing to do.

Sure - you can use the same sequence of JDB_OpenTable/.../JDB_CloseTable as many JDE C BSFN's do.

What language are you going to use for development?


BTW, has anyone noticed that JDB_InitEnv/JDB_FreeEnv sequence is now leaking resources badly under TR 8.96?

Thanks for the Info, I am using C for development so that API works great.

Cheers,
Kevin.