John McKown pisze:
A programmer has posed this question to me. My response, so far, has been
"no way". But I'll ask the truly knowledgeable here.
We have a KSDS with an AIX. The data in the field which defines the
alternate keys is sometimes "unknown" and coded as LOW-VALUES (0x00's).
Well, this has lead to a problem where the number of base records for the
"unknown" value is often quite huge and exceeds the maximum allowable record
size on the AIX. This causes the base record add or update to fail. What the
programmer wants is a way to tell VSAM that if the AIX key is 0x00s, that it
is not necessary to update the AIX at all. I cannot think of any way to do this.
Any clever ideas?
Maybe not clever, but idea:
When you define AIX you decide about record length. For non-unique key
AIX you should calculate record length using the following formula
rec_size = 5 + AIX_key_length + n * prime_key_length
n is number of allowed repetitions.
You have to assume it.
You cannot exceed it otherwise the update will fail.
HTH
--
Radoslaw Skorupka
Lodz, Poland
--
BRE Bank SA
ul. Senatorska 18
00-950 Warszawa
www.brebank.pl
Sd Rejonowy dla m. st. Warszawy
XII Wydzia Gospodarczy Krajowego Rejestru Sdowego,
nr rejestru przedsibiorców KRS 0000025237
NIP: 526-021-50-88
Wedug stanu na dzie 01.01.2009 r. kapita zakadowy BRE Banku SA (w caoci
wpacony) wynosi 118.763.528 zotych. W zwizku z realizacj warunkowego
podwyszenia kapitau zakadowego, na podstawie uchway XXI WZ z dnia 16 marca
2008r., oraz uchway XVI NWZ z dnia 27 padziernika 2008r., moe ulec
podwyszeniu do kwoty 123.763.528 z. Akcje w podwyszonym kapitale zakadowym
BRE Banku SA bd w caoci opacone.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
