|
Eric, I agree with that point, but I wasn't commenting on it; perhaps my message timing is/was off a bit. Thanks for clarifying. 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 2: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 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.