topic Re: tMSSqlSP and NB_LINE in Talend Studio

tMSSqlSP and NB_LINE

Anonymous — Sat, 16 Nov 2024 08:18:54 GMT

I am working with the tMSSqlSP component and I have no problems getting and parsing the results. Yet, because of that those results need to be parsed to XML I need a scenario where I can look how many results there were returned and I need to create a 0 results scenario. I am aware of the global variable NB_LINE, but does this exist for the component tMSSqlSP?

Re: tMSSqlSP and NB_LINE

Anonymous — Thu, 03 May 2018 09:49:49 GMT

Hello,

There is no global variable like (Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_UPDATED") available if you use tMSsqlSP to call the stored procedure.

If you want to count the number of rows are deleted, inserted or updated, you have to use tMSsqlOutput to do it.

Best regards

Sabrina

Re: tMSSqlSP and NB_LINE

Anonymous — Thu, 03 May 2018 14:53:54 GMT

Is there any work around to have some information like the NB_LINE and be able to execute the procedure? When I had the Java debugger attached the information is there though...

Re: tMSSqlSP and NB_LINE

Anonymous — Thu, 03 May 2018 15:22:15 GMT

Well, found it. The tParseRecordSet did have NB_LINE. For anyone who wants to count the total rows of the result in the future, use a tParseRecordSet behind a tMSSqlSP.