Re: Creating temporary table

If you know there is nothing else in QTEMP that you want to keep you
could just use the CLRLIB command to clear all objects from QTEMP at the
start of your program.

Personally this is where I'd use a short CLLE module wrapper around the
C module to use the best features of all available languages. Do the
stuff that CL is good at (CHKOBJ, CRTDUPOBJ etc.) and then invoke the C
function with a CALLPRC and bind the lot into a single program object.

Paul

-----Original Message-----
From: c400-l-bounces@xxxxxxxxxxxx [mailto:c400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jevgeni Astanovski
Sent: 15 February 2013 09:07
To: c400-l@xxxxxxxxxxxx
Subject: [C400-L] Creating temporary table

Hello,

Such a trivial operation and I understood that I do not see simple
solution...
A program needs to use a temporary table, I assumed that QTEMP is the
best place for it.
So I have a table with the same structure in MYLIB and program needs to
create its copy, however, empty, and in QTEMP.

I shall issue a CL command CRTDUPOBJ from my C program, but I cannot
gurantee, that the table does not exist there already.
I see two ways to protect myself from this situation:

1. Capture relevant error message (probably CPD2104, object already
exist);

2. Issue unlink (Unix style API) to delete this file before making
CRTDUPOBJ - but this will end in error if file does not exist.

Or I should rather attempt to open file using _Ropen with mode "wr" and
if it ends in error, issue CRTDUPOBJ and make _Ropen again?

All these methods seem odd - that made me think that maybe there is some
better way...

Thanks,

Jevgeni