StoreSQLQuery and tLogRow . Cannot see query due to volume of data.

deailes — Sat, 16 Nov 2024 02:03:58 GMT

Hiya

I have set up a tJava and rLogRow to capture the sql query i am running in a tDBINPUT.. I am passing variables to the sql so i want to make sure the sql is what i expect it to be.

I have followed guide here

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/VY0YNC~A1lLP4ui~HHe6rQ

This worked fine previously in a small test job i did where there was not a lot of rows of data. The sql query is displayed FIRST in the first window. So i can just scroll to the beggining ot the run window and view the sql that has just run.

However on the current job i am creating there is lots of rows so when i try the same technique i am unable to see the SQL as there are lots of rows and i am unable to scroll up to see the SQL at teh beginning of the output in the run window

I have tried line limit without any success.

The guide mentions The query entered in the tDBInput component shows at the end of the job results, on the log: but its showing at the beginning and i am then unable to view it.

Any ideas if this is a setting i am not selecting correctly ??

Re: StoreSQLQuery and tLogRow . Cannot see query due to volume of data.

deailes — Wed, 24 Jun 2020 22:54:48 GMT

To answer my own question.

I was using a connection of run on component ok rather than run on subjob ok.

Run on subjob was the one i should have been using.

topic Re: StoreSQLQuery and tLogRow . Cannot see query due to volume of data. in Talend Studio

StoreSQLQuery and tLogRow . Cannot see query due to volume of data.

Re: StoreSQLQuery and tLogRow . Cannot see query due to volume of data.