RE: SQL Create table

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.