Page 1 of 1

How to show database records existing in qtemp library

Posted: 11 Sep 2017, 18:27
by Fairdinkum
Hi,
Does anyone have experience with getting data of database in qtemp library?
(Is Connector capable of that?)

One of our prospect wants to get a csv file converted from a database created into qtemp library by an existing 5250 application.
(We've already explained them that it seems to be difficult and aXes is capable of treating that from non-qtemp library.)

Best Regards,
Hidekazu Tanaka

Re: How to show database records existing in qtemp library

Posted: 13 Sep 2017, 11:57
by tim mcentee
Hi Hidekazu

With aXes the database file in QTEMP is unique to the interactive session and cannot be accessed by any other job. The access that aXes uses to server programs and db files goes via the aXes server job.

There are api's that could achieve what you are looking for:
https://www.ibm.com/support/knowledgece ... cjbitp.htm

This allows a program to be run under a different job, ie. the interactive job.

Reading the doco, this solution is not for the faint hearted.

Tim

Re: How to show database records existing in qtemp library

Posted: 28 Sep 2017, 11:11
by Fairdinkum
Hi Tim,

Sorry for delay reply. It looks like that I might be able to do that. I've got started studying how to use that QWCJBITP API.
Thanks for the information.

Best Regards,
Hidekazu Tanaka