Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Precompile Problem

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
ibmmainframe1

New User


Joined: 26 Jul 2005
Posts: 64
Location: India

PostPosted: Thu Nov 05, 2009 9:50 pm    Post subject: Precompile Problem
Reply with quote

I am using this JCL to precompile somehow its not recognising the host variables. Job is failing with RC 8. I created the JCL using Xpediter.
I am running only this job alone not the compile one which I should do next.

If I compile in changeman I am not getting the error. Job is successful.

Code:
000009 //PC     EXEC  PGM=DSNHPC,REGION=4M,                             
000010 //       PARM=('HOST(IBMCOB),XREF,SOURCE,QUOTE,APOST,APOSTSQL', 
000011 //            'VERSION(CSWC007558-PLANNED)')                     
000012 //STEPLIB  DD  DISP=SHR,DSN=SYSDB2.DSN3.SSPGM                   
000013 //DBRMLIB  DD  DISP=SHR,DSN=CSWCNSA.TEST.DBR(CS001478)           
000014 //SYSCIN   DD  DISP=(MOD,PASS),DCB=(RECFM=FB,BLKSIZE=4000),     


error
Code:
1DB2 SQL PRECOMPILER         MESSAGES                                         
0DSNH312I E     DSNHSMUD LINE 3305 COL 26  UNDEFINED OR UNUSABLE HOST VARIABLE
 DSNH312I E     DSNHSMUD LINE 3830 COL 46  UNDEFINED OR UNUSABLE HOST VARIABLE
 DSNH312I E     DSNHSMUD LINE 3831 COL 46  UNDEFINED OR UNUSABLE HOST VARIABLE
 DSNH312I E     DSNHSMUD LINE 3832 COL 46  UNDEFINED OR UNUSABLE HOST VARIABLE
 DSNH312I E     DSNHSMUD LINE 3833 COL 46  UNDEFINED OR UNUSABLE HOST VARIABLE
1DB2 SQL PRECOMPILER         STATISTICS                                       
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10626
Location: italy

PostPosted: Thu Nov 05, 2009 9:54 pm    Post subject: Reply to: Precompile Problem
Reply with quote

that should teach You the lesson...
never reinvent the wheel use the procedures provided by Your organization.

if You have/demonstrate the business need to run the job as You described, Your support will be glad to help You
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Nov 05, 2009 9:58 pm    Post subject:
Reply with quote

more than likely, the CHANGEMAN procedure (developed by your site)
insures that COBOL COPY directives are invoked prior to the db2 pre-compile.

had you bothered to look at the lines referenced by the error messages,
you probably would have found that the host variables were not in the source used by the db2 pre-compiler.
Back to top
View user's profile Send private message
ibmmainframe1

New User


Joined: 26 Jul 2005
Posts: 64
Location: India

PostPosted: Thu Nov 05, 2009 10:05 pm    Post subject:
Reply with quote

I totally agree with both of you. In my SYSLIB I am including the copybook PDS then why its not referring it.

Since I cannot compile with xped option in changeman I am trying to do it using my jcl.


Thanks.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Thu Nov 05, 2009 10:21 pm    Post subject:
Reply with quote

Hello,

If there is a need to have an xped/changeman compile process, the support group needs to create one so that the developers have a common process to use. . .

It is best not to "roll your own" compile jcl.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Nov 05, 2009 10:55 pm    Post subject:
Reply with quote

experience has shown when there is high compilation activity with xped option,
sometimes the compile will blow because there are too many accesses on the ddio file.

since that is unacceptable, users requested/forced

xpeditor to have a copy option
that will take the endevor archived compile output listing
and load it to the xpeditor ddio file.

maybe your site in beyond the stone-age
and xpeditor has such an option at your site.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Having problem passing a variable to ... markzasz JCL & VSAM 12 Thu Jul 11, 2019 5:31 pm
No new posts Pipeline scan problem John Poulakos CICS 1 Thu Feb 28, 2019 10:02 pm
This topic is locked: you cannot edit posts or make replies. Problem while Decompressing the ZIP file Nethraa All Other Mainframe Topics 2 Tue Feb 26, 2019 6:55 am
No new posts Problem while Decompressing the ZIP file Nethraa All Other Mainframe Topics 6 Fri Feb 22, 2019 11:41 pm
No new posts Problem with OVERLAY - BI on SMF Record Ghellar DFSORT/ICETOOL 4 Sat Dec 01, 2018 9:41 pm

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