Hi, I have Oracle SP that return a sql path and I stored it in a context variable. Now I need to execute this sql script in talend (like we execute it in sql plus --> @ sqlscript.sql ) Is there any similar component in talend to do this task. (I tried it in tOracleRow but it execute only Select & DML queries) I am also thinking to implement it in tJava/tJavaRow component (by writing java code) ...is this a correct way ? Kindly assist. Regards, Rakesh D
Hi Shong,
I have downloaded the TSQLScriptParser (its a zip file) but not able to understand where I need to keep this file/folder.
Can you please help ?
I have extracted this file and it consist of 2 folder tSQLScriptParser and __MACOSX and they have few files (.xml/javalet/jar) but not sure where I have to place these files.
Regards,
Rakesh D
Shong,
Do I need to place extracted folder under this path:
C:\Program Files (x86)\Talend-Studio\studio\plugins\org.talend.designer.components.sparkstrprovider_6.2.1.20160704_1411\components
As I can see other components' folders are there.
Please confirm.
Regards,
Rakesh D
Hi Shong,
I was able to load the tSQLScriptParser component by installing it properly but its not able to execute the sql script (I am getting "File Not found") even I have given the proper file name in the File *.sql.
Then I read some other post related to this and they said that we can use tFileInputFullRow--> tOracleRow to execute sql script.
I have given the complete file path in the tFileInputFullRow and then I used ((String)globalMap.get("sql")) in the Query section of tOracleRow component but getting error:
SQL statement to execute cannot be empty or null
Am I doing any mistake?
Hi , Even I use tSystem to execute sqlscript by (I am passing my sql script complete path in the context variable) "cmd /c echo HELLO & sqlplus dbuser/*****@DBNAME & @" +context.Script_File_path+" " it is executing without any error but it did not create file (this script create spool file by executing select statement)
Hello
tSQLScriptParser is a custom component, to be honest, I have not used it. Please refer to this KB
article about how to install a custom component, make sure you have installed into studio correctly.
Then I read some other post related to this and they said that we can use tFileInputFullRow--> tOracleRow to execute sql script