insert sql query from stored procedure create new uniqueidentifer

Anonymous — Sat, 16 Nov 2024 03:47:13 GMT

Hi Everyone,

I have a stored procedure that inserts data either through rest or file..(not the most important part)

My question is how to add the sql """""---> newid() """ with the other inputs?

I have tried java uuid, but there might not be a guarantee that this uuid is not in the database....

putting the whole query in either dbrow, dbinput or dbout, and connecting to a tlogrow, show a row will all the values as null !!!

can someone help?

thnx

topic insert sql query from stored procedure create new uniqueidentifer in Talend Data Catalog