RE: [U2] [UV] Trigger(s) on distributed file

2007-06-25 Thread Boydell, Stuart 
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
that
>the current file is a part. No @filename or @stdfil info, can't do
>PORT.STATUS MAPFILES ...

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-25 Thread Boydell, Stuart 
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 triggerA
   PARTB   - fires triggerB

>ED MASTER2 FRED
   [trigger fires :: tableName = PARTA]

FILEINFO has no info on an open part file and STATUS only tells you that
the current file is a part. No @filename or @stdfil info, can't do
PORT.STATUS MAPFILES ...

>-Original Message-
>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.

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-25 Thread Jerry Banker 
No, the DEFINE.DF command creates a data file and a dictionary. They are
actual files on the disk. However you cannot access the type 27 data
file. You can only list or add records if you have at least one part
file added. The type 27 file has a modulus of 1.

-Original Message-
From: 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 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 part
files.
>
Ah. This gives me an idea.

Did you explicitly create a master distributed file?

I used to create them with the following sequence:

CREATE.FILE DICT MASTER.
CREATE.FILE DATA MASTER.1
DEFINE.DF MASTER. ADDING MASTER.1 PART 1

(or whatever the correct syntax is). I'm guessing that because I 
explicitly didn't create the data portion, it didn't get created ... :-)

It still worked fine...

Cheers,
Wol
-- 
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The
man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source
Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-24 Thread Ray Wurlod 
EXECUTE "RECORD DFname recordID" CAPTURING RESULT

If you're really lucky (I can't check right now) it might even update 
@SYSTEM.RETURN.CODE

There is a whole swag of extra options for FILEINFO() and STATUS() that return 
dynamic arrays when processing a Distributed file. Since 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] Trigger(s) on distributed file
> Date: Sun, 24 Jun 2007 15:51:58 +1000
> 
> 
> 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 ideas?
> Regards,
> Stuart
> 
> 
> 
> **
> This email message and any files transmitted with it are confidential and
> intended solely for the use of addressed recipient(s). If you have received
> this communication in error, please reply to this e-mail to notify the sender
> of its incorrect delivery and then delete it and your reply.  It is your
> responsibility to check this email and any attachments for viruses and defects
> before opening or sending them on. Spotless collects information about you to
> provide and market our services. For information about use, disclosure and
> access, see our privacy policy at http://www.spotless.com.au
> Please consider our environment before printing this email.
> **
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-24 Thread Ray Wurlod 
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 INFORMATION did it.

And, now, another plug for the UniVerse Internals class (or whatever IBM calls 
UV910 this week).  It's great knowledge, and does allow a much greater depth of 
problem-solving skills.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Trigger(s) on distributed file

2007-06-24 Thread Martin Phillips 

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 Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 
---

u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-23 Thread Boydell, Stuart 
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 ideas?
Regards,
Stuart



**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Trigger(s) on distributed file

2007-06-23 Thread Anthony W. Youngman 
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-grown PI critter
that relied on it.


Ummm...

Sounds like the type 27 file is as vital on UV, as &PARTFILES& was on PI 
- ie not at all!


Perhaps a UV example would help.
FSR is distributed, type27, with 5 partfiles.
The 5 parts are each dynamic hashed, type30.
The 4096 byte OS file called "FSR" is filled with x00 and xFF bytes,
scattered with some pointers to the partfiles.


LIST.DF FSR

Part file "/u1/SIMS5/FSR_p5", Part number = 5.
Part file "/u1/SIMS5/FSR_p2", Part number = 2.
Part file "/u1/SIMS5/FSR_p3", Part number = 3.
Part file "/u1/SIMS5/FSR_p4", Part number = 4.
Part file "/u1/SIMS5/FSR_p1", Part number = 1.



CT VOC FSR


FSR
0001 F (dist file)
0002 FSR
0003 /software/SIMS5/DICTS/D_FSR



Ohhh That is NOT what I expected to see!

