ca.portal.admin

Re:Re: Broken Chain

Discussion created by ca.portal.admin on Jan 14, 2008
Hi Colette,

There is no owner pointer in the CALC set.

Laura Rochon
Ajilon Consulting

Simpson, Colette [DOT] wrote:
I am trying to fix a broken chain which is in the CALC set of a
record.
The next and prior db keys seem to be fine, but the owner pointer
seems to point to the wrong owner. I can see the next and prior
pointers in the record, but cannot find the owner pointer. Can
someone tell me where to look for the CALC chain owner pointer for a
record, so I can fix it to point to the correct owner?

TIA
Colette

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Broken Chain
"Hi Vince,

I didn't mean to imply that you couldn't have a owner pointer on a CALC
record. What I said is that for the CALC set, there is no owner
pointer. I hope that clears it up.

Laura

Jensen, Vince wrote:
Laura:

It is possible to have an owner pointer on a CALC record. I have a CALC
set that is a member of a via set with Next/Prior/Owner pointers. The
owner is in another CALC set.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Simpson, Colette [DOT]
Sent: Monday, January 14, 2008 10:00 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Broken Chain


Laura, I thought that was the case. but then why does my DBAN indicate
otherwise? It seems to me that if the owner of 185070:17 were 1853070:0
instead of 1844805:0, the chain would not be broken.=20

599702 - NEXT LINK NOT FOUND SET=3DCALC START OF LINK
1853070:17 OWNER IS AT 1844805:0 =20
CHAIN LENGTH 1 LINK POINTS TO
1853070:0 PRIOR IN PFX 1853070:16=20
=20

599703 - PRIOR LINK NOT FOUND SET=3DCALC START OF LINK
1853070:17 OWNER IS AT 1844805:0=20
CHAIN LENGTH 1 LINK POINTS TO
1853070:0 PRIOR IN PFX 1853070:16=20
=20

599703 - PRIOR LINK NOT FOUND SET=3DCALC START OF LINK
1853070:0 OWNER IS AT 1853070:0=20
CHAIN LENGTH 1 LINK POINTS TO
1853070:1 PRIOR IN PFX 1853070:17
=20

599702 - NEXT LINK NOT FOUND SET=3DCALC START OF LINK
1853070:16 OWNER IS AT 1853070:0
CHAIN LENGTH 1 LINK POINTS TO
1853070:17 PRIOR IN PFX 1853070:1=20
Thanks,

Colette


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Monday, January 14, 2008 10:21 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Broken Chain

Hi Colette,

There is no owner pointer in the CALC set.

Laura Rochon
Ajilon Consulting

Simpson, Colette [DOT] wrote:
I am trying to fix a broken chain which is in the CALC set of a
record.
The next and prior db keys seem to be fine, but the owner pointer=20
seems to point to the wrong owner. I can see the next and prior=20
pointers in the record, but cannot find the owner pointer. Can=20
someone tell me where to look for the CALC chain owner pointer for a=20
record, so I can fix it to point to the correct owner?

TIA
Colette


"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Broken Chain
"Check out the option of running IDMSDBAN with the SETS=NOCALC option DBAN
has been known to report erroneous CALC set errors.


In a message dated 1/14/2008 12:35:20 P.M. Eastern Standard Time,
Vince.Jensen@CGI.HEALTH.GOV.AB.CA writes:

Laura:

It is possible to have an owner pointer on a CALC record. I have a CALC
set that is a member of a via set with Next/Prior/Owner pointers. The
owner is in another CALC set.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Simpson, Colette [DOT]
Sent: Monday, January 14, 2008 10:00 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Broken Chain


Laura, I thought that was the case. but then why does my DBAN indicate
otherwise? It seems to me that if the owner of 185070:17 were 1853070:0
instead of 1844805:0, the chain would not be broken.=20

599702 - NEXT LINK NOT FOUND SET=3DCALC START OF LINK
1853070:17 OWNER IS AT 1844805:0 =20
CHAIN LENGTH 1 LINK POINTS TO
1853070:0 PRIOR IN PFX 1853070:16=20
=20

599703 - PRIOR LINK NOT FOUND SET=3DCALC START OF LINK
1853070:17 OWNER IS AT 1844805:0=20
CHAIN LENGTH 1 LINK POINTS TO
1853070:0 PRIOR IN PFX 1853070:16=20
=20

599703 - PRIOR LINK NOT FOUND SET=3DCALC START OF LINK
1853070:0 OWNER IS AT 1853070:0=20
CHAIN LENGTH 1 LINK POINTS TO
1853070:1 PRIOR IN PFX 1853070:17
=20

599702 - NEXT LINK NOT FOUND SET=3DCALC START OF LINK
1853070:16 OWNER IS AT 1853070:0
CHAIN LENGTH 1 LINK POINTS TO
1853070:17 PRIOR IN PFX 1853070:1=20
Thanks,

Colette


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Monday, January 14, 2008 10:21 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Broken Chain

Hi Colette,

There is no owner pointer in the CALC set.

Laura Rochon
Ajilon Consulting

Simpson, Colette [DOT] wrote:
I am trying to fix a broken chain which is in the CALC set of a
record.
The next and prior db keys seem to be fine, but the owner pointer=20
seems to point to the wrong owner. I can see the next and prior=20
pointers in the record, but cannot find the owner pointer. Can=20
someone tell me where to look for the CALC chain owner pointer for a=20
record, so I can fix it to point to the correct owner?

TIA
Colette

**************Start the year off right. Easy ways to stay in shape.
http://body.aol.com/fitness/winter-exercise?NCID=aolcmp00300000002489
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: SQL Data Arithmetic
"I tested a variation of these where my database record's date is in
ccyymmdd format. It was necessary to use CAST and SUBSTR to get the
WHERE to work. CA's documentation referes to CURRENT DATE as a special
register.

This gets dates from the 1st through the 14th of the current month.

SELECT your columns
FROM yourschema.""your-record""
WHERE
SUBSTR(CAST(your_date) AS CHAR(8)),1,4) =
SUBSTR(CAST(CURRENT DATE AS CHAR(14)),1,4)
AND
SUBSTR(CAST(your_date) AS CHAR(8)),5,2) =
SUBSTR(CAST(CURRENT DATE AS CHAR(14)),6,2)
AMD
SUBSTR(CAST(your_date) AS CHAR(8)),7,2)
BETWEEN '01' AND '14'


This gets all dates from the 15th through the end of the previous month.

SELECT
your_date, etc
FROM yourschema.""your-record""
WHERE
SUBSTR(CAST(your_date) AS CHAR(8)),1,4)
=
SUBSTR(CAST(CAST(SUBSTR(
CAST(CURRENT DATE AS CHAR(14)),1,8)||'01' AS DATE)-1 AS CHAR(14)),1,4)
AND
SUBSTR(CAST(your_date) AS CHAR(8)),5,2)
=
SUBSTR(CAST(CAST(SUBSTR(
CAST(CURRENT DATE AS CHAR(14)),1,8)||'01' AS DATE)-1 AS CHAR(14)),6,2)
AND
SUBSTR(CAST(your_date) AS CHAR(8)),7,2) >= '15'


Joe S Cates, Database Analyst II
Systems Architecture and Operations
Database Management/Unix Administration
Montgomery County Public Schools
Rockville, MD 20850
joe_cates@mcpsmd.org

Outcomes