IBM Mainframe Forum

by **Peter_Mann** » Sat Jun 09, 2012 2:21 am

Well actually if its a table and not a profile variable does'nt he need to use TBGET? not VGET, VGET is for variables in POOLS and as I remember (unless something has changed) only one value can be stored in a profile variable, if indeed your data is in a table then

Select all

ISPEXEC TBGET TABLENAM SAVENAME(VAR-NAME) ROWID(ROWIDNAM) +
NOREAD POSITION(CRPNAME)
IF &LASTCC ¬= 0 THEN /* RETURN CODES */ +
DO /* 8 - KEYED TABLES: ROW DOES NOT EXIST,*/
END /* CRP SET TO TOP */
ELSE /* - NON-KEYED TABLES: CRP REMAINS AT */ +
/* TOP */
/* 12 - TABLE IS NOT OPEN */
/* 16 - DATA TRUNCATION OR INSUFFICIENT */
/* SPACE PROVIDED TO RETURN ALL */
/* EXTENSION VARIABLE NAMES */
/* 20 - SEVERE ERROR */

would be what the op needs, correct?
am I misunderstanding?
Peteer

by **Pedro** » Sat Jun 09, 2012 4:34 am

I recommended the use of TBSKIP to process the entire table, one row at a time.

From the ISPF services guide, describing TBSKIP:

All variables in the row, including keys and extension variables, if any,
are stored into the corresponding dialog variables.

by **surime72** » Mon Jun 11, 2012 12:30 pm

thank u guys for replying....

i had a one more doubt ...if the user modify two rows at time i.e

Select all

abc
123
456
.
.
www

here user modify two rows i.e '123' to some 'ddd' and 'www' to some 'xxx'

foe this tbskip is useful?

by **Pedro** » Mon Jun 11, 2012 6:57 pm

Read the section 'Processing selected rows' in ISPF Dialog Developers Guide and Reference. In summary, do not use TBSKIP, use TBDISPLAY with no PANEL()

IBM Mainframe Forum

Need information about VGET

Re: Need information about VGET

Re: Need information about VGET

Re: Need information about VGET

Re: Need information about VGET