tSQLScriptParser – Talend Custom Components

• Source Code

• tSQLScriptParser version 1.2 – Direct download
• tSQLScriptParser version 1.6 – Direct download
• tSQLScriptParser version 5.4 – Direct download

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

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.

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

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