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
 

 

Diff between -805 and -818

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mfhelp
Warnings : 1

New User


Joined: 29 Jun 2006
Posts: 33

PostPosted: Tue Apr 01, 2008 3:26 pm    Post subject: Diff between -805 and -818
Reply with quote

What is the difference between -805 and -818 SQL code........can we really face -818 in real projects??
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Tue Apr 01, 2008 4:04 pm    Post subject:
Reply with quote

What does your manual say?
Back to top
View user's profile Send private message
UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 755
Location: Germany

PostPosted: Tue Apr 01, 2008 4:19 pm    Post subject:
Reply with quote

Hi !

First: nothing found in Plan.
Second: Found in Plan but TS is different.

And as gnanas said: RTMF

Regards, UmeySan
Back to top
View user's profile Send private message
zero

New User


Joined: 01 Dec 2007
Posts: 21
Location: Hyderabad

PostPosted: Tue Apr 01, 2008 5:47 pm    Post subject: Reply to: Diff between -805 and -818
Reply with quote

The descriptions for -805 and -818 are :

SQLCODE -805 : DBRM OR PACKAGE NAME NOT FOUND IN PLAN

SQLCODE -818 : THE PRECOMPILER-GENERATED TIMESTAMP IN THE LOAD MODULE IS DIFFERENT FROM THE BIND TIMESTAMP BUILT FROM THE DBRM.

As you know, all the SQL statements that are written in a program will be moved to DBRM (Data Base Request Module) and will be binded and then stored in a Package/Plan.

if a DB2 Program is not compiled properly, and if we try to run it -805 will be generated.

now, coming to SQLCODE : -818. As you know, when a DB2 Program is compiled, two entities will be created at the end of compilation.

1. Load module which contains just the source language statements.

2. Plan/Package that contains all the SQL statements in executable
format that are coded in the program. (When a DBRM is binded, the
executable form Of the SQL statements will be created and stored in
Plan/Package.

To make sure that the program calls the correct SQL statements, we
use an identifier in both the Load module and Plan/Package. Generally,
a timestamp is used for this purpose. this is the default.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare PD Values with same storage &... Shrinika Rajendran JCL & VSAM 5 Wed Nov 05, 2014 3:17 pm
No new posts merge records from 2 ps files with di... kishpra DFSORT/ICETOOL 6 Wed Mar 19, 2014 1:00 pm
No new posts Need help on SORT to write each input... rahul sijoriya JCL & VSAM 4 Mon Dec 02, 2013 9:09 pm
No new posts DB2 delete row from one table with a ... Shereen Samuel DB2 1 Thu Apr 11, 2013 12:08 pm
This topic is locked: you cannot edit posts or make replies. What is exact diff and adv btw Comp p... MOHAN KUMAR DURAIRAJAN COBOL Programming 1 Thu Mar 14, 2013 4:39 pm


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