What does the VTXCMD() multirow option do?
Multirow applies to Sybase and SQL Server. These have a bulk interface called bcp which greatly improves bulk insert performance but the DBMS must be enabled to do so. Some sites do not enable their DBMS so the bcp calls fail. Setting multirow = no, the default, means we use the bulk interface (bcp) to do bulk inserts. Multirow = yes means we do individual inserts. There is still some performance enhancement in this case because the data will be sent across in batches.