DB2 for z/OS - QMF in batch

Jim McAlpine

DB2 for z/OS - QMF in batch
Is there a way to run QMF in batch.

Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856

CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com



This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David S. Waugh

Re: DB2 for z/OS - QMF in batch
(in response to Jim McAlpine)
Yes, there is. Do you need an example of the JCL to do it, or do you have
some questions about it?
.
David Waugh
IM-3 DB2 Database Administration
Los Alamos National Laboratory




Jim McAlpine <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/09/2006 10:42 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] DB2 for z/OS - QMF in batch






Is there a way to run QMF in batch.
Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856
CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Any unauthorised distribution or copying is strictly prohibited. Whilst
CedarOpenAccounts takes steps to prevent the transmission of viruses via
e-mail, we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your own
anti-virus precautions. CedarOpenAccounts grants no warranties regarding
performance, use or quality of any e-mail or attachment and undertakes no
liability for loss or damage, howsoever caused.
CedarOpenAccounts is a trading name for Cedar Software Ltd and
OpenAccounts Ltd.
For more information on CedarOpenAccounts and our products, please visit
our web site at http://www.cedaropenaccounts.com


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ian Cronk

Re: DB2 for z/OS - QMF in batch
(in response to David S. Waugh)
Hi Jim
I am sure that you realize that on the command line you can execute a QMF QUERY with or without FORMS by typing in BATCH
Regards Ian Cronk

Jim McAlpine <[login to unmask email]> wrote:
Is there a way to run QMF in batch.
Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856
CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com

---------------------------------

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any unauthorised distribution or copying is strictly prohibited. Whilst CedarOpenAccounts takes steps to prevent the transmission of viruses via e-mail, we cannot guarantee that any email or attachment is free from computer viruses and you are strongly advised to undertake your own anti-virus precautions. CedarOpenAccounts grants no warranties regarding performance, use or quality of any e-mail or attachment and undertakes no liability for loss or damage, howsoever caused.
CedarOpenAccounts is a trading name for Cedar Software Ltd and OpenAccounts Ltd.
For more information on CedarOpenAccounts and our products, please visit our web site at http://www.cedaropenaccounts.com

---------------------------------


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cristian Molaro

Re: DB2 for z/OS - QMF in batch
(in response to Ian Cronk)
Hi Jim,

Find hereafter a sample for running QMF procs in Batch.
Remember to use CONFIRM=NO in your queries when needed, as follows:

