Could any one tell me how to do a multi row insert in to a table.
The below should be an eg to insert data in to the table.
INSERT INTO test-table
FOR 50 ROWS
Can I remove the imsert value 50 with a variable. So that if the input file is having only 25 records then the variable would get 25 as value. So tat we will be looking forward to insert only 25 records.
More over which one is best to use? ATOMIC or NOT ATOMIC CONTINUE ON SQLEXCEPTION
If am using the second one where do I give the GET DIAGNOSTICS statement?? Is this statement to be given immediately after the insert tabe statement?.
Since this is a new feature. Can any body guide me? So tat i could code it effectively.