1

I Have created a REXX program to fetch 3 columns from a table.

I have kept temporary variables to hold SQL values (takes automatic datatype as per input) Its like:

 ADDRESS DSNREXX "EXECSQL FETCH C1 INTO :IN, :CR, :TN"

Now i have created A Panel, but i only know that we assign options. Which is done like giving

 %option_name

But havent got any book or online forum about how to display those REXX program variables to screen.

There are forums only for Calling a panel which have its own functionality.

Agent Mahone
  • 307
  • 3
  • 15
  • 26
  • Are you trying to display on Ispf panels ???, I do not understand the relevance of %option_name. Mind you it has been a while since I used ISPF. – Bruce Martin Sep 12 '14 at 02:15

1 Answers1

3

In ISPF panels, any 8 character rexx variable can be displayed either using the &var. format or prefixing it with a field definition char (say _ for an entry field). e.g.

Rexx:

 v1 = '...'
 v2 = '..'
 v3 = '.'

ISPF Panel:

)body
+  V1 = &v1.        Display the value (... will be displayed)  
+  v2 :_V2     +    Allow the user to update v2

See http://publib.boulder.ibm.com/infocenter/zvm/v5r4/index.jsp?topic=/com.ibm.zvm.v54.dmsa3/ispfpan.htm

Sample ispf panel definition 

)BODY
%---------------------------  EMPLOYEE RECORDS  ------------------------------
%COMMAND ===>_ZCMD
%
%EMPLOYEE SERIAL: &EMPSER
+
+   TYPE OF CHANGE%===>_TYPECHG  +  (NEW, UPDATE, OR DELETE)
+
+   EMPLOYEE NAME:
+     LAST   %===>_LNAME          +
+     FIRST  %===>_FNAME          +
+     INITIAL%===>_I+
+
+   HOME ADDRESS:
+     LINE 1 %===>_ADDR1                                    +
+     LINE 2 %===>_ADDR2                                    +
+     LINE 3 %===>_ADDR3                                    +

If more than 1 row is being displayed, you may find it useful to

  • Add the returned rows to a ISPF table
  • Display the table using the TBDISPL service.
  • Note: for Table display panels you must include a )Model section for data in the table

If you want to use ISPF Tables see http://rexxpertise.blogspot.com.au/2011/11/ispf-tables-defining-and-building.html for examples of TBCREATE and TBADD

Also for a complicated example ISPF Table

Have a look at question

General ISPF info is available at:

Community
  • 1
  • 1
Bruce Martin
  • 10,358
  • 1
  • 27
  • 38
  • 1
    Documentation for supported versions of z/OS (OS/390 went out of service in 2004) are available at http://www-03.ibm.com/systems/z/os/zos/library/bkserv/index.html or the IBM Knowledge Center at https://www-01.ibm.com/support/knowledgecenter/#!/. – cschneid Sep 12 '14 at 11:45