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
