PhenixID

Write to SQL by Prepared Statement

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