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


  1.  Home
  2. RPG400-L
  3. August 2003

RE: Record name the same as the file name

Eric,

The integrated index is sort of there. You can specify a primary key for the 
file. This does require that the files be unique and not null (which is where 
the sort of comes into play). I'll agree that this is a nice convenience item 
but does it really make any difference if you use what amounts to a logical 
file vs. the physical file?

Matt

-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
Sent: Wednesday, August 20, 2003 3:16 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Record name the same as the file name


I hear what you are saying, Bob, but I think you missed my point.  There is
no new feature to be had here.  We can already use a SQL table in RPG by
renaming the format to be unique. 

Even if the compiler team developed this, it still doesn't address the
biggest problem with using SQL tables as native access files in RPG, and
that is the lack of an integrated index in the table object.  Because SQL
seperates the access path from the view, there's no way access keys, making
random access impossible.   

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Bob cozzi [mailto:cozzi@xxxxxxxxx]
Sent: Wednesday, August 20, 2003 1:27 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Record name the same as the file name


No you can not. In RPG IV, a format name CAN NOT be the same as a File name.
It won't compile.


Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of DeLong, Eric
Sent: Wednesday, August 20, 2003 12:53 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Record name the same as the file name

New feature?  We can already do that by renaming the format, right?  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Bob cozzi [mailto:cozzi@xxxxxxxxx]
Sent: Wednesday, August 20, 2003 12:08 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Record name the same as the file name


Giving up?
How about looking at it as adding a new feature. The ability to have a file
whose format is the same name as the file.


Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Booth Martin
Sent: Wednesday, August 20, 2003 11:17 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Record name the same as the file name

Aren't we giving up something when we allow the record format name to equal
the file name? 
 
Isn't that just moving to the lowest common denominator? Should we be asking
that RPG give up a feature? Whether we like the feature or not is irrelevant

 
The rule of "Read files, write records" is not just an RPG thing. Besides,
who knows? Maybe in the future we'll wish we had the ability to have a mix
of record formats in a file. 
 
 
---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: Wednesday, August 20, 2003 10:03:31 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Record name the same as the file name
 
A-F'ing-men
 
 
Bob Cozzi
Cozzi Consulting
www.rpgiv.com
 
 
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, August 20, 2003 8:52 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: Record name the same as the file name
 
I know that, with DDS, you always make the record format name different
than the file name.
I know that, with SQL, it defaults to making the record format name the
same as the file name. I further know there are tricks to renaming the
record format name. (These often involve naming the file what you want
the record format name to be and then renaming the file after the fact.)
I know that you can use a file level keyword to rename the record format
name.
However, why should we have to go through these tricks and shouldn't the
compiler just be modified to get over it?
 
Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin
 

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




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


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




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


_______________________________________________
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 ...
Follow-Ups:
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.