Skip to Content
avatar image
Former Member

DB2Database Error

Hello all,

I am able to connect DB2Database. I am using following Database Connection Parameters.

jdbcDriver=COM.ibm.db2.jdbc.net.DB2Driver

jdbcUrl=jdbc:db2://hostadres/portno

Here jdbc url where will i define my database name. What is the structure of the message mapping. i am getting following error.

Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMPRECORD' (structure 'statement'): COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.EMPRECORD" is an undefined name. SQLSTATE=42704

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 18, 2007 at 01:48 PM

    This error means thts ur JDBC structure in XI is not properly created.

    Please post ur structure.

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 02:16 PM

    Hi

    Target Data type is not according to JDBC Adapter

    Configuring the Receiver JDBC Adapter

    http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2007 at 02:27 PM

    My Source Structure is

    Sen_msg_type

    EMPNO

    EMPNAME

    ESALARY

    My Target Structure is

    tar_msg_type

    Statement

    Database

    action

    table

    access

    EMPNO

    ENAME

    ESALARY

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Just check whether you have created the data structure same as mentioned in the above link that i gave you.

      Thanks

  • avatar image
    Former Member
    Sep 18, 2007 at 05:16 PM

    Hello all,

    can anybody help on this issue.

    Add comment
    10|10000 characters needed characters exceeded