RE: Physical File, Record Format Name.

So, what you're saying Charles, is renaming a table doesn't rename the 
format. Correct?

And, that's an OS/400 feature, not necessarily an SQL feature. - Right?


Jeff Stevens
Mize, Houser & Co. P.A.
913 451 1882
JStevens@xxxxxxxxxxxxxx





"Wilt, Charles" <CWilt@xxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/24/2006 12:37 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Physical File, Record Format Name.






Mike,

As others have mentioned, an SQL created table has a record format named
the same as the table.

Unless you have an SQL table name longer than 10 characters.  In which
case, the system generates a short system name for the table and uses
that for both the short system name and the record format name.

If you want more control,

Create table InvHstR

Rename table InvHstR to InvHst

Rename table InvHst to InventoryHistory

Gives you an SQL table named InventoryHistory with a short system name
of INVHST and a record format name of INVHSTR.


I don't usually bother with the record format name, unless I'm replacing
a DDS created file with an SQL table.

Create table InvHst
Rename table InvHst to InventoryHistory
Gives you an SQL table named InventoryHistory with a short system name
of INVHST and a record format name of INVHST.


Note that this:
Create table InventoryHistory
Rename table InventoryHistory to system name InvHst
Gives you an SQL table named InventoryHistory with a short system name
of INVHST and a record format name of INVENT0001.

HTH,
Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Troxclaire
> Sent: Friday, March 24, 2006 12:01 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Physical File, Record Format Name.
> 
> 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.
> 
>