RUN USERID.PROC_NUMBER_ONE (CONF = NO

Regards,

Cristian Molaro
MConsulting.be
Belgium

//JOBCARD GOES HERE
//*-------------------------------------------------------------------
//QMFBATCH EXEC PGM=IKJEFT01,DYNAMNBR=100,REGION=4096K
//* TSO DATA SETS
//SYSEXEC DD DSN=QMF720.SDSQEXCE,DISP=SHR
//SYSPROC DD DSN=ISPF.CLIST,DISP=SHR
// DD DSN=QMF720.SDSQCLTE,DISP=SHR
//SYSHELP DD DSN=SYS1.HELP,DISP=SHR
//SYSLBC DD DSN=SYS1.BRODCAST,DISP=SHR
//* ISPF DATA SETS
//ISPPLIB DD DSN=QMF720.SDSQPLBE,DISP=SHR
//ISPMLIB DD DSN=QMF720.SDSQMLBE,DISP=SHR
//ISPTLIB DD DSN=SYS1.ISP.SISPTENU,DISP=SHR
//ISPSLIB DD DSN=QMF720.SDSQSLBE,DISP=SHR
//ISPPROF DD DSN=&PROF,UNIT=VIO,SPACE=(TRK,(9,1,4)),DCB=(LRECL=80,
// BLKSIZE=3120,RECFM=FB,DSORG=PO),DISP=(NEW,PASS,DELETE)
//ISPLOG DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=3990)
//* QMF/GDDM DATA SETS
//ADMGGMAP DD DSN=QMF720.DSQMAPE,DISP=SHR
//ADMCFORM DD DSN=QMF720.DSQCHART,DISP=SHR
//ADMSYMBL DD DSN=GDDM.ADMSYMBL,DISP=SHR
// DD DSN=GDDM230.SGDDMSYM,DISP=SHR
//ADMGDF DD DSN=GDDM.ADMGDF,DISP=SHR
//* QMF DATA SETS
//DSQUDUMP DD SYSOUT=X,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=3990)
//DSQDEBUG DD SYSOUT=X,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=3990)
//DSQSPILL DD UNIT=VIO,DISP=(NEW,DELETE),SPACE=(CYL,(1,1)),
// DCB=(RECFM=F,LRECL=4096,BLKSIZE=4096)
//DSQEDIT DD UNIT=VIO,DISP=(NEW,DELETE),SPACE=(CYL,(1,1)),
// DCB=(RECFM=F,LRECL=4096,BLKSIZE=4096)
//SYSTSPRT DD SYSOUT=*
//*-------------------------------------------------------------------
//* DSN? IS YOU DB2 SUBSYSTEM
//* YOUR.PROC IS YOUR QMF PROCEDURE
//*-------------------------------------------------------------------
//SYSTSIN DD *
EXECUTIL SEARCHDD(YES)
ISPSTART PGM(DSQQMFE) PARM(S=DSN?,M=B,I=YOUR.PROC)
LOGOFF
/*

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim McAlpine

Re: DB2 for z/OS - QMF in batch
(in response to Cristian Molaro)
Thanks to all for the samples and tips.

Regards

Jim McAlpine

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Cristian Molaro
Sent: 10 January 2006 09:08
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - QMF in batch


Hi Jim,

Find hereafter a sample for running QMF procs in Batch.
Remember to use CONFIRM=NO in your queries when needed, as follows:

RUN USERID.PROC_NUMBER_ONE (CONF = NO

Regards,

Cristian Molaro
MConsulting.be
Belgium

//JOBCARD GOES HERE
//*-------------------------------------------------------------------
//QMFBATCH EXEC PGM=IKJEFT01,DYNAMNBR=100,REGION=4096K
//* TSO DATA SETS
//SYSEXEC DD DSN=QMF720.SDSQEXCE,DISP=SHR
//SYSPROC DD DSN=ISPF.CLIST,DISP=SHR
// DD DSN=QMF720.SDSQCLTE,DISP=SHR
//SYSHELP DD DSN=SYS1.HELP,DISP=SHR
//SYSLBC DD DSN=SYS1.BRODCAST,DISP=SHR
//* ISPF DATA SETS
//ISPPLIB DD DSN=QMF720.SDSQPLBE,DISP=SHR
//ISPMLIB DD DSN=QMF720.SDSQMLBE,DISP=SHR
//ISPTLIB DD DSN=SYS1.ISP.SISPTENU,DISP=SHR
//ISPSLIB DD DSN=QMF720.SDSQSLBE,DISP=SHR
//ISPPROF DD DSN=&PROF,UNIT=VIO,SPACE=(TRK,(9,1,4)),DCB=(LRECL=80,
// BLKSIZE=3120,RECFM=FB,DSORG=PO),DISP=(NEW,PASS,DELETE)
//ISPLOG DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=3990)
//* QMF/GDDM DATA SETS
//ADMGGMAP DD DSN=QMF720.DSQMAPE,DISP=SHR
//ADMCFORM DD DSN=QMF720.DSQCHART,DISP=SHR
//ADMSYMBL DD DSN=GDDM.ADMSYMBL,DISP=SHR
// DD DSN=GDDM230.SGDDMSYM,DISP=SHR
//ADMGDF DD DSN=GDDM.ADMGDF,DISP=SHR
//* QMF DATA SETS
//DSQUDUMP DD SYSOUT=X,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=3990)
//DSQDEBUG DD SYSOUT=X,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=3990)
//DSQSPILL DD UNIT=VIO,DISP=(NEW,DELETE),SPACE=(CYL,(1,1)),
// DCB=(RECFM=F,LRECL=4096,BLKSIZE=4096)
//DSQEDIT DD UNIT=VIO,DISP=(NEW,DELETE),SPACE=(CYL,(1,1)),
// DCB=(RECFM=F,LRECL=4096,BLKSIZE=4096)
//SYSTSPRT DD SYSOUT=*
//*-------------------------------------------------------------------
//* DSN? IS YOU DB2 SUBSYSTEM
//* YOUR.PROC IS YOUR QMF PROCEDURE
//*-------------------------------------------------------------------
//SYSTSIN DD *
EXECUTIL SEARCHDD(YES)
ISPSTART PGM(DSQQMFE) PARM(S=DSN?,M=B,I=YOUR.PROC)
LOGOFF
/*

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm