Try using

SELECT *

FROM OPENQUERY(bisysb_systemcatalog , 'select table_schema, table_name, column_name,ordinal_position,

       data_type, length, numeric_scale, numeric_precision,

       is_nullable, has_default, column_default, ccsid,

       column_text

from qsys2.syscolumns

where table_name = 'AAGE200F'

         and table_schema = 'D500DATBQ'

order by...