Re: Physical File, Record Format Name.

I should also ask... are you using the file in RPG in the FSPECS or just as
SQL?

If you are only using SQL you can define the file in the DSPECS as an
external datastructure which would eliminate the need to renaming the
record format name.

Michael Schutte
Work 614-492-7419
email  michael_schutte@xxxxxxxxxxxx


                                                                           
             "Mike Troxclaire"                                             
             <mike_troxclaire@                                             
             hotmail.com>                                               To 
             Sent by:                  rpg400-l@xxxxxxxxxxxx               
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       Physical File, Record Format Name.  
             03/24/2006 12:01                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I am a novice RPG programmer so this question might be quite simple for you

pros, but here it is. I created lots of physical files using 'CREATE
TABLE.....' via SQL and went about selecting, updating or deleting from
those files using Java code where I did not require record format. When I
am
trying to do a simple update(or any other operation) to a physical file
using RPG, do I have to know the record format name of the physical file?
If
so, is there a way I can go back and assign a record format name to those
physical files that I created using SQL?. Is it even necessary for a file
to
have a record format name? Or, does the iSeries automatically assigns some
record format name for any table? If so, where can I grab it from? Any
help/input in this matter will be much appreciated.

Thanks in advance.

Regards,

Mike.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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