ca.portal.admin

Re:How to find length of SQL-defined table?

Discussion created by ca.portal.admin on Nov 16, 2010
Is there any way to get the length of an SQL-defined table as defined, other than adding up the column lengths by hand?

The schema display does not provide the length as a comment.
IDMSLOOK does not provide this information about SQL-defined records.
""Print space"" and ""print page"" give you the length of existing rows, but this does not necessarily match the definition, if columns were added later.

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: IDMS Server R17
"Hi Kay - that's correct - you can use the same definitions for both types of connections.

Dave Hearn
CA Technologies
Sr Sustaining Engineer
Tel:  +1-609-583-9917
David.Hearn@ca.com

Outcomes