That should have said: FILEINFO has no info on the master of an open
part file that it's associated with and STATUS only tells you that the
current part file is a part file - again, no master info.
>-Original Message-
>FILEINFO has no info on an open part file and STATUS only tells you
tha
So, in the case where a part file belongs to several master files, and a
record is added through one of the master files; and the part file has a
trigger; how can you determine which master file the record was entered
through?
MASTER1, MASTER2
\ /
PARTA - fires trigger
: Anthony W. Youngman [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 23, 2007 4:32 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Trigger(s) on distributed file
In message
<[EMAIL PROTECTED]>,
Jerry Banker <[EMAIL PROTECTED]> writes
>We use distributed files and yes a
ce I'm in an airport
lounge (not unusual for a weekend), I can't check that either, but it's
definitely do-able.
> - Original Message -
> From: "Boydell, Stuart" <[EMAIL PROTECTED]>
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UV] T
Definitive statement time.
Distributed files are Type 27. (Type 41 is an SQL view - Phil W spend a lot of
time working with the SQL engine, hence his "race memory"!)
There IS, in Universe, a physical entity. It is simply a linked list of
"partfile blocks". And, yes, this is not how Prime INF
Hi Stuart,
Another gotcha is how to determine which master file a part belongs to.
A part file can belong to multiple distributed files. You might, for
example, split your sales into monthly files and have distributed files to
represent quarters, years, the whole of history, etc.
Martin P
Another gotcha is how to determine which master file a part belongs to. You
can go and read the &PARTFILES& record - which is cumbersome - but I can't see
another way to programatically get the name of the master which a part belongs
to. Fileinfo() and the STATUS statement don't carry it... any ide
In message <[EMAIL PROTECTED]>,
"Stevenson, Charles" <[EMAIL PROTECTED]> writes
&PARTFILES& on UV is purely decorative. (Someone _please_ correct me if
that isn't true!)
&PARTFILES& was vital on PI, but maintained on UV solely for backward
compatibility in case guys like us ported some user-grow
In message
<[EMAIL PROTECTED]>,
Jerry Banker <[EMAIL PROTECTED]> writes
We use distributed files and yes a master file is created. The DEFINE.DF
command creates a type 27 file and a dictionary file is created that is
a type 30 file.
As a matter of fact we use the one dictionary for all of the pa
:[EMAIL PROTECTED]
Sent: Friday, June 22, 2007 6:02 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file
Odder and odder.
I don't ever remember seeing a file at OS level with the name of a
distributed master file. PI *or* UV. As implemented by Prime, iirc
&PARTFILES& on UV is purely decorative. (Someone _please_ correct me if
that isn't true!)
&PARTFILES& was vital on PI, but maintained on UV solely for backward
compatibility in case guys like us ported some user-grown PI critter
that relied on it.
Perhaps a UV example would help.
FSR is distribut
, 22 June 2007 10:16 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file
Then things really are confusing ... I'm talking about the file-type
introduced by Prime, and officially managed using the DEFINE.DF command.
By "multi-part", do you mean
PROTECTED]
Sent: 22 June 2007 11:20
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file
Sorry Wol,
Yes, I did think you meant the Pick style multi-part, sorry about that.
But as far as the distributed files as managed by DF they have always
had a master file o
..
Cheers,
Wol
-Original Message-
From: phil walker [mailto:[EMAIL PROTECTED]
Sent: 22 June 2007 10:02
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file
Wol,
I think you are confusing multi-part files with distributed files.
Cheers,
Phil
-Orig
a multi-value list of the relevant partfiles ...
Cheers,
Wol
-Original Message-
From: Clifton Oliver [mailto:[EMAIL PROTECTED]
Sent: 21 June 2007 18:01
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Trigger(s) on distributed file
Just a point of technical correction. The master
the relevant partfiles ...
Cheers,
Wol
-Original Message-
From: Clifton Oliver [mailto:[EMAIL PROTECTED]
Sent: 21 June 2007 18:01
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Trigger(s) on distributed file
Just a point of technical correction. The master does exist as a
-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file
Many thanks to the responants, I am just investigationg what is involved in
converting a file to DF.
So far:
- Triggers are required on each part. You cannot create a trigger on the
master and there is no similar
Many thanks to the responants, I am just investigationg what is involved in
converting a file to DF.
So far:
- Triggers are required on each part. You cannot create a trigger on the
master and there is no similar functionality to the 'CREATE.INDEX' command on
DFs.
- BSCAN doesn't work - but SELECT
Just a point of technical correction. The master does exist as a
physical file, type 27.
--
Regards,
Clif
~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~
O
I didnt attempt to create on the 'master' in universe 10. I wrote an
application to find every pathname, created my own VOC from that
location, and created the trigger on that name. My approach would also
not have a trigger in place for an addition to the df. To the good,
the application creates C
Off the top of my head - AND CHECK TO MAKE SURE...
You can't create triggers (or indexes, or anything like that) on the
master, because it only exists as a record in &PARTFILES&).
But - and I'm pretty sure this is true of indices at least - if you try
and create an index on the master, it will lo
21 matches
Mail list logo