View previous topic :: View next topic
|
Author |
Message |
dineshchaudhry
New User
Joined: 26 Mar 2009 Posts: 9 Location: India
|
|
|
|
I am trying to load MQ from a dataset using utility CSQUTIL. I used the following JCL
//COPY EXEC PGM=CSQUTIL,PARM='<Q_MGR>'
//STEPLIB DD DISP=SHR,DSN=thlqual.SCSQANLE
// DD DISP=SHR,DSN=thlqual.SCSQAUTH
//OUTPUTA DD DSN=<INPUT DSN of RECFM=FB>,
// DISP=SHR,DCB=(EROPT=ACC)
//CSQUOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
LOAD QUEUE(<Q_NAME>) -
DDNAME(OUTPUTA)
/*
If I do not specify "DISP=SHR,DCB=(EROPT=ACC)", the job abends with error "DCB EROPT=ABE OR AN INVALID CODE".
If I specify "DISP=SHR,DCB=(EROPT=ACC)", the job abends with RC=8 ("LOAD statement failed").
What can be done to overcome this problem ? |
|
Back to top |
|
|
dineshchaudhry
New User
Joined: 26 Mar 2009 Posts: 9 Location: India
|
|
|
|
continuing on the same question...
I tried copying the FB dataset into VBS dataset and used the VBS dataset for load, still the job is failing with error "CSQU062E Incorrect format data record". |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
This Thread should answer your question. |
|
Back to top |
|
|
dineshchaudhry
New User
Joined: 26 Mar 2009 Posts: 9 Location: India
|
|
|
|
What is meant by "CSQUTIL is intended to LOAD records that were output of a COPY. To load your own flat file, you need a program to do MQPUTs."
Does this mean that we cannot load from a dataset to MQ using CSQUTIL?
I am copying the data from FB to VBS and using the copied dataset for load into MQ. Still the job is failing with "CSQU062E Incorrect format data record". |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
If you did not use CSQUTIL with a COPY to create the file, you cannot use LOAD to move data from that dataset to MQ. It seems pretty simple to me, and I do not use MQ. |
|
Back to top |
|
|
dineshchaudhry
New User
Joined: 26 Mar 2009 Posts: 9 Location: India
|
|
|
|
Is it possible to use copy in the same step of CSQUTIL ?
I tried wherein the same JCL copies FB data into VBS data as first step, followed by the step to load the copied VBS data into MQ (JCL given below).
Below is the SQL I used.
//COPYFILE EXEC PGM=IDCAMS
//INFIL DD DSN=<INPUT FB DATASET>,DISP=SHR
//OUTFIL DD DSN=<OUTPUT VBS DATASET>,
// DCB=(RECFM=VBS,LRECL=600,BLKSIZE=200),
// SPACE=(TRK,(10,10)),DISP=(NEW,CATLG,DELETE)
//SYSPRINT DD SYSOUT=*
//SYSABEND DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
REPRO INFILE(INFIL) OUTFILE(OUTFIL) REPLACE
//*
//LOADMQ EXEC PGM=CSQUTIL,PARM='QM01'
//STEPLIB DD DSN=MQM.SCSQLOAD,DISP=SHR
// DD DSN=MQM.SCSQAUTH,DISP=SHR
// DD DSN=MQM.SCSQANLE,DISP=SHR
//OUTFIL DD DSN=<OUTPUTDATASET OF PREV STEP>,DISP=SHR
//*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
LOAD QUEUE(Q.TEST.IN) DDNAME(OUTFIL)
/* |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Question: in your JCL, do you see an execution of CSQUTIL with the control statement "COPY"?
If the answer to that question is "NO", then your CSQUTIL execution with the control statement "LOAD" in not valid. Period. End of story. It doesn't matter what you do otherwise, it ain't gonna work. Why are you having trouble understanding that?
WRITE THE PROGRAM TO DO THE LOAD! |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
I believe the 'copy' referred to in
Quote: |
If you did not use CSQUTIL with a COPY to create the file |
means a COPY created by CSQUTIL, maybe from an UNLOAD QUEUE??????? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Dick, ya think maybe? |
|
Back to top |
|
|
|