Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
MQ Load utility - CSQUTIL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
dineshchaudhry

New User


Joined: 26 Mar 2009
Posts: 9
Location: India

PostPosted: Thu May 28, 2009 7:05 pm    Post subject: MQ Load utility - CSQUTIL
Reply with quote

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
View user's profile Send private message

dineshchaudhry

New User


Joined: 26 Mar 2009
Posts: 9
Location: India

PostPosted: Thu May 28, 2009 7:08 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu May 28, 2009 7:38 pm    Post subject:
Reply with quote

This Thread should answer your question.
Back to top
View user's profile Send private message
dineshchaudhry

New User


Joined: 26 Mar 2009
Posts: 9
Location: India

PostPosted: Fri May 29, 2009 10:09 am    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8154
Location: East Dubuque, Illinois, USA

PostPosted: Fri May 29, 2009 4:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dineshchaudhry

New User


Joined: 26 Mar 2009
Posts: 9
Location: India

PostPosted: Fri May 29, 2009 5:01 pm    Post subject: Reply to: MQ Load utility - CSQUTIL
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8154
Location: East Dubuque, Illinois, USA

PostPosted: Fri May 29, 2009 5:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri May 29, 2009 5:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8154
Location: East Dubuque, Illinois, USA

PostPosted: Fri May 29, 2009 5:13 pm    Post subject:
Reply with quote

Dick, ya think maybe? icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us