Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to resolve SQL CODE = -818

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Mon Feb 02, 2009 2:41 pm    Post subject: how to resolve SQL CODE = -818
Reply with quote

Hi all,

I searched the forum for my answer but i couldn't find exactly so that I'm posting this question.

I got sqlcode -818 while exeuting JCL, it is trying to download from a table using DSNTIAUL utality.

The spool message shown below,

Code:
DSNT408I SQLCODE = -818, ERROR:  THE PRECOMPILER-GENERATED TIMESTAMP 183CF9C0045
         FROM THE BIND TIMESTAMP 1874B82B00A2B823 BUILT FROM THE DBRM DSNTIAUL 
DSNT418I SQLSTATE   = 51003 SQLSTATE RETURN CODE                               
DSNT415I SQLERRP    = DSNXEPM SQL PROCEDURE DETECTING ERROR                     
DSNT416I SQLERRD    = -200  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION           
DSNT416I SQLERRD    = X'FFFFFF38'  X'00000000'  X'00000000'  X'FFFFFFFF'  X'0000
         INFORMATION   

Details of subsystem,Planname,library.

Code:
DSN  SYSTEM(DB01)                                   
RUN  PROGRAM(DSNTIAUL) PLAN(DSNTIB81)  PARM('SQL') -
LIBRARY(DB01S.PROD.RUNLIB.LOAD)   


Please let me know if more information need and Please tell me what's wrong this.

Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Feb 02, 2009 3:11 pm    Post subject:
Reply with quote

What did it say in the manual about the error code and the corrective actions ?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Feb 02, 2009 5:33 pm    Post subject:
Reply with quote

Hi,

BIND the program again & try.
Back to top
View user's profile Send private message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Mon Feb 02, 2009 6:10 pm    Post subject:
Reply with quote

Hi Expat/Anju,

Thanks for you replies.

The problem got solved but i am not clear so i want to be clear.

I will you how it was solved,The loadmodule of DSNTIAUL is there in DB01S.PROD.RUNLIB.LOAD but while exuting the JCL it referring to USERID.DB01S.PROD.RUNLIB.LOAD so i hard coded the DB01S.PROD.RUNLIB.LOAD with single quotes insided the control card.

But still i'am bit confused and not cleart what are all the reasons of getting -818 and how to resolve.If possbile can any of you please explain ?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Feb 02, 2009 7:22 pm    Post subject:
Reply with quote

P.RAJESH wrote:
Hi Expat/Anju,
'am getting insane.. icon_evil.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Feb 02, 2009 7:39 pm    Post subject:
Reply with quote

Hi,
P.RAJESH wrote:
The loadmodule of DSNTIAUL is there in DB01S.PROD.RUNLIB.LOAD but while exuting the JCL it referring to USERID.DB01S.PROD.RUNLIB.LOAD so i hard coded the DB01S.PROD.RUNLIB.LOAD with single quotes insided the control card.
This does not sound like a solution for the problem asked in the very first post of this thread - please show us the JCL used & tell us what change was done to get it executed successfully.
Back to top
View user's profile Send private message
Cristopher

New User


Joined: 31 Jul 2008
Posts: 53
Location: NY

PostPosted: Fri Feb 06, 2009 12:41 pm    Post subject: Reply to: how to resolve SQL CODE = -818
Reply with quote

RAJESH,

You will get -818 when the DBRM consistency token (i.e. the time stamp) does not match the load module.

This can occur when a compile is partially successful and the load module consistency token doesn’t match the current DBRM. If a recompile doesn’t resolve the problem, it may be necessary to STEPLIB over to the proper load libraries.

So, in your case -818 got resolved when you pointed to the correct loadlib for DSNTIAUL.

Hope this helps.
Cris
Back to top
View user's profile Send private message
P.RAJESH
Currently Banned

New User


Joined: 20 Mar 2008
Posts: 54
Location: chennai

PostPosted: Fri Feb 06, 2009 4:04 pm    Post subject:
Reply with quote

Hi Anuj, First of all I'm sorry for misplacing yourname and late reply.

In our LPAR the loadmodule of DSNTIAUL is there in DB01.PROD.RUNLIB.LOAD, In my execution it is refering to USERID.DB01S.PROD.RUNLIB.LOAD. i saw this message in JESMESSAGES.

Spool is cleared now i can't show the message, I will back again with message by executing th job loacally ( I'm off for the last two days )
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Feb 06, 2009 4:24 pm    Post subject:
Reply with quote

Hi Rajesh,
P.RAJESH wrote:
Hi Anuj, First of all I'm sorry for misplacing yourname and late reply.
Not to worry, that day couple of people used it this way so.. icon_neutral.gif
Quote:
Spool is cleared now i can't show the message, I will back again with message by executing th job loacally ( I'm off for the last two days )
Can you please show the JCL used instead?
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us