Specifies the number of rows to be inserted in a calculation export batch to an SQL file. You can specify DEXPSQLROWSIZE for individual databases, all databases within an application, or for all applications and databases on the server.
DEXPSQLROWSIZE [appname [dbname] ] n
| appname | Optional. Application name. If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application. If you do not specify an application, you cannot specify a database and the setting applies to all applications and databases on Essbase Server. |
| dbname | Optional. Database name. If you do not specify a value for dbname, the setting applies to all databases within the specified application. If appname is not specified, you cannot specify dbname. |
| n | The number of rows in the batch. Maximum: 1000 rows. |
When using the calculation script command DATAEXPORT to export data directly to a relational database, to minimize I/O overhead, Essbase can group output rows in batches. Use the DEXPSQLROWSIZE configuration setting to specify the number of rows in a batch. If DEXPSQLROWSIZE is not specified, Essbase determines the batch size.
DEXPSQLROWSIZE Sample Basic 300
Specifies a 300-record batch size for data exported from Sample BAsic to a relational database using DATAEXPORT.
DEXPSQLROWSIZE Sample 500
Specifies a 500-record batch size for data exported from any database within the Sample application to a relational database using DATAEXPORT.