To update a Comment in Lower case in DB2

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
harimca
Member
Posts: 4
Joined: Fri Mar 23, 2007 2:01 am

To update a Comment in Lower case in DB2

Post by harimca » Tue Mar 27, 2007 7:22 pm

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.

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Tue Mar 27, 2007 10:17 pm

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.

Post Reply

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



Other References
Mainframe Tools and others