Re: Way to get STRSQL SELECT to run in batch?

[vhamberg@xxxxxxxxxxx]

There are a number of utilities that use QM to do ad hoc SQL statements of almost any kind. Look up EXCSQLSTM in google, I think, for at least one of them.

-------------- Original message -------------- 
From: alancampin@xxxxxxxxxxx 

> How about just creating a STRQM query and submitting that? 
>
> -------------- Original message ---------------------- 
> From: Dan 
> > I do a lot of one-timer SQLs, some for testing before embedding in an 
> > application, some for data interrogation to determine problems. 
> >
> > Some of the SELECT queries I do, run for hours. Of course, RUNSQLSTM 
> > doesn't support SELECT, otherwise I'd use that to submit to batch. 
> >
> > The one that I have running now is set up to send output to a data file 
> > (F13=Services, 1.Change session attributes, SELECT output: 3=File). 
> >
> > I suppose the way to do this is to create the output table with the fields 
> > specified in the SELECT, then submit to batch a RUNSQLSTM with the same 
> > query, but prefaced with a "INSERT INTO xxxxxxxxxx (" It seems to me that 
> > this would give the same results. Any disagreement there? 
> >
> > But what a PITA! First, I have to manually create the output table, then I 
> > have to put the query in a source member for the RUNSQLSTM, and then submit 
> > the RUNSQLSTM. There's gotta be an easier way. 
> >
> > FWIW, here's the query that's now in its third hour: 
> > select DISTINCT CVCVCD, CVCVLC, CVDEDC, count(*) 
> > from cvgdetl, cusdetl_DE 
> > where CVCUSN = cdCUSN 
> > and CVRENN = cdRENN 
> > and CVSEQN = cdSEQN 
> > and cdstat = 'DE' 
> > group by CVCVCD, CVCVLC, CVDEDC 
> >
> > Any ideas would be greatly appreciated! 
> >
> > - Dan 
> > -- 
> > 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. 
>
> -- 
> 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.