I have created one rexx code with scrollable panel. Function of rexx code is to retrieve column names for particular DB2 table and display them on panel.
Now following things are working fine for me..
1. Rexx code(Successfully retrieving DB2 column names for a table.)
2. Panel with scroll is working successfully(Currently data is not displayed). I checked it with only adding lines in panel it is scrolling successfully. I am not using )MODEL command in panel... can we perform as per my requirement without using )MODEL command??
Now the problem is I am not able to display retrieved column names of table on panel as I have assigned only one variable and getting only one value on panel... Could any one help me for this??
My panel code...
` TYPE(PT) /* panel title line */
? TYPE(PIN) /* panel instruction line */
< TYPE(FP) /* field prompt attribute */
# TYPE(NT) /* normal text attribute */
$ TYPE(NEF) PADC(_) /* normal entry field padded with '_' */
! TYPE(DT) /* description text */
~ AREA(SCRL) /* scrollable area attribute */
¢ type(input) PAD('_')
`-------------- TITLE FOR PANEL WITH SCROLLABLE AREAS ------------------
#Command ===>_ZCMD #
? this direction line tells the user how to use the panel:
<Field prompt . . . . . .$NEF01 #!(NEF Descriptive Text) #
Joined: 26 Apr 2004 Posts: 4650 Location: Raleigh, NC, USA
Now the problem is I am not able to display retrieved column names of table on panel as I have assigned only one variable and getting only one value on panel.
That's your problem. A variable can only be used once. You need to define more of the variables S, N, and P (like S1,S2,S3,N1,N2,N3,P1,P2,P3 and so on) for as much of the content you wish to place onto the panel. I don't see what advantage you want with this method rather than using a plain non-scrolling panel, unless you want to display more details than a single panel will allow, in which case a scrollable panel is a good idea. But you do have to know up-front how much data needs to be shown, and how many variables you'll need to hold it in.
can we perform as per my requirement without using )MODEL command?
If I'm interpreting what you want for your output results correctly, my answer is NO, you can't.