Re: SQL Write?

You must have the SQL licensed product, since you can do embedded. So STRSQL, 
then enter your SELECT statement that gets the records you want. This is to 
ensure you have the right statement. Then F13 and option 1 to change options - 
change the output to 3 for database file, set the other stuff, and press enter 
a couple times to run the SELECT again.

Or STRQM, take option 1, F19 if needed to change to SQL type instead of PROMPT 
type. Then create a new QMQRY - put your SELECT statement in there - it is 
promptable with the same interface, mostly, as STRSQL. Test it with F5. When 
satisfied, exit and save it. Take option 9 to run it, change the output to file 
and fill in the appropriate values. Badabing!

HTH
Vern


-------------- Original message -------------- 

> I have a simple SQL question. Nobody in my shop uses it except me, and 
> the little I know I've learned on my own and from reading messages in this 
> list. I know how to create a cursor and fetch the records. That's about 
> all. :) So... my question: 
> 
> I have a simple request to pull some records from a couple files meeting 
> certain criteria and write it to a database file. No calculations are 
> needed. I can easily do this using OpnQryF or an SQL cursor and fetch 
> each record, then write each one sequentially, but I wanted to know if I 
> had any other options. Is it possible to use SQL to write all the 
> records at once instead of having to fetch and write each record 
> individually? 
> 
> Thanks! 
> 
> Mike 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>