MVSFORUMS.com

[suggala_r]

Hi,
We use Varchar Bit type data for storing Unicode descriptions(multi lingual). So far we are able to manage everything(inserts,updates etc) through Cobol stored proc via ASP/java front end.We are successful in using this datatype for storing multilingual data(French,Hindi,Spanish,Italian etc).


Now need arised to compare Char Type descritons to this Varchar Bit Desc with in Cobol/DB2 . Since the storage is different in both data types for English Language (Ex. a Word "MVSFORUM" in English gets stored
differently - as long as Table values concerned) . If we compare the word in Both datatypes , the result is different.

Is there any way to compare the values in these datatypes.Like functions etc (ex like Date variable can be converted to Char by
Char(date_column)).

or any ideas in this regard are helpful in completion of my project


Note : reason for this is Our application has to sync the Domain data/Desc related to English language with other application which is a DB2 app.

Thank you in advance...
_________________
Raghu

[suggala_r]

Added information to my question is Our DB2 version is 7.
_________________
Raghu

[kolusu]

Raghu,

How did you store the data in the varchar column? If you used to cobol-db2 subroutine then you must have defined the variable to store in the table.

For ex: we have a varchar column of length 3000 bytes. we use that to store 3 varibles in an array of 250 times with each occurance for a length of 12 bytes

[suggala_r]

Hi Kolusu,
I did not understand your reply. May be description of my question is not proper.

We used Cobol-Db2 stored procedures for inserting the descriptions to the tables. But all along only through store proc and Web. Not thru
SPUFI etc. Because of data definition of column(Varchar by Bit type).

My question is is it possible to compare a value in Varchar by Bit to
value in Varchar(simple).

Hope this helps.
_________________
Raghu

[vak255]

Hi Raghu,
can u tell me whts ure application really want to do.