You are not logged in.
i've got to read a Table in DB2 it has about 732 columns. i want to transfer 1:1 to another (mySql) Database.
but i get the error from "65535 Exceed.." is an JVM limit.
How can i split the Job.....
Is there an Idea ?
The only idea that comes to mind is to make multiple (sub)jobs that load a different set of columns. So the first job transfers the primary key + a set of columns (250?) and two second jobs transfer the other 500 columns using the already transferred primary key.
Hope this helps.
Ok ! i understand, but i'm not able to create the table in the mysql Database because of the ERROR "exceeding 65535...".
When i first create a table with the first 250 rows i have a mysql table with only 250 rows. When is start the second job with row 251 till row 500 i dont know if i'm able to tell to add the columns to the mysql table...
So your destination table doesn't exist yet... well, that makes it a little more complicated...
I think you might want to create the table first, but I'm not sure this is an option for you of course.