| View previous topic :: View next topic |
| Author |
Message |
danm Intermediate
Joined: 29 Jun 2004 Posts: 170 Topics: 73
|
Posted: Tue Nov 20, 2007 11:38 am Post subject: Edit table under QMF |
|
|
| When a column has more than 50 characters, it only shows the first 50 characters. To see the rest of the data, I need to press PF5 (Show Field). Is there a way to change the default to show all the data in the column instead of pressing the PF5 key every time? |
|
| Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12401 Topics: 75 Location: San Jose
|
Posted: Tue Nov 20, 2007 11:53 am Post subject: |
|
|
danm,
If I remember correctly, Press PF09 and change the Width of the Column and then press PF12
Hope this helps...
Cheers _________________ Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
 |
danm Intermediate
Joined: 29 Jun 2004 Posts: 170 Topics: 73
|
Posted: Wed Nov 21, 2007 9:17 am Post subject: |
|
|
Kolusu,
PF9 to change the width is only available for report, not edit a table. |
|
| Back to top |
|
 |
jim haire Beginner
Joined: 30 Dec 2002 Posts: 140 Topics: 40
|
Posted: Mon Nov 26, 2007 3:34 pm Post subject: |
|
|
| If you press the PF5 key (Show field) it will display the entire contents of the field. |
|
| Back to top |
|
 |
jim haire Beginner
Joined: 30 Dec 2002 Posts: 140 Topics: 40
|
Posted: Mon Nov 26, 2007 3:37 pm Post subject: |
|
|
Sorry, I meant to say:
1. Place your cursor in the field to be edited.
2. Press PF5 (Show field) to display the entire contents of the field. |
|
| Back to top |
|
 |
danm Intermediate
Joined: 29 Jun 2004 Posts: 170 Topics: 73
|
Posted: Tue Nov 27, 2007 3:36 pm Post subject: |
|
|
jim haire,
This is exactly what I do. The problem is every time after a new search, I need to press PF5 to see the entire field. I would like QMF to display all the contents without me pressing the PF5 key for every search. |
|
| Back to top |
|
 |
CraigG Intermediate
Joined: 02 May 2007 Posts: 202 Topics: 0 Location: Viginia, USA
|
Posted: Tue Nov 27, 2007 3:52 pm Post subject: |
|
|
| danm wrote: | jim haire,
This is exactly what I do. The problem is every time after a new search, I need to press PF5 to see the entire field. I would like QMF to display all the contents without me pressing the PF5 key for every search. |
Have you tried PF1? |
|
| Back to top |
|
 |
jim haire Beginner
Joined: 30 Dec 2002 Posts: 140 Topics: 40
|
Posted: Wed Nov 28, 2007 12:28 pm Post subject: |
|
|
Personally, I don't feel that QMF is the best product for editing DB2 data.
Do you have Fileaid for DB2, Princeton Softech, or any Platinum tools in your shop? These provide DB2 data in a manner that you would see a sequential file and would display the entire column(s) for each record which makes it easier to edit. |
|
| Back to top |
|
 |
|
|
|