Re: Global Temporary Table -- RPG400-L

What do you mean pass two files to the print program?
What system version are you on?

I'm assuming that the print program is expecting files to exist. The
question is how is the program accessing those files? It by SQL, FSPECS,
or DataStructure (which would make sense since you mentioned passing two
files).

If SQL or FSPECS... you could create a duplicate of those files in QTEMP
(make sure that QTEMP is at the top of your LIBRARY LIST.

DECLARE GLOBAL TEMPORARY TABLE NEW_FILE LIKE OLD_FILE;

Will create the table in QTEMP and will exist as long as the JOB is active.
The Job could mean Workstation if that's where it's being called from.

When you execute this statement, you would want to check for SQLCODE =
-601. If equal then table already exists. So now you need to delete all
records to clear it.

Personally, I prefer to drop the table and rebuild it. Too many times,
I've needed to change the table and had phone calls saying something wasn't
working because the user still had the old version of the table active in
their workstation job.

On Fri, Jun 8, 2012 at 12:22 PM, Gary Thompson <gthompson@xxxxxxxxxxx>wrote:

I am modifying an existing warehouse application that sends shipment data
from our system i server to a wintel server on our network. The wintel
server manages a Voice-Driven picking system and returns pick detail
to our i which then manages customer delivery and invoicing.

The modification is to add an additional, robotic pick system that will
handle our largest warehouse. For this largest warehouse, the modified
application will send shipment data to another wintel server on our
network,
which will manage the Robotic pick system and, like the Voice pick system,
return pick detail to our i.

To make maximum use of existing function, I want to use an existing pallet
report program to print reports for pallets handled by the Robotic system.
My background would lead me to create a DDS file in QTEMP using a CRTPF
or DUPOBJ, but I am leaning to embedded SQL.

My question is can anyone offer advice on use of CREATE TEMPORARY TABLE ?

I want to:

1. create with replace two temp tables (NOT journaled)

2. load two temp tables with pallet info from pgm a (the modified
pgm)

3. pass two temp tables to the existing print pgm

4. repeat as required by user

The users work to dispatching "loads" of product from several concurrent
5250 sessions on our i.

Pgm a (the modified pgm) is called as dispatchers get a batch of "loads"
ready
for the warehouse. At this point in time, pgm a is called, which prepares
and
transmits data to the appropriate pick system (Voice or Robot)
[now working in test], and loads the two temp tables and calls the existing
print pgm [ my next goal ].

Thanks for any advice!
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.