APPENDBUFFER

Top  Previous  Next

 

DRIVER('SQLDriver', '/APPENDBUFFER = size ' )

[ Buffer" = ] SEND(file, 'APPENDBUFFER [ = size ]' )

By default, APPEND adds records to the file one at a time. To get better performance over a network you can tell the driver to build up a buffer of records then send all of them to the SQL back end at once. Size is the number of records you want to allocate for the buffer. SEND returns the number of records that will fit in the buffer.