AnsweredAssumed Answered

DB2 Query Problem

Question asked by kamal1234 on May 24, 2016
Latest reply on May 25, 2016 by kamal1234

Dear Community members,

 

I am using ExecuteSQL to execute following query. It has all the correct syntax of normal insert query why still it not converting my french char to DB2 EBCDIC string. I am connecting to DB2 using obdc.

 

"INSERT INTO CPD_Documents (DocID, ISBN_ISSNNumber, OrderNo, PubOptionNo, PubStatusID, ProductNumber, Title,  Subtitle, PublisherID, BindingID, TitleAuthor,IndexTitle,NumberOfSupplements ) VALUES " &

"('"&Products::zkDocID&"'," &

"'"&Products::ISBN_ISSNNumber&"'," &

"'"&Products::OrderNo&"'," &

"'"&Products::PubOptionNo&"'," &

"'"&Products::PubStatusID&"'," &

"'"&Products::ProductNumber&"'," &

"EBCDIC_STR('"&Products::Title&"')," &

"'"&Products::SubTitle&"'," &

"'"&Products::PublisherID&"'," &

"'"&Products::zkBindingID&"'," &

"EBCDIC_STR('"&Products::TitleAuthor&"')," &

"EBCDIC_STR('"&Products::IndexTitle&"')," &

"'"&Products::NumberOfSupplements&"')"

 

 

creates

 

INSERT INTO CPD_Documents (DocID, ISBN_ISSNNumber, OrderNo, PubOptionNo, PubStatusID, ProductNumber, Title,  Subtitle, PublisherID, BindingID, TitleAuthor,IndexTitle,NumberOfSupplements ) VALUES ('26','0706-5388','A02200','2200','1','A02200-76',EBCDIC_STR('Tim's Practice Cases, 7th Series/Recueil de droit judiciaire de Tim, 7e série'),'','84','2',EBCDIC_STR('Tim's Practice Cases, 4th Series Recueil de droit judiciaire de Tim's, 4e serie'),EBCDIC_STR('Tim's Practice Cases, 7th Series/Recueil de droit judiciaire de Tims, 7e série'),'0')

 

Please can someone tell me what wrong I am doing here. Can we execute server side functions from ExecuteSQL statement.

Thank you

Kamal

Outcomes