Re: TCP start up

[Craig Richards <craig@xxxxxxxxxxxxxxxx>]

> > SELECT...
> > FROM TABLE (QSYS2.HISTORY_LOG_INFO(
> >                     START_TIME => CURRENT TIMESTAMP - 100 DAYS
> >               )) AS X
> > Where message_id='TCP1B03'
> > ORDER BY ORDINAL_POSITION desc;


Steve,

Table is an SQL table function.

QSYS2.HISTORY_LOG_INFO() is a UDTF.

Basically it's calling a UDTF and turning it into a table that SQL can work
with.

Rob has provided a link to DB2 for i Services, from which you will be able
to see what data is returned from the UDTF.

regards,
Craig