× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.