NATIVEPLATFORMSCALARREQUESTS: SQL Server Native Platform Scalar Requests
insert
- Catalog:
Database - Schema:
Native - Label: Native Platform Scalar Requests
Direct access to native API.
Can retrieve data and change data using insert.
Summary
The NativePlatformScalarRequests table provides direct access to the native protocol over an established connection to the SQL Server platform server. It will contain a new row for every row inserted with a native request in PAYLOAD_TEXT with the results of unaltered forwarding of the payload to the SQL Server platform server.
Table Columns
The columns of the table NATIVEPLATFORMSCALARREQUESTS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
BLOB_ |
char |
BLOB Preferred | Indicator whether a BLOB result is preferred over text. | ||
BOL_ |
int32 |
Response Cache Maximum Age (sec) | Maximum age in seconds of Bridge Online response cache entries to be used. | ||
CONTENT_ |
varchar2 |
Content Type | |||
DATE_ |
datetime |
End Date | |||
DATE_ |
datetime |
Start Date | |||
DRY_ |
char |
Run without Actions | |||
ERROR_ |
varchar2 |
Error Message Code | |||
ERROR_ |
varchar2 |
Error Message Text | |||
HTTP_ |
int32 |
HTTP Disk Cache Maximum Age (sec) | Maximum age in seconds of HTTP disk cache entries to be used. | ||
HTTP_ |
char |
Save HTTP Disk Cache | Whether results can be stored in HTTP disk cache. | ||
HTTP_ |
char |
Use HTTP Disk Cache | Whether results can be fetched from HTTP disk cache. | ||
HTTP_ |
int32 |
HTTP Memory Cache Maximum Age (sec) | Maximum age in seconds of HTTP memory cache entries to be used. | ||
HTTP_ |
char |
Save HTTP Memory Cache | Whether results can be stored in HTTP memory cache. | ||
HTTP_ |
char |
Use HTTP Memory Cache | Whether results can be fetched from HTTP memory cache. | ||
HTTP_ |
varchar2 |
HTTP Method | |||
ORIG_ |
varchar2 |
Original System Group | |||
ORIG_ |
varchar2 |
Original System Reference | |||
PAYLOAD_ |
varchar2 |
Payload | |||
RESULT_ |
blob |
Result BLOB | |||
RESULT_ |
varchar2 |
Result Text | |||
SUCCESSFUL |
char |
Succesful | |||
TIMEOUT_ |
int32 |
Timeout (sec) | Timeout in seconds. | ||
TRANSACTION_ |
int32 |
Transaction ID | Incrementing ID of the transaction. | ||
URL |
varchar2 |
URL |