Re: SQL, INSERT Statement

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

insert into mnumst (select 'RPT', option, program from mnumst where menu =
'MAIN')

the subselect, substitutes the RPT constant for the first field and inserts
it into MENU of the MNUMST file.


>
>I have a file (MNUMST) that contains fields: MENU, OPTION, PROGRAM. An
>example set of records would look like:
>MAIN 01 IMRQ101
>MAIN 02 IMRQ102
>MAIN 03 IMRQ103
>...
>Now, I would like to duplicate all records where MENU = 'MAIN' by using
>INSERT and create a new set, i.e.:
>RPT 01 IMRQ101
>RPT 02 IMRQ102
>RPT 03 IMRQ103
>...
>
>Note: I realize, that, by the time I get done asking this question, I could
>have written a program to accomplish this. However, the selection criteria,
>the source, and the target will not be static. Also, to further complicate
>the issue, I'd like to verify who's authorized to the menu options with a
>qualifying WHERE clause (if possible) - introducing a third file.
>
>Anyone help me on this? TIA!!!
>
>Steve Martin
>Programmer/Analyst
>Carefree of Colorado
>303/410.6239
>smartin@carefreeofcolorado.com
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---