|
View previous topic :: View next topic
|
| Author |
Message |
ibmmainframe1
New User
.jpg)
Joined: 26 Jul 2005
Posts: 64
Location: India
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
ibmmainframe1
New User
Joined: 26 Jul 2005
Posts: 64
Location: India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
|
|
