Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

JeniLewis (Programmer) (OP)
1 Jul 09 13:41
I'm looking for a good source for information about running batch queries against a Datacom database, and by "batch" I mean running a query submitted w/JCL, not w/in Dataquery itself.  

Can anyone recommend one?

Specifically, I'm looking for a way to code a query so it will accept a variable (e.g. date).  This may not be possible, which would also be good to know.

Anyone?
papadba (MIS)
1 Jul 09 17:53
Hi Jeni,

You should be able to execute DQBATCH which will run Datacom queries in batch.

This client doesn't use Datacom, but i'll look and see if i've any stasned away.

Suggest you talk with your dba.

 
papadba (MIS)
2 Jul 09 12:52
Hi Jeni,

See if this will help:
//*********************************************************************
//* CHANGE ?'S TO VALID JOBCARD INFORMATION *
//* CHANGE ###### TO VALID USERID *
//* CHANGE %%%%%%%%O USERID'S PASSWORD *
//* CHANGE @@@@@@ TO VALID QUERY NAME (MULTIPLE EXEC'S CAN BE USED) *
//* CHANGE $$$$ TO LAST 4 CHARACTERS OF ADDRESSABLE PRINTER ID. *
//* CHANGE & TO PRINTER OUTPUT CLASSS.*
//*********************************************************************
//JS10     EXEC PGM=DQBATCH
//STEPLIB  DD DISP=SHR,DSN=DATACOM.STEPLIB
//SYSPRINT DD SYSOUT=(&,,$$$$)
//SYSUDUMP DD SYSOUT=*
//SNAPER   DD SYSOUT=*
//SORTWK01 DD UNIT=SYSDA,SPACE=(TRK,(30,30),RLSE)
//SORTWK02 DD UNIT=SYSDA,SPACE=(TRK,(30,30),RLSE)
//SORTWK03 DD UNIT=SYSDA,SPACE=(TRK,(30,30),RLSE)
//SYSIN DD *
SIGN/ON ###### PASSWORD %%%%%%%%
EXEC @@@@@@
/*

Someone was kind enough to quickly reply when i asked for the jcl<d>

Good luck.
JeniLewis (Programmer) (OP)
6 Jul 09 9:35
Thanks for your suggestions.

My specific issue is that the query I'm converting to batch usage uses a date range which in the on-line version can be supplied by the person running the query.  For example:

FIND ALL SOMR                             
    SOSOM-CMPL-DTE > '909371' < '909378'  
    SOSOMA-SRV-O-ST = 'K'                 
    SOSOMA-SRV-OR-T = 'DNP' 'DNPFM' 'PV'  

(I know the date format looks silly -- it's just one more thing to contend with, but it's not a Datacom thing.)

So, I need the search argument within the query to be able to pull a date from some other source, and I don't know how to code the "SOSOM-CMPL-DTE > '909371' < '909378'" statement so those dates can be supplied at run-time, nor do I know where to place the dates so they'd be recognized by the query and plugged into the appropriate place.

I've checked what passes for a user manual in my shop but its only reference to batch processing does not refer to a TSO-submitted job but one submitted in DQRY.

Any other thoughts?

Thank you for your prompt response


 
JeniLewis (Programmer) (OP)
6 Jul 09 9:37
P.S. I talked to my DBA and he suggested I check with a fellow programmer.  Sigh.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close