Hi
Is there any way to update a String in Lower case in DB2 ,By default it is taking all in CAP's Please do the needfull bit Urgent
Thank you all.
To update a Comment in Lower case in DB2
Moderators: Kalicharan, Moderator Group
harimca,
I am not 100% clear regarding ur requiremt as how ur updating,
when u say update a String u mean r u passing some value into
the string and then moving that into another host variable and then
updating that varaible.
Anyways just as info :
If we can pass a value into a varaible that can be done using
LOWERCASE/UPPERCASE and then may be you can move that varaible
into host varaible and UPDATE.
We can pass a LOWERCASE value into a string by setting our profile :
if u type PROFILE on the COMMAND line you will get info reg ur
profile setting, in which CAPS is one keyword.
So u can type CAPS ON on COMMAND line when u want the text in CAPS,
and CAPS off when u do not want CAPS.
Then assaign ur value to a varaible and then do the DB2 operation.
PLEASE LET US KNOW YOUR REQUIREMENT/QUERY IN DETAIL IF THIS
DOES NOT NOT WORK OR NOT APPLICABLE FOR UR INSTANCE.
Thanks,
Veera.
I am not 100% clear regarding ur requiremt as how ur updating,
when u say update a String u mean r u passing some value into
the string and then moving that into another host variable and then
updating that varaible.
Anyways just as info :
If we can pass a value into a varaible that can be done using
LOWERCASE/UPPERCASE and then may be you can move that varaible
into host varaible and UPDATE.
We can pass a LOWERCASE value into a string by setting our profile :
if u type PROFILE on the COMMAND line you will get info reg ur
profile setting, in which CAPS is one keyword.
So u can type CAPS ON on COMMAND line when u want the text in CAPS,
and CAPS off when u do not want CAPS.
Then assaign ur value to a varaible and then do the DB2 operation.
PLEASE LET US KNOW YOUR REQUIREMENT/QUERY IN DETAIL IF THIS
DOES NOT NOT WORK OR NOT APPLICABLE FOR UR INSTANCE.
Thanks,
Veera.
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