Writeb
Writeb has the same syntax as Write, but allows you to optimize the performances when several insertions of database lines must be done.
WritebWriteb [CLASS]CLASS is a class identifier that corresponds to the abbreviation used to open a database table.# This script called by Gosub creates several lines in a table# The creation is done by group of 10 lines# If an error occures, an attempt is done again with no buffering# If fstat is not null, it gives the lines where the error happens$WR_MANY_LINESTrbegin MYTABLE [MYT]adxwrb=10 : # Reasonable valueGosub WR_LINESIf fstatRollbackadxwrb=1Trbegin MYTABLE [MYT]Gosub WR_LINESEndifIf fstatRollbackElseCommitEndifReturn$WR_LINESFor I=1 to NB_LINESGosub ASSIGN_MYTWriteb [MYT]Break (fstat<>0)Next IIf fstat=0If adxwrb>1 : Flush [MYT] : EndifIf fstat=0CommitElseRollbackEndifElseRollbackEndifReturnWriteb allows you to buffer the lines written in a database table before sending them globally. This instruction should be used when massive inserts are done in a given table.
Writeb works exactly as Write.Writeb stores the lines to be written in a buffer, and flushes the buffer by transmitting the data to the database when reaching the buffer size, or when using the Flush instruction.Writeb behaves exactly as Write (no buffering is done).Writeb updates fstat to indicate the result of the write operation only when transmitting the data to the database. It is therefore not possible to identify the line in which the error occurred. The best practice is to run the transaction again with [S]adxwrb set to 1. The fstat value will then be returned after every Writeb.
The values available for status are the following:
| fstat value | Description |
|---|---|
| 0 | The write operation has been successful (or has only been placed for the moment in the write buffer). |
| 1 | Lock error on at least a database line. |
| 3 | An attempt to create a duplicate key has been detected. |
The Flush instruction triggers the database write operation for all the lines sent in the buffer and not yet written. Using Flush before the execution of Commit is mandatory. If this is not done, the execution of Commit fails if lines are still in the write buffer. Using Flush also ensures that the lines can be created successfully.
The Rollback and Commit instruction take into account all the lines written by Write as well as by Writeb.
The modification of the adxwrb variable creates an error if lines are still present in the write buffer. It is therefore important to Rollback or to Flush before modifying this value.
The Writeb instruction uses a buffer with a greater size than the usual write buffers. It is important to consider a reasonable value for adxwrb to avoid an error "no more memory left" (31), or to increase the sadmem memory sizing parameter. This parameter defines the memory used by the sadodbc and sadora processes. By default, its value is set to 20480.
# Incorrect use of Writeb and Update# When the Update is done, the record "ABC" has not been createdadxwrb=10 : [F:MYT]MYKEY= "ABC" : [F:MYT]DESCRIPTION="My description": Writeb [MYT] Update [F:MYT]MYKEY="ABC" With DESCRIPTION="Change the description"adxwrb, Flush, For, Write, adxftl, fstat.