Re: SQL Create table

Since you created the table using SQL, have you tried reading the file
using SQL?



                                                                           
             mcrangle@cinetic-                                             
             landis.co.uk                                                  
             Sent by:                                                   To 
             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx               
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             11/14/2006 09:06          SQL Create table                    
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           





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.