| View previous topic :: View next topic |
| Author |
Message |
ROBERTLa
Beginner
Joined: 07 Dec 2003
Posts: 8
Topics: 5
|
 Posted: Sat Dec 27, 2003 6:36 am Post subject: Varchar columns and online performance |
 |
|
Gents:
I've read thru the threads SQL performance and seen the cautions on tuning. Just one question though....
I need to create a varchar column upto 999 bytes max length which will ONLY be used for data storage from an input online TSO application screen, and printed on a batch report. This Varchar field will NOT be used as index, group-by, order-by, functions, foreign-keys or any other special use. Just simple store and display. This field is a audit trail of online fields changed by the use on a screen by screen basis.
I'm wondering if I've missed any online response time issues that this might cause....
Any Ideas ?
-Rob |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Sat Dec 27, 2003 9:02 am Post subject: |
|
|
Robertla,
The only question I have is how are you going to insert the record in the table from the online screen. Are you inserting the data as is from the EXEC CICS RECEIVE MAP
command ? or are you using a STRING verb to concatenate all the screen fields and then do
an insert? Just remember that you need to populate the length of the record also before inserting the record.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
ROBERTLa
Beginner
Joined: 07 Dec 2003
Posts: 8
Topics: 5
|
| Posted: Sun Dec 28, 2003 2:18 am Post subject: |
|
|
Hi Kolusu:
This is an ISPF panel app, so I just populate the length field in a cobol pgm. The text part is just a group move from working storage into the single Varchar field.
Hopefully this is the right approach.
By the way: this is a really excellent forum - I've gotten really good support - many thanks.
Rob. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
