Dictionary/TurboImage anomaly
Leonard_Berkowitz@harvardpilgrim.org
Leonard_Berkowitz@harvardpilgrim.org
Fri, 18 Oct 2002 11:04:55 -0400
OK (red-faced). However, our dictionary does not have an OPEN for that
RECORD.
--
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-1955
pager: 781-226-2431
"Deskin, Bob"
<Bob.Deskin@Cogno To: powerh-l@lists.swau.edu
s.COM> cc:
Sent by: Subject: RE: Dictionary/TurboImage anomaly
powerh-l-admin@cu
be.swau.edu
10/18/2002 10:50
AM
Actually, PDL does have an OPEN option on the RECORD statement specifically
for IMAGE datasets. This allows multiple definitions of the same dataset
for
coded records.
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Leonard_Berkowitz@harvardpilgrim.org
[mailto:Leonard_Berkowitz@harvardpilgrim.org]
Sent: Friday, October 18, 2002 10:41 AM
To: Deskin, Bob
Cc: powerh-l@lists.swau.edu; powerh-l-admin@cube.swau.edu
Subject: RE: Dictionary/TurboImage anomaly
Bob,
There are no OPEN statements on datasets. There are only RECORD statements.
They must follow a FILE statement for that data base, which contains
ORGANIZATION DATABASE.
A DBFIND on a detail is implicitly or the equivalent a DBGET mode 7
(calculated read) on the master set that has the chain head for the search
field. This established the pointers to the first and last entry in the
detail for the value you are using. You can easily demonstrate this by
checking the last access date on the master dataset, use QUIZ to access the
detail with a CHOOSE on the key value. Then check the master's access date
again. I should have changed to the time when you peformed this operation.
Leonard
--
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-1955
pager: 781-226-2431
"Deskin, Bob"
<Bob.Deskin@Cogno To:
powerh-l@lists.swau.edu
s.COM> cc:
Sent by: Subject: RE:
Dictionary/TurboImage anomaly
powerh-l-admin@cu
be.swau.edu
10/18/2002 10:20
AM
Check the RECORD definition for FS-REC-YEAR-A. Is there an OPEN option? As
I
recall, you do need some reference to the actual dataset name to access it
but that can be done using the OPEN option.
On the other hand, if all you're doing is accessing the detail dataset and
not the master or auto master, then we don't physically access the master.
We would do a DBFIND (I think, it's been a long, long time since I coded
IMAGE intrinsics) to establish the chain. The dataset reference is to the
detail even though you're really looking at the master. You also specify
the
search item (index) which is how IMAGE establishes the master to look at.
So
if that's what you're doing, PowerHouse wouldn't need the actual master
dataset name.
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Leonard_Berkowitz@harvardpilgrim.org
[mailto:Leonard_Berkowitz@harvardpilgrim.org]
Sent: Friday, October 18, 2002 10:10 AM
To: powerh-l@lists.swau.edu
Subject: Dictionary/TurboImage anomaly
HPe3000; PH 8.19C
Here is the index information for a detail dataset:
-- Index Contents --
** FS-REC-YEAR is a 4 byte REPEATING ALTERNATE index **
** that links to FS-REC-YEAR-A **
Segment Type Size Ord Offset
FS-REC-YEAR CHARACTER 4 A 0
The dataset FS-REC-YEAR-A does exist in the PDL source file, of course, but
the dataset does not exist in the data base itself. In the data base, the
dataset where the chain head is for FS-REC-YEAR is called FS-RECORD-YEAR.
Yes, everything seems to work properly. I ran QUIZ with a CHOOSE
FS-REC-YEAR PARM and was able report the records that exist.
I imagine that the only time PowerHouse cares about these links is in
creating a data base from the dictionary. In field conditions <grin> the
PowerHouse products rely on DBINFO to resolve such issues.
Is that correct?
--
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-1955
pager: 781-226-2431
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information. If
you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information. If
you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.