Created by: Mike Reilly on 23-03-2010 02:53:18 PM When doing a sql query to "insert" CMC codes, some of the descriptions that are contained in the .csv file have characters which are causing the "insert" query to error out. For example '09. Is there a doc which outlines the special characters that the informix database doesn't recognize? Is there a way to ignore those characters?
Subject: RE: Special Characters in CSV file causing errors in sql query Replied by: David Staudt on 23-03-2010 11:09:59 PM Note that since you're submitting the SQL as part of an XML document, the SQL text itself must still be XML escaped. Once AXL decodes the XML, you still must escape quotes for SQL database. Looks like this page may be helpful: http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.sqls.doc/ids_sqs_1818.htm
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
