RE: Laying out a data entry screen like Excel

Welcome back to 1960.....

Sounds almost like an internally defined file to me...

I'd have one 800 char field defined with the WRDWRAP dds keyword for the top half of the screen.

Then defined your 50 15 char fields on the screen.

Then using data structures ( and v5r4's EVAL-COR ) you could write it all into a single field in the
file. There's no real reason to store the blanks as far as I can see so you'd only need 1550 bytes.

I'd strongly consider keeping the data in the file as 1 800 char and 50 15 char fields myself.

Note that that searching for a particular word in either the 800 or the full 1550 char fields using
SQL would involve a full table scan every time unless you have the optional DB2 Text Extenders
installed.

Lastly, why limit yourself to 80 columns? Why not 132?

Or better yet, make it a web page and really impress your users.

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307
wiltc@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Thursday, August 14, 2008 10:39 AM
To: Midrange Systems Technical Discussion
Subject: Laying out a data entry screen like Excel


Don't know if this can be done?

Say you have a database Field Description defined as 1600 bytes (20 rows x
80 columns)

Then say you want to allow sentence/paragraph text entry into the whole
top half of that entry screen, 10 rows x 80 columns,

Finally, you want to display and break out the bottom half of the screen
into rows and columns like Excel for columnar data entry (and subsequent
readable print format).

So say your (10 row) bottom half FIVE COLUMNS would BE: 15 then 1 blank,
15 then 1 blank, 15 then 1 blank, 15 then 1, 15.

So while all the data will be in one large field (which will BE FULLY
scanable for querying), certain bytes of the field will be "hard coded" so
to speak. Make sense?
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman



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

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.