Skip to Content
avatar image
Former Member

JDBC Receiver Table has columns with special charecters

Hi, I am working on IDOC to JDBC insert scenario where DB2 table has multiple column names with special charecters e.g. PONO#, B8PL#, Y8LOC#. As it is in the receiver side, I can't define the structure with any other name and overwrite in the query. Can anyone suggest how to deal it?

Thanks

Vinay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 22, 2017 at 08:04 PM

    Hi Vinay!

    XML Naming Rules

    XML elements must follow these naming rules:

    • Element names are case-sensitive
    • Element names must start with a letter or underscore
    • Element names cannot start with the letters xml (or XML, or Xml, etc)
    • Element names can contain letters, digits, hyphens, underscores, and periods
    • Element names cannot contain spaces

    I guess you can't use "#" and "$" symbols in XML element's name.

    In such case I see two ways: to use SQL_DML JDBC message format or to request DB team on target side to make stored procedure for data insert/update.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2017 at 05:21 PM

    Hi Vinay,

    Give a unique name for this character in your data type say # = _hash and include a java/xslt map later to replace the _hash back to #.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2017 at 07:20 PM

    Hi Vinay!

    What is the number of fields and rows you want to insert from one source message?

    In case you need to insert one row with few fields you could simply use SQL_DML message format where you compose SQL insert query text and that query is performed in target database.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded