Re: SYSCOLUMNS & SYSCOLUMN2

On Nov 26, 2019, at 2:14 AM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

<Jon>
Is there another table or a column in either SYSCOLUMNS or SYSCOLUMN2 that does accurately represent the size of the column or do I have to calculate it?
</Jon>
... if there isn't and I think so, it wouldn't be to hard to provide a view of my own, showing up whatever I need. Date Format of the job is known at runtime and could be retrieved from an external function, calcualting a length (without or with seperators) could be done by a join to a little table or by a function too and functions could be used in create view. Or am I missing something?

D*B
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com