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



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.


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.