On PI (and I'm SURE it was the same on UV) I would have expected to see

0001 F
0002 FSR_p1 vm FSR_p2 vm FSR_p3 vm FSR_p4 vm FSR_p5
0003 /software/SIMS5/DICTS/D_FSR

actually, I am sure it was the same on UV - I had a program writing 
these things directly into the VOC, and it worked fine.


Well interesting ... maybe we're both right ... or maybe it works the PI 
way in PI-flavour accounts (I haven't knowingly used anything else).


Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Trigger(s) on distributed file

2007-06-23 Thread Anthony W. Youngman 
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 part files.


Ah. This gives me an idea.

Did you explicitly create a master distributed file?

I used to create them with the following sequence:

CREATE.FILE DICT MASTER.
CREATE.FILE DATA MASTER.1
DEFINE.DF MASTER. ADDING MASTER.1 PART 1

(or whatever the correct syntax is). I'm guessing that because I 
explicitly didn't create the data portion, it didn't get created ... :-) 
It still worked fine...


Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Jerry Banker 
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 part files.

-Original Message-
From: Anthony Youngman [mailto:[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, any
partfile could be used as a master to get the algorithm definition etc,
and you were warned that a VERY QUICK way to corrupt your distributed
file was to use FORCE with DESIGN.DF unless you knew exactly what you
were doing - precisely because a part file could belong to multiple
masters and if the masters weren't in sync the result was a terrible
mess...

Cheers,
Wol

-Original Message-
From: phil walker [mailto:[EMAIL 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 of type (27 or 41 - cannot remember which ) which was
basically just a header and I think had the algorithms etc in them.

Dave Meeks or Glenn Herbert could probably confirm if they are still
around. Palmer Chapelle was the engineer who had most input in
implementing them in UV from PI.

Cheers,

Phil

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Friday, 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 the Pick style NEW.ACCOUNT,PIOPEN type
file? I'm certainly not thinking of those - they were never in PI and
I've never had cause to use them. I wouldn't presume to know anything
about them.

Distributed files, as known on Prime, never to my knowledge had any
physical existence other than as individual part-files. As far as I was
aware, the UV implementation had similar characteristics ...

Cheers,
Wol
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Stevenson, Charles 
&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 distributed, type27, with 5 partfiles.
The 5 parts are each dynamic hashed, type30.
The 4096 byte OS file called "FSR" is filled with x00 and xFF bytes,
scattered with some pointers to the partfiles.

>LIST.DF FSR
Part file "/u1/SIMS5/FSR_p5", Part number = 5.
Part file "/u1/SIMS5/FSR_p2", Part number = 2.
Part file "/u1/SIMS5/FSR_p3", Part number = 3.
Part file "/u1/SIMS5/FSR_p4", Part number = 4.
Part file "/u1/SIMS5/FSR_p1", Part number = 1.
>
>
>CT VOC FSR

 FSR
0001 F (dist file)
0002 FSR
0003 /software/SIMS5/DICTS/D_FSR
>
>
>SH -c "ls -l FSR FSR_p?/*"
-rw-rw-r-- 1 simsprod simsusers   4096 Jun 11  2004 FSR
-rw-rw-r-- 1 simsprod simsusers 1091520512 Jun 22 11:02 FSR_p1/DATA.30
-rw-rw-r-- 1 simsprod simsusers 1798778880 Jun 22 11:02 FSR_p1/OVER.30
-rw-rw-r-- 1 simsprod simsusers 1092890624 Jun 22 11:02 FSR_p2/DATA.30
-rw-rw-r-- 1 simsprod simsusers 1799092224 Jun 22 11:02 FSR_p2/OVER.30
-rw-rw-r-- 1 simsprod simsusers 1092229120 Jun 22 11:02 FSR_p3/DATA.30
-rw-rw-r-- 1 simsprod simsusers 1793253376 Jun 22 11:02 FSR_p3/OVER.30
-rw-rw-r-- 1 simsprod simsusers 1092395008 Jun 22 11:02 FSR_p4/DATA.30
-rw-rw-r-- 1 simsprod simsusers 1794936832 Jun 22 11:02 FSR_p4/OVER.30
-rw-rw-r-- 1 simsprod simsusers 1097713664 Jun 22 11:02 FSR_p5/DATA.30
-rw-rw-r-- 1 simsprod simsusers 1794174976 Jun 22 11:02 FSR_p5/OVER.30
>
>
>SH -c "strings FSR"
>O[{
FSR_p5
/u1/SIMS5/FSR_p5
FSR_p2
/u1/SIMS5/FSR_p2
FSR_p3
/u1/SIMS5/FSR_p3
FSR_p4
/u1/SIMS5/FSR_p4
FSR_p1
/u1/SIMS5/FSR_p1
> 

I used unix utility "strings" instead of "cat" below because of all the
non-printable characters.
I think I could, should make this file read-only. June 11 2004 was when
I created it.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread phil walker 
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 of type (27 or 41 - cannot remember which ) which was
basically just a header and I think had the algorithms etc in them.

Dave Meeks or Glenn Herbert could probably confirm if they are still
around. Palmer Chapelle was the engineer who had most input in
implementing them in UV from PI.

Cheers,

Phil

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Friday, 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 the Pick style NEW.ACCOUNT,PIOPEN type
file? I'm certainly not thinking of those - they were never in PI and
I've never had cause to use them. I wouldn't presume to know anything
about them.

Distributed files, as known on Prime, never to my knowledge had any
physical existence other than as individual part-files. As far as I was
aware, the UV implementation had similar characteristics ...

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

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Friday, 22 June 2007 8:30 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file

That's weird ... has that changed at all recently?

I used to create multiple masters by hand and never did anything like
that ... (and never bothered to update &PARTFILES& either :-)

Where does it store the pointer to the master file? Field 2 of the VOC
is just 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 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
~~~


On 6/21/07 Anthony Youngman wrote:
>  You can't create triggers (or indexes, or anything like that) on the
>  master, because it only exists as a record in &PARTFILES&).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Anthony Youngman 
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, any
partfile could be used as a master to get the algorithm definition etc,
and you were warned that a VERY QUICK way to corrupt your distributed
file was to use FORCE with DESIGN.DF unless you knew exactly what you
were doing - precisely because a part file could belong to multiple
masters and if the masters weren't in sync the result was a terrible
mess...

Cheers,
Wol

-Original Message-
From: phil walker [mailto:[EMAIL 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 of type (27 or 41 - cannot remember which ) which was
basically just a header and I think had the algorithms etc in them.

Dave Meeks or Glenn Herbert could probably confirm if they are still
around. Palmer Chapelle was the engineer who had most input in
implementing them in UV from PI.

Cheers,

Phil

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Friday, 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 the Pick style NEW.ACCOUNT,PIOPEN type
file? I'm certainly not thinking of those - they were never in PI and
I've never had cause to use them. I wouldn't presume to know anything
about them.

Distributed files, as known on Prime, never to my knowledge had any
physical existence other than as individual part-files. As far as I was
aware, the UV implementation had similar characteristics ...

Cheers,
Wol
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Anthony Youngman 
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 the Pick style NEW.ACCOUNT,PIOPEN type
file? I'm certainly not thinking of those - they were never in PI and
I've never had cause to use them. I wouldn't presume to know anything
about them.

Distributed files, as known on Prime, never to my knowledge had any
physical existence other than as individual part-files. As far as I was
aware, the UV implementation had similar characteristics ...

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

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Friday, 22 June 2007 8:30 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file

That's weird ... has that changed at all recently?

I used to create multiple masters by hand and never did anything like
that ... (and never bothered to update &PARTFILES& either :-)

Where does it store the pointer to the master file? Field 2 of the VOC
is just 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 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
~~~


On 6/21/07 Anthony Youngman wrote:
>  You can't create triggers (or indexes, or anything like that) on the
>  master, because it only exists as a record in &PARTFILES&).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread phil walker 
Wol,

I think you are confusing multi-part files with distributed files.

Cheers,

Phil

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Friday, 22 June 2007 8:30 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Trigger(s) on distributed file

That's weird ... has that changed at all recently?

I used to create multiple masters by hand and never did anything like
that ... (and never bothered to update &PARTFILES& either :-)

Where does it store the pointer to the master file? Field 2 of the VOC
is just 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 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
~~~


On 6/21/07 Anthony Youngman wrote:
>  You can't create triggers (or indexes, or anything like that) on the
>  master, because it only exists as a record in &PARTFILES&).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-22 Thread Anthony Youngman 
That's weird ... has that changed at all recently?

I used to create multiple masters by hand and never did anything like
that ... (and never bothered to update &PARTFILES& either :-)

Where does it store the pointer to the master file? Field 2 of the VOC
is just 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 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
~~~


On 6/21/07 Anthony Youngman wrote:
>  You can't create triggers (or indexes, or anything like that) on the
>  master, because it only exists as a record in &PARTFILES&).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-21 Thread Bernard Lubin 
Stuart,

Bscan will not work against the main file, but works on the individual
files.  

Bernard Lubin
Development Department
Reynolds and Reynolds

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Friday, 22 June 2007 2:06 PM
To: u2-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 functionality to the 'CREATE.INDEX' command
on
DFs.
- BSCAN doesn't work - but SELECTINDEX does.
- And a gotcha, if you artificially populate the parts contra to the DF
algorithm (and possibly if you change it) You need to rebuild the indices.

Cheers,
Stuart





**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the
sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and
defects
before opening or sending them on. Spotless collects information about you
to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-21 Thread Boydell, Stuart 
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 SELECTINDEX does.
- And a gotcha, if you artificially populate the parts contra to the DF
algorithm (and possibly if you change it) You need to rebuild the indices.

Cheers,
Stuart





**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Trigger(s) on distributed file

2007-06-21 Thread Clifton Oliver 
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
~~~


On 6/21/07 Anthony Youngman wrote:
>  You can't create triggers (or indexes, or anything like that) on the
>  master, because it only exists as a record in &PARTFILES&).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Trigger(s) on distributed file

2007-06-21 Thread john reid 

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 CREATEs and DROPs for each PATH denoted in a
VOC item named INSTALL..FUNCTION, and DEINSTALL..FUNCTION.
I then combined them all, into a single CREATE and DROP paragraph
accessible only to two users.

john


On 6/21/07, Anthony Youngman <[EMAIL PROTECTED]> wrote:

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 loop through the list of
partfiles and create an index on each individual partfile. The same is
likely to be true of triggers.

Where this WILL bite you, is when you create a new partfile. By default,
it won't have any indices, or triggers, or whatever. You'll need to add
them to that partfile.

So - the situation with indices (and probably triggers etc) is that
creating them on the master is a legit thing to do. But under the covers
it is actually doing it to each individual partfile. So when you add a
new partfile, they won't get automatically added to the new partfile.

Cheers,
Wol

-Original Message-
From: Boydell, Stuart [mailto:[EMAIL PROTECTED]
Sent: 21 June 2007 04:29
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Trigger(s) on distributed file

Just to check as I couldn't find doco on it - Do I create triggers on
each part of a DF? Or is there a way to have the trigger on the master?
Cheers,
Stuart



**
This email message and any files transmitted with it are confidential
and
intended solely for the use of addressed recipient(s). If you have
received
this communication in error, please reply to this e-mail to notify the
sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and
defects
before opening or sending them on. Spotless collects information about
you to
provide and market our services. For information about use, disclosure
and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/




--
john
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Trigger(s) on distributed file

2007-06-21 Thread Anthony Youngman 
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 loop through the list of
partfiles and create an index on each individual partfile. The same is
likely to be true of triggers.

Where this WILL bite you, is when you create a new partfile. By default,
it won't have any indices, or triggers, or whatever. You'll need to add
them to that partfile.

So - the situation with indices (and probably triggers etc) is that
creating them on the master is a legit thing to do. But under the covers
it is actually doing it to each individual partfile. So when you add a
new partfile, they won't get automatically added to the new partfile.

Cheers,
Wol

-Original Message-
From: Boydell, Stuart [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2007 04:29
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Trigger(s) on distributed file

Just to check as I couldn't find doco on it - Do I create triggers on
each part of a DF? Or is there a way to have the trigger on the master?
Cheers,
Stuart



**
This email message and any files transmitted with it are confidential
and
intended solely for the use of addressed recipient(s). If you have
received
this communication in error, please reply to this e-mail to notify the
sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and
defects
before opening or sending them on. Spotless collects information about
you to
provide and market our services. For information about use, disclosure
and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UV] Trigger(s) on distributed file

2007-06-20 Thread Boydell, Stuart 
Just to check as I couldn't find doco on it - Do I create triggers on
each part of a DF? Or is there a way to have the trigger on the master?
Cheers,
Stuart



**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/