Scripting Jitterbit Variables¶
Introduction¶
This page covers Jitterbit variables that are available for scripting. Each of these variables is available to set (write):
jitterbit.scripting.db.auto_commit
jitterbit.scripting.db.max_rows
jitterbit.scripting.db.rows_affected
jitterbit.scripting.db.transaction
jitterbit.scripting.ldap.include_dn_in_results
jitterbit.scripting.ldap.max_search_results
jitterbit.scripting.ldap.return_null_if_no_results
jitterbit.scripting.ldap.scope
jitterbit.scripting.ldap.use_paged_search
jitterbit.scripting.nesting.max
jitterbit.scripting.while.max_iterations
Settings¶
jitterbit.scripting.db.auto_commit
¶
Variable | jitterbit.scripting.db.auto_commit |
---|---|
Data Type | Boolean |
Default | true |
Description | Set to false to run DbExecute and DbLookup statements in a transaction. Auto-commit is turned on by default. |
jitterbit.scripting.db.max_rows
¶
Variable | jitterbit.scripting.db.max_rows |
---|---|
Data Type | Integer |
Default | 10000 |
Description | Maximum number of rows to fetch in a call to DbExecute . |
jitterbit.scripting.db.rows_affected
¶
Variable | jitterbit.scripting.db.rows_affected |
---|---|
Data Type | Integer |
Description | The number of rows affected by a call to DbExecute or DbLookup . |
jitterbit.scripting.db.transaction
¶
Variable | jitterbit.scripting.db.transaction |
---|---|
Data Type | Boolean |
Default | false |
Description | Set to true if you want DbExecute /DbLookup calls to run in a transaction. |
jitterbit.scripting.ldap.include_dn_in_results
¶
Variable | jitterbit.scripting.ldap.include_dn_in_results |
---|---|
Data Type | Boolean |
Description | When set, XML-formatted Note This variable is set and used independently of the LDAP connector. |
jitterbit.scripting.ldap.max_search_results
¶
Variable | jitterbit.scripting.ldap.max_search_results |
---|---|
Data Type | Integer |
Description | The maximum number of entries Note This variable is set and used independently of the LDAP connector. |
jitterbit.scripting.ldap.return_null_if_no_results
¶
Variable | jitterbit.scripting.ldap.return_null_if_no_results |
---|---|
Data Type | Boolean |
Default | false |
Description | If an LDAP query returns no results, a NULL data element is returned. The default is to return an empty array data element. This is for backward-compatibility only. Note This variable is set and used independently of the LDAP connector. |
jitterbit.scripting.ldap.scope
¶
Variable |
|
---|---|
Data Type | Integer |
Description | The scope
Note This variable is set and used independently of the LDAP connector. |
jitterbit.scripting.ldap.use_paged_search
¶
Variable | jitterbit.scripting.ldap.use_paged_search |
---|---|
Data Type | Integer |
Description | Use paged search when searching LDAP directories. This option is useful for retrieving large result sets. This variable is supported only on Windows-based Private Agents and is not supported on Linux-based Private Agents or the Cloud Agent Groups. To work around this limitation, we suggest one of these alternatives:
Note This variable is set and used independently of the LDAP connector. |
jitterbit.scripting.nesting.max
¶
Variable |
|
---|---|
Data Type | Integer |
Default | 10 |
Description | Maximum nesting level for RunScript /RunOperation calls. If the nesting level is exceeded, the operation will fail. If your application needs deeper nesting, increase this number. |
jitterbit.scripting.while.max_iterations
¶
Variable |
|
---|---|
Data Type | Integer |
Default | 50000 |
Description | The maximum number of times that the body of a while loop will execute. Setting this number to less than 1 reverts to the default of 50,000 iterations. Note This setting applies to Jitterbit Script only. For JavaScript, see Loop Iterations under JavaScript. |