Whoops, that's one place I forgot to check....thanks!
/b;
-----Original Message-----
From: Rick.Chevalier@xxxxxxxxxxxxxxx
[
mailto:Rick.Chevalier@xxxxxxxxxxxxxxx]
Sent: Wednesday, April 11, 2007 11:59 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Creating a PF - Compiled File vs. SQL Create Table Command
Brian,
Did you check the archives? IIRC, there was a lengthy discussion on
this last week. If not, I know there are several threads dealing with
this topic. You will probably find your answers there. If not, let us
know what you couldn't find.
Rick
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski
Sent: Wednesday, April 11, 2007 10:23 AM
To: Midrange Systems Technical Discussion
Subject: Creating a PF - Compiled File vs. SQL Create Table Command
Hi All,
Is there any difference between creating a physical source file member
and compiling it versus using an SQL CREATE TABLE command? When using
the i5, I've always created a PF and then compiled it as my table, but I
have never created a table using the SQL CREATE TABLE command.
I did a test of the CREATE TABLE command, and it did indeed create a PF
in the specified directory. However, it doesn't create the associated
member (or does it?) that I can use to modify and update the table if
fields need to be added/modified/deleted.
One advantage I did notice is that I am not limited to ten characters
like a standard physical file (yes, I understand there are ways around
it).
Are there any specific reasons why I would want to select one method
over another? File maintenance would be a matter of editing the PF
member and doing a CHGPF on a modified file versus an ALTER TABLE
command.
Am I missing something fundamental here?
Thanks!
/b;
-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brian Piotrowski
Assistant Mgr. - I.T.
Simcoe Parts Service, Inc.
Ph: 705-435-7814 x343
Fx: 705-435-6746
-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Privileged and Confidential. This e-mail, and any attachments there to,
is intended only for use by the addressee(s) named herein and may
contain privileged or confidential information. If you have received
this e-mail in error, please notify me immediately by a return e-mail
and delete this e-mail. You are hereby notified that any dissemination,
distribution or copying of this e-mail and/or any attachments thereto,
is strictly prohibited.
midrange.com
