Need information about VGET



TSO Programming, ISPF, SDF, SDSF and PDF, FTP, TCP/IP Concepts, SNA & SNA/IP etc...

Re: Need information about VGET

Postby 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
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
Peter
Peter_Mann
 
Posts: 145
Joined: Fri Jun 24, 2011 7:37 pm
Location: Lowell,AR
Has thanked: 15 times
Been thanked: 3 times

Re: Need information about VGET

Postby 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.
Pedro Vera
User avatar
Pedro
 
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Re: Need information about VGET

Postby 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
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?
surime72
 
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need information about VGET

Postby 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()
Pedro Vera
User avatar
Pedro
 
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Previous

Return to TSO & ISPF