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.