How to handle CREATE or INSERT in JDBC

[Former Member]

Hi experts,

i'm designing my idoc to JDBC scenario, but is it possible when the message arrives into the database to CREATE a table if it does not exist or to INSERT data if the table already exists?

Thanks in advance,

Regards.

Jamal

[Former Member · Accepted solution]

Hi

INSERT, UPDATE, UPDATE_INSERT, DELETE,

r possible

rgd

srini

[Former Member]

Thank you very much. I thought the action CREATE was possible, but it is not.

Regards,

Jamal

[Former Member]

Hi,

check some links on JDBC.

- File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

Phani

[Former Member]

Hi,

the table should already be created in database.

u can surely insert the records.

plz refer,

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

thanks,

latika

[prateek]

U can try executing a Stored Procedure from XI to create the table as per ur requirement.

To insert, its a simple process using jdbc receiver adapter, wherein the action in datatype is "INSERT".

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards,

Prateek