Select Lists
- CLEARSELECT
- Sets a select list to empty.
- DELETELIST
- Deletes a select list saved in the &SAVEDLISTS& file.
- GETLIST
- Activates a saved select list so it can be used by a READNEXT statement.
- READLIST
- Assigns an active select list to a variable.
- READNEXT
- Assigns the next record ID from an active select list to a variable.
- SELECT
- Creates a list of all record IDs in an InfoSphere® DataStage® file for use by a subsequent READNEXT statement.
- SELECTE
- Assigns the contents of select list 0 to a variable.
- SELECTINDEX
- Creates select lists from secondary key indexes.
- SELECTINFO( )
- Returns the activity status of a select list.
- SSELECT
- Creates a sorted list of all record IDs from an InfoSphere DataStage file.
- WRITELIST
- Saves a list as a record in the &SAVEDLISTS& file.