/*  
** An example of how to migrate the job submission parameters from a primary development 
** chart,in this case Chart 'A' to a production chart.  Potentially, the migration could be
** to many charts.  This is left to the developer.
**
**  DO NOT RUN IN PRODUCTION As SHOWN.
**
** Instructional code only.
** 
** ©  2001, 2006 Sungard HE Not for publication, all rights reserved.
**
*/

/* Find all job submission parameters where chart = 'A'*/

select gjbpdft_job JOB,
  gjbpdft_number DNUM,
  gjbpdft_VALUE DVAL
  from gjbpdft, gjbpdef
  where gjbpdef_job like 'F%'
  and gjbpdft_job = gjbpdef_job
  and gjbpdft_number = gjbpdef_number
  and gjbpdef_validation = 'FTVCOAS_EQUAL'
 and gjbpdft_value = 'A';

/* And Change it to your Chart*/

 update gjbpdft
  set gjbpdft_value = '1'
  where
  gjbpdft_value = 'A'
  and gjbpdft.rowid in
     (Select gjbpdft.rowid
        FROM gjbpdft, gjbpdef
        WHERE gjbpdft_value = 'A'
        and gjbpdef_job like 'F%'
        and gjbpdft_job = gjbpdef_job
        and gjbpdft_number = gjbpdef_number
        and gjbpdef_validation = 'FTVCOAS_EQUAL'
      );