RE: SQL Create table

Are you looking for below:

Create qtemp/myfile as (select * from amtlib/myfile) with no data

 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
mcrangle@xxxxxxxxxxxxxxxxxxxx
Sent: Tuesday, November 14, 2006 9:53 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: SQL Create table



My boss prefers to use the opnqry method of creating files in qtemp, and
doesnt like me creating work files in amtlib, then duplicating in qtemp.

I am very new to SQL (as is probably apparent...) and just wondering if
its possible to create qtemp files, which will then be populated and
used in the cpytoimpf command.

Maybe trying to hard to accomplish in sql rather than the method I
know...





Note that if you're only using the file as an external data structure,
the only time the file needs to exist is when the program is compiled.
In other words, the file description is pull in at compile time not at
run time.

What exactly are you trying to accomplish?





--
This is the RPG programming on the AS400 / iSeries (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.