Version: 1.1
Category: Output
Extended Category: SQL
Action Package: Standard Actions
Description
Write attribute values to SQL using prepared statement.
|
Parameter |
Description |
Example |
|
Force User Data Source |
[Optional] Always write to this data source. Make sure it is an SQL data source. |
MS SQL |
|
Prepared Statement |
[Mandatory] The prepared statement. Ex. UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ? |
UPDATE EMPLOYEES SET SALARY = ?WHERE ID = ? |
|
Parameters |
[Mandatory] The parameters to be used in the prepared statement. Syntax for each parameter: SessionAttributeName|ParameterFormat. Syntax for Date and Timestamp parameters: SessionAttributeName|ParameterFormat|DateFormat. Multiple parameters are separated by comma, or separator entered below. Available parameter formats: STRING, DOUBLE, BYTEARRAY, FILE, DATE, TIMESTAMP.STRING – A text value DOUBLE – A numeric value BYTEARRAY – A binary value FILE – The file name, including path, of a file to insert in database DATE – A date value. Must include the parameter option DateFormat. TIMESTAMP – A timestamp value. Must include the parameter option DateFormat.DateFormat specifies the date and time pattern. Ex. yyyy-MM-dd. Date and Time Patterns may be found at: http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html |
samaccountname|STRING |
|
Separator |
[Optional] The separator used between parameter pairs. Default: , (comma). |
; |
Use Cases
Example 1: Save new data to table ADM_PERSON
This action will update entry 10 in the SQL table “RM_TEST” with string from the File attribute to the Name column and the binary value from fileContents to the Photo column.
|
Parameter |
Value |
|
Force User Data Source |
[BLANK] |
|
Prepared Statement |
INSERT INTO RM_Test (Id, Name, Photo) VALUES (10, ?, ?) |
|
Parameters |
File|STRING,fileContents|BYTEARRAY |
|
Separator |
[BLANK] |
DISCLAIMER
Information provided in this document is for your information only. PhenixID makes no explicit or implied claims to the validity of this information. Any trademarks referenced in this document are the property of their respective owners.The origin of this information may be internal or external to PhenixID. PhenixID makes all reasonable efforts to verify this information.
PhenixID - support.phenixid.se