Select Lists and Secondary Indices选择列表和二级指标.docVIP

Select Lists and Secondary Indices Advanced BASIC Programming Techniques Copyright ? 2006, Ray Wurlod. All rights reserved. UniData?, UniVerse? and DataStage? are registered trademarks of International Business Machines Corporation. Contents 1. Introduction 5 What is a Select List? 6 What is a Secondary Index? 6 2. Select Lists 7 Select List Commands 7 Select Lists in Queries 9 Non-SQL Queries 9 SQL Queries 9 Select List Statements 10 Information About Select Lists 11 Example 12 Select Lists and Dynamic Arrays 12 Saved Select Lists 13 Example 13 3. Secondary Indices 14 Information About Secondary Indices 14 Generating Select List from Secondary Index 15 Example 15 4. Select List Set Operations 16 Set Operations with Active Select Lists 16 Example 16 Set Operations with Saved Select Lists 17 Example 17 5. Processing Select Lists 18 Sequential Processing 18 Example 18 Residual Select List 19 Preserving and Reinstating Active Select List 20 Example 20 Select Lists and Execution Layers 21 UniData 21 UniVerse and DataStage 21 6. Processing Index Directly 23 UniData 23 Positioning the Pointer 23 Traversing the Index 24 UniVerse and DataStage 25 Positioning the Pointer 25 Traversing the Index 26 Objectives Having completed this training the student will be able to use BASIC programming techniques: to create and activate Select Lists using commands and statements to retrieve information about active Select Lists to retrieve information about secondary indices on a file to generate a Select List from a secondary index to perform set operations on active and saved Select Lists to configure passing of Select Lists between execution layers Software Versions This material is pitched at UniData version 6.0, UniVerse version 10.1 and DataStage version 7.5 but most of the material is valid at earlier releases. All of the material is valid at later releases. Manuals The following manuals, which contain material pertinent to the topic of this document, can all be downloaded fr