want to do a block insert..
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   venkat_rao
Posted On:   Wednesday, September 19, 2001 06:04 AM

I want to insert a block of records in to DB2/400 table using java. to accomplish this I need to create a structure array in java.
This I can do by declaring a mutiple occurance data structure in RPG.
Is it possible to create same kind of strucure array in java to do a block insert?

Re: want to do a block insert..

Posted By:   Anonymous  
Posted On:   Wednesday, September 19, 2001 01:15 PM

Using Record Level Access, you can set a block size when opening the File and write an arrary of Records. This, of course, depends on how the file is opened. Using standard SQL, prepared statements with Batch Update generally provides the best performance. Other methods are possible as well.
About | Sitemap | Contact