Hi Graham,
DSNUPROC is aJCL procedure for executing DB2 utilities. DSNUTILB is
the DB2 utility program.
To create DB2 objetcts using DSNUTILB, you nees to use the EXEC SQL online
utility control statement.
To create your STOGROUP using DSNUPROC , your JCL woul;d be something
like :
//STEP1 EXEC DSNUPROC,SYSTEM=ssid,UID='',UTPROC='' <==== ssid is
your DB2 subsystem id.
//DSNUPROC.SYSPRINT DD SYSOUT=(*)
//DSNUPROC.UTPRINT DD SYSOUT=(*)
//DSNUPROC.SYSIN DD *
EXEC SQL
CREATE STOGROUP CHELGRP
VOLUME VPWRKD
VCAT CHELCAT
ENDEXEC
/*
To do it using IKJEFT01, you need to use one of the IBM sample programs to
process the DDL.the TSO DSN command cannot execute SQL.
Heres an example from the DB2 IVP job DSNTEJ1 :
//PH01S01 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(ssid)
RUN PROGRAM(DSNTIAD) PLAN(DSNTIAD) -
LIB('your.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
CREATE STOGROUP CHELGRP
VOLUME VPWRKD
VCAT CHELCAT
;
/*
Regards,
Ron
From: Graham Hobbs <[email protected]>
To: [email protected]
Date: 27/05/2013 01:10 AM
Subject: DFHUTILB and DFHUPROC
Sent by: IBM Mainframe Discussion List <[email protected]>
Wisdom sought please! I have tried to build a stogroup via batch job.
CREATE STOGROUP CHELGRP
VOLUME VPWRKD
VCAT CHELCAT
Seems DFHUPROC and DFHUTILB are options. Is one more common than the other?
Is it that the first calls the second (amongst others)?
Cheers,
Graham Hobbs
P.S. Secretly am looking for JCL that bl..dy works:-):-[
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
_______________________________________________________________________________
This email has been scanned by the Bankwest Email Security System.
_______________________________________________________________________________
_______________________________________________________________________________
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure by law.
Any claim to privilege is not waived or lost by reason of mistaken transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data corruption,
delay, interruption, unauthorised access or unauthorised amendment.
_______________________________________________________________________________
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
