Another solution to solve this problem ?

[jcpreaux]

Hi The Community !

I've a job which purpose is to extract data from a database and to generate a file with these datas.

And as an extra, first and last lines must contain  the numbers of extracted rows.

I've done a job which works well (see below) but is there another best solution to do this ?

Thanks !

JCP

[TRF · Accepted solution]

Hi,

As you can't get the number of records before the select result, your solution is ok.

Maybe for the last line you should use a tFileRowCount (-1) to get the real nmber of lines in the output file (1rst line = expected number of records - last line = effective number of records).

Edit: I replaced "you get" by "you can't get" - of course!