VARCHAR
Moderator: Moderator Group
-
- Member
- Posts: 40
- Joined: Tue Sep 18, 2007 1:17 pm
VARCHAR
Why VARCHAR should be declare at level no. 49?
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
May be this link can help: http://publib.boulder.ibm.com/infocente ... 006146.htm
Search for VARCHAR on right side.
Search for VARCHAR on right side.
Regards,
Anuj
Anuj
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
same reason structures start as a 01 level andWhy VARCHAR should be declare at level no. 49?
condition codes are 88
just syntax -rules of coding.
db2 expects the host elementary items defining the length and data portion of a varchar column to be coded at level 49.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
mf.vannan,
if you are going to go to the trouble of using a larger font and a color
to emphasize the superior content of your post,
at least make it accurate.
First of all, the word record has nothing to do with DB2.
it is a variable length column.
to properly phrase your answer, one should say,
the Level 49 stucture contains two fields.
one to contain the data, and one to contain the length of the data.
if you are going to go to the trouble of using a larger font and a color
to emphasize the superior content of your post,
at least make it accurate.
First of all, the word record has nothing to do with DB2.
it is a variable length column.
to properly phrase your answer, one should say,
the Level 49 stucture contains two fields.
one to contain the data, and one to contain the length of the data.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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