Hi Team,
We are using Appeon Powerbuilder CloudPro Edition.
We are updating the SQL UPDATE query based on a condition in DW SQLPreview event. The UPDATE query submitted to DBMS is fetched from SQLSyntax of SQLPreview event and is then modified and set as the Syntax to DW.
Example code:
IF col_1.value <> 'EXAMPLE' THEN
ls_update_sql = sqlsyntax
ll_pos_start = POS(ls_update_sql, "col_1.Name")
IF ll_pos_start > 0 THEN
ll_pos_end =ll_pos_start + LEN("col_1.Name = ") + LEN(STRING(col_1.value))
ls_update_sql = LEFT(ls_update_sql, ll_pos_start - 1) + "col_1.Name = " + String('EXAMPLE') + RIGHT(ls_update_sql, LEN(ls_update_sql) - ll_pos_end + 1)
END IF
THIS.SetSQlPreview(ls_update_sql)
END IF
Since, SQLPreview(SQLSyntax) is not supported, please let us know the way to get the UPDATE statement submitted to DBMS.
