Itgensql056 : Files@Os on QueryTool

Since recent upgrade (now on QueryTool 22.0.578) it seems that something is broken with the files object:

select * from files('C:\jobs\','*.xml',false)@Os

QueryTool says:

mismatched input ‘@’ expecting {, ‘;’}.

The updated syntax is files@os, so table and data container alias together.

I think this was updated by mistake on 22.0 too instead of just on the new 22.1.

Thanks, how to pass the parameters with the new syntax then ?

Like so:

select *
from   files@os('C:\jobs\','*.xml',false)

It works thanks.

Same remark for read_file_text@os(parameters...)

1 Like