Thanks a lot for your help. I have an other question. I need to execute the query from sql server, so is valid to do this:
select * from openquery(LINKEDSERVERNAME, 'select * from pub.JOURNAL where campofecha >= TIME')
Sql server use the openquery function to execute queries in the linked server that is conected in via odbc to progress.
Thanks a lot for your help.