RE: SQL Create table

All I remember is having to ask the same question every time I need to
use it: "What was the name of that file?" ... 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of vhamberg@xxxxxxxxxxx
Sent: Tuesday, November 14, 2006 4:57 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: SQL Create table

Who? Me? LOL - wish I remembered that far back!

-------------- Original message --------------
From: "Turnidge, Dave" <DTurnidge@xxxxxxxxxxxxxxxxxxxx> 

You need to name the file in your F spec to a name of a file that is 
in the library list, that is the same format as the file you are

creating.

Then when you actually run the program you do an override to point it 
to the new one you created.

An alternative was created by VERN when he worked here, but I don't 
even want to THINK about getting into that discussion!!!

Dave

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
mcrangle@xxxxxxxxxxxxxxxxxxxx
Sent: Tuesday, November 14, 2006 9:07 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL Create table


Instead of using the CRTDUPOBJ for work files in qtemp I'm trying 
this...

C/EXEC SQL
C+ CREATE TABLE QTEMP/LLM43CWK
C+ (PART CHAR (8),
C+ DESC CHAR (25),
C/END-EXEC

Where should this file be declared, external data structure? I've

tried 

using an F Spec, but the compiler cannot resolve the file as it isnt 
there. 

Hope this makes sense 

Many thanks 

-- 
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. 


-- 
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.