|
View previous topic :: View next topic
|
| Author |
Message |
kansassho
New User
.jpg)
Joined: 31 Mar 2008
Posts: 14
Location: kansas city
|
|
|
|
I want first to get selected records(matching a specified value for a column in the table) from an ISPF table and then write these record to a sequential file.
Please help me how to proceed.
Can someone please provide me some examples. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Take a look at TBSCAN and TBSORT
Documents easily reached from the reference material sticky in the CLIST/REXX forum. |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
Another fun way is to use a skeleton:
The skeleton could be:
| Code: |
)DOT tbname SCAN(FLDM3,EQ)
&FLDM3 &FLDM1 &FLDM2
)ENDDOT |
And the REXX would be:
| Code: |
Address TSO "ALLOC FI(ISPFILE) DA('my.dsn') SHR"
FLDM3 = 'XX'
"FTOPEN"
"FTINCL skelname"
"FTCLOSE" |
The line "&FLDM3 &FLDM1 &FLDM2" can be formatted in many ways too. |
|
| Back to top |
|
|
|
|
