Hi,
Please tell me if anyone knows the difference between SQLCODE of
-805 and -818.
Has anybody encountered -818 sqlcode.
If we bind a CICS DB2 program, and donot do CEMT S PROG(pgmname)
NEW i.e. do not perform newcopy in CICS, we get -818 . This is what i''ve read , but in practical situation in test environment,
i am not getting -818. I am always getting -805.
Even if the DRBM and COBLOAD exist but the version is different, i encounter -805 only
Thanks in anticipation
difference between -805 and -818 sqlcode
Moderators: Kalicharan, Moderator Group
SQL CODE -805 -818
You will get SQLCODE -805, when DBRM or PACKAGE not found in PLAN.
You will get SQLCODE -818, when DBRM or PACKAGE exists in a PLAN , But there
is a timestamp mismatch between load module and DBRM or PACKAGE
You will get SQLCODE -818, when DBRM or PACKAGE exists in a PLAN , But there
is a timestamp mismatch between load module and DBRM or PACKAGE
Natarajan
Chennai
Chennai
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page