Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have one column say 'X' defined as VARCHAR
Can anyone tell me What are the different ways to update
this column thru COBOL-DB2 program?

Answer Posted / priyanka

If a variable is defined as varchar, the filed will have a
length variable also. Before updating the value 'X', you
need to move the length of the new value to length filed
of 'X'.
Eg: If you want to update 'TEST' in 'X'.

MOVE LENGTH OF 'TEST' TO X-LENGTH
exec sql
UPDATE table
SET X = 'TEST'
Where clause
end-exec

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What guidelines should be followed to write a structured cobol prgm?

1135


What the difference is between continue and next sentence?

1140


What is the difference between goback, stop run and exit program in cobol?

1572


How to get the last record in vsam file in cluster? And how can you get the ksds file records into cobol program?

1138


How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?

1177


What is rmode(any) ?

1238


What is link edit in cobol?

1177


What are various search techniques in cobol? Explain.

1053


what is amode(24), amode(31), rmode(24) and rmode(any)?

1130


What is the difference between structured cobol programming and object alternativelyiented cobol?

1231


If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly

3135


Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning

1075


Which is not true about evaluate statement

2431


How to remove the spaces at the end of each record in the output file of variable length, via cobol program?

1151


Explain how you can characterize tables in cobol?

1045