topic Re: Using tMSSQLRow, SQL statements with varibles in Talend Studio

Using tMSSQLRow, SQL statements with varibles

Anonymous — Thu, 26 Jan 2017 10:39:57 GMT

1st Question, is tMSSqlRow the best way to use SQL Statements with varibles? I've googled around for a few tutorials and they all use tMSSqlRow.

2nd Question, How do I print the output of tMSSqlRow? I usually use tMSSqlInput -> tLogRow
When I use tMSSqlRow -> tLogRow I just get 1 row of 0||||
I tried using tParseRecordSet but I get an error, Cannot cast from Long to Result set.
I don't quite understand "Prev.Comp.Column List"

A bit lost on the logging apsect.

Re: Using tMSSQLRow, SQL statements with varibles

Anonymous — Thu, 26 Jan 2017 21:33:03 GMT

This component does not provide the selected records itself. You have to map the resultset in the advanced settings to a schema column of Object type and use this column in the component tParseRecordSet. This components opens the resultset and starts a flow with the actual result data. The mapping it is schema columns to the columns of the result set fields have to be done with the names of the result set columns. It is be far to tricky to process queries this way.

Re: Using tMSSQLRow, SQL statements with varibles

Anonymous — Tue, 31 Jan 2017 04:18:06 GMT

It is be far to tricky to process queries this way.

So what is the best way then?

Re: Using tMSSQLRow, SQL statements with varibles

vapukov — Tue, 31 Jan 2017 21:03:49 GMT

You can use variables everywhere - tMMSSQLRow, tMSSQLInput, tMap and etc - proper component depends from Your tasks

2nd - are You Sync columns in tLogRow component?
Use tLogRow (or any other prints) for print output flow in Studio - is bad idea for big data-sets, use it carefully for debug purpose only and disable (delete) from live). It could freeze Studio (in worst case crash it). If You have more than few output rows - redirect them in file (tFileOutputDelimited for example)