tSQLScriptParser – Talend Custom Components

tSQLScriptParser
Name: tSQLScriptParser
Icon: tSQLScriptParser
Author: Jan Lolling
Resources:
Download:
Install Instructions:
Example: Coming soon…
Features:

* Recognizes complex statements in PL/SQL scripts
* Handles comments

Overview:

This component can iterate through SQL statements in a script read from the SQL input in the component or from a file.
It detects the OraclePlus delimiter / to separate complex statements like begin-end or create or replace procedure etc.

The current statement can be retrieved with the return value (see the Outline view) e.g. ((String)globalMap.get(“tSQLScriptParser_1_STATEMENT_SQL”)).
A common use case is to trigger a tMysqlRow with the Iterate flow and use in the Row component as query ((String)globalMap.get(“tSQLScriptParser_1_STATEMENT_SQL”)).
Take care you do not put this expression NOT in quotas unlike you would do for SQL code.

tSQLScriptParser v_1.6__1
tSQLScriptParser v_1.6__2
Release Notes:

Release version: 1.6 – NULL
* Bug fixed: Comments irritating the parser while detecting plsql

Compatible:
  • 6.1 (obsolete)
  • 6.2 (obsolete)
  • 6.3 (obsolete)
  • 6.4 (obsolete)
  • 6.5 (retired)
  • 7.0 (retired)
  • 7.1 (retired)
  • 7.2

Document get from Talend Exchange
Thank you for watching.

Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x