structure of jdbc

[Former Member]

Hello,

I need to insert from a file to a JDBC table. The database table has lots of values ,but i need to insert just a few of them. While i create a structure of the table in the data types, do i need to create the whole database table structure or only the structure of values to be inserted?

Thanks

[stefan_grube · Accepted solution]

It depends, what you want to fill in the other values.

If you want to fill NULL, then you need not provide the fields in structure.

If you want to provide initial values like 0 for integers, you have to add the fields to structure.

[Former Member · Accepted solution]

The other values ,will be provided in table directly by the DB team and not from SAP / PI .

[rodrigoalejandro_pertierr · Accepted solution]

hi,

so, no matter. you can send the some values to DB from SAP PI

[stefan_grube · Accepted solution]

> The other values ,will be provided in table directly by the DB team and not from SAP / PI .

I think your question is answered.

[rodrigoalejandro_pertierr]

just insert the values you need, but make sure that you define de key values in the structure. consider taht the structure you define in PI later is translated into a SQL statement. so no problem to insert, update some values of a table and not the wholes fields