Skip to Content
avatar image
Former Member

structure of jdbc

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 20, 2010 at 02:41 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2010 at 02:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded