topic Re: Result of tOracleInput in Talend Studio

Result of tOracleInput

Anonymous — Mon, 30 Apr 2018 10:28:13 GMT

hi, i need to store the result returned by an sql query into a variable. Based on the value of the Variable further flow will be decided. How to do so?

Current job flow is:

TBufferInput >>> tFlowToIterate >>> tOracleInput >>> tJava

Query in tOracleInput = Select count(*) from EMP where EMP.id = somenumber

i want to get the result , and if result > 1 do something else something else.

Thanks in advance.

Re: Result of tOracleInput

manodwhb — Mon, 30 Apr 2018 11:05:39 GMT

@tanvi_patil,you can store the result into global variable using tSetGlobalvar and using get (String)globalMap.get() method you can get.

Re: Result of tOracleInput

Anonymous — Mon, 30 Apr 2018 11:19:16 GMT

how ? can u show me the flow of how to store. On which flow can i get the output.

tOracleInput >>>> tSetGlobalVarible ?

Re: Result of tOracleInput

manodwhb — Mon, 30 Apr 2018 11:25:29 GMT

@tanvi_patil,please find below.since from tOracleInput you should get only one column.that is count.

Re: Result of tOracleInput

Anonymous — Mon, 30 Apr 2018 12:02:37 GMT

@manodwhb can u show me the schema and settings of tOracleInput , i don't get the varibale count. I get error saying count cannot bge resolved to a field.

my query: "Select count(*) from TEST where TEST.ID="+ ((String)globalMap.get("myKey"))

I have 3 columns in my schemna id, col1, col2

Re: Result of tOracleInput

manodwhb — Mon, 30 Apr 2018 12:05:55 GMT

@tanvi_patil,when you used below query in tOracleinput shema you should get only one coumn.

"Select count(*) as count from TEST where TEST.ID="+ ((String)globalMap.get("myKey"))

Re: Result of tOracleInput

Anonymous — Mon, 30 Apr 2018 12:21:49 GMT

hi, @manodwhb , when i access the variable by get and display, it gives null

Re: Result of tOracleInput

manodwhb — Mon, 30 Apr 2018 12:24:14 GMT

@tanvi_patil,can you show me where you were dispaying variable in job?

Re: Result of tOracleInput

Anonymous — Mon, 30 Apr 2018 12:29:59 GMT

@manodwhb in tjava for debugging purposes.

I actually need the value of variable for making decision ,, i.e if >0 something etc

System.out.println("count variable"+ ((String)globalMap.get("count")) );

Re: Result of tOracleInput

manodwhb — Mon, 30 Apr 2018 12:30:32 GMT

@tanvi_patil,please the check the follwing,i have used in tJava to dispaly the variable.

Re: Result of tOracleInput

manodwhb — Mon, 30 Apr 2018 12:40:38 GMT

@tanvi_patil,since you can do in tMap.

Re: Result of tOracleInput

Anonymous — Mon, 30 Apr 2018 13:08:15 GMT

thank you so much @manodwhb