Tuesday, 21 January 2025

How the SQL statements are executed by UPDATE TABLE ?

api mode execution


The statements are applied to the incoming records as follows. For each record:

1. The statement referenced by updateSqlFile is tried first. If the statement can be successfully applied to the current record, it is executed; and the statement referenced by insertSqlFile is skipped.
2 .If the updateSqlFile statement cannot be applied to the current record, the component attempts to execute the statement referenced by insertSqlFile.

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

how to create dml dynamically in Ab-initio

 $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...

  • Important air commands - Part 1
     1) air tag diff -  ->air tag diff -show-all tag1 tag2 (-show-all -optional list objects for which there are no differences) 2) air tag c...
  • m_dump
    1) How to print records from a file where cust_id started with 1234 by using the m_dump command ? m_dump dml data -select 'starts_with(c...
  • how to create dml dynamically in Ab-initio
     $[ begin let int i = 0; let string(int) complete_list = "emp_nm,billable,age,designation,location"; let string(int) file_content ...