IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Load MQ using JCL - CSQUTIL


IBM Mainframe Forums -> Java & MQSeries
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
feellikeneo

New User


Joined: 19 Mar 2007
Posts: 73
Location: Chennai

PostPosted: Wed Jul 30, 2008 11:54 am
Reply with quote

Hi,

I am using CSQUTIL utility to LOAD a MQ from a Sequential Dataset (RECFM=FB). This is the JCL I am using,

Code:
//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)                                   
/*                                                       


I first tried without giving "DCB=(EROPT=ACC)" but my job abended saying "DCB EROPT=ABE OR AN INVALID CODE"

Then I tried giving "DCB=(EROPT=ACC)"but then job ends with RC=8 with no records loaded.

My question is,
-Is it mandatory to use a file of VBS to load an MQ using CSQUTIL ?
-If yes, how can i convert my file in FB to VBS without affecting the data (I know this question should not be posted here, but then this somehow relates to MQ)

Thanks in advance for your help on this.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jul 30, 2008 7:41 pm
Reply with quote

Hello,

Quote:
If yes, how can i convert my file in FB to VBS without affecting the data
You can use your sort product to copy the fb file to a vbs file (i just did). All you need to do is specify the SORTOUT as a vbs file (i.e. // DCB=(RECFM=VBS,LRECL=80,BLKSIZE=2000), or whatever).

I don't know if vbs is mandatory. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Java & MQSeries

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts REASON 00D70014 in load utility DB2 6
No new posts DB2 Load - Sort Or order BY DB2 1
No new posts DB2 Load - NUMRECS DB2 3
Search our Forums:

Back to Top