ca.portal.admin

Re:Re: IDMS-L Digest - 20 Apr 2010 to 21 Apr 2010 (#2010-63)

Discussion created by ca.portal.admin on Apr 22, 2010
Can anyone provide a calculation for integrated indexes that takes these 3
=
inputs;
Pagesize
Number of full SR8's per page( we usually choose 3 )
Maximum Keylength

and produces the correct value for;
Index Block Contains

Thanks. There are several formulas in the Listserve logs that seem to be
i=
ncomplete or perhaps wrong.
=20
Steven Kuske,
The State of Iowa



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Timestamp in SQL
"Try the following - let us know how you go - cheers - Gary=20

SELECT cast ( USERid as char(8) ) as userid , =
=20
cast ( CUSER as char(8) ) as createby , =
=20
cast ( uUSER as char(8) ) as updateby , =
=20
CAST ( CTIME as timestamp) as created , =
=20
CAST ( uTIME as timestamp) as updated =
=20
FROM idmssecu3.uSERGROUP =
=20
where userid like 'A%' =
=20
ORDER BY USERID; =
=20
*+                                                                        =
=20
*+ USERID    CREATEBY  UPDATEBY  CREATED                                  =
=20
*+ ------    --------  --------  -------                                  =
=20
*+ ACCAST    JDASAM    JDASAM    1996-06-17-10.06.19.729325               =
=20
*+ ADXTRE    JISDAM    JISDAM    2007-05-10-09.46.02.586688               =
=20
*+ AHXBAR    JISDAM    JISDAM    2003-12-05-10.04.05.730798               =
=20
*+ AJDXT2    JISDAM    JISDAM    2003-09-30-15.05.43.881442               =
=20
*+ AJDXT3    JISDAM    JISDAM    2003-09-30-15.05.32.890680               =
=20
*+ AJXTUR    JISDAM    JISDAM    2003-12-05-10.26.22.766884               =
=20
*+ AKLPYP    JISDAM    JISDAM    2003-12-05-10.22.52.375983               =
=20
*+ ALSAMP    JISDAM    JISDAM    1999-10-21-08.07.00.991972               =
=20
*+ ALXBUL    JISDAM    JISDAM    2004-11-12-09.14.14.849564               =
=20
*+ ALXWIL    JISDAM    JISDAM    2003-12-05-10.28.25.902964               =
=20
*+ AWJABR    JISDAM    JISDAM    2003-12-05-10.03.37.134226               =
=20
*+                                                                        =
=20
*+ UPDATED                                                                =
=20
*+ -------                                                                =
=20
*+ 1996-06-17-10.06.19.729325                                             =
=20
*+ 2007-05-10-09.46.02.586688                                             =
=20
*+ 2003-12-05-10.04.05.730798                                             =
=20
*+ 2003-09-30-15.05.43.881442                                             =
=20
*+ 2003-09-30-15.05.32.890680                                             =
=20
*+ 2003-12-05-10.26.22.766884                                             =
=20
*+ 2003-12-05-10.22.52.375983                                             =
=20
*+ 1999-10-21-08.07.00.991972                                             =
=20
*+ 2004-11-12-09.14.14.849564                                             =
=20
*+ 2003-12-05-10.28.25.902964                                             =
=20
*+ 2003-12-05-10.03.37.134226                                             =
=20
*+                                                                        =
=20
*+ 11 rows processed                                                       =
=20


Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:gary.cherlet@sa.gov.au

This e-mail message and any attachments are qualified as follows: Addressin=
g: If you have received this e-mail in error, please advise by reply e-mai=
l to the sender. Please also destroy the original transmission and its con=
tents. Confidentiality: This e-mail may contain confidential information w=
hich also may be legally privileged. Only the intended recipient(s) may ac=
cess, use, distribute or copy this e-mail. Individual Views: Unless otherw=
ise indicated, the views expressed are those of the sender, not Justice Tec=
hnology Services. Computer Viruses: It is the recipient's responsibility t=
o check the e-mail and any attached files for viruses.

Outcomes