/*
***************   SDAT sql to list SDAT data  ***************
**
** This is an example of how to create an ordered listing of the entity elements. 
**This is example code.  Use ** this technique to create reports for other parts 
** of the system when needed.  Note especially the ability to ** create a s subset 
** by introducing a “where” clause and adding some input parameters for either Chronjob 
** or job submission.
**
** Instructional code only.
** 
** ©  2005, 2006 SungardHE Not for publication or web publication, all rights reserved.
**
*/

Set TERM OFF

Set Lin 140 PAUSE OFF PAGES 60 NEWP 0 EMBEDDED OFF

Break ON ENTITY NODUP SKIP 2 ON ATTRIBUTE NODUP SKIP 2

Title 'Sungard  Ftvsdat Listing'

Spool SDATLST

Select 
 FTVSDAT_SDAT_CODE_ENTITY Entity,
 FTVSDAT_SDAT_CODE_ATTR Attribute,
 FTVSDAT_SDAT_CODE_OPT_1 Option_1,
 FTVSDAT_SDAT_CODE_OPT_2 Option_2,
 FTVSDAT_CODE_LEVEL Lv,
 FTVSDAT_COAS_CODE C,
 FTVSDAT_EFF_DATE Eff_Date,
 FTVSDAT_STATUS_IND S,
 FTVSDAT_TITLE Title,
 FTVSDAT_DATA Other_Data
From FTVSDAT
/*  Insert a Where clause here to locate a subset */
Order By  
FTVSDAT_SDAT_CODE_ENTITY,
 FTVSDAT_SDAT_CODE_ATTR,
 FTVSDAT_SDAT_CODE_OPT_1,
 FTVSDAT_SDAT_CODE_OPT_2,
 FTVSDAT_CODE_LEVEL,
 FTVSDAT_COAS_CODE,
 FTVSDAT_EFF_DATE,
 FTVSDAT_ACTIVITY_DATE
/
Spool OFF
Set TERM ON
Sta LOGIN