You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

PSQUERY RESULTS OF REMOTE DATABASE

No replies
Guest's picture
Guest

Hi

I have created a PSQUERY with same name on different databases (fin91 and fin92) with different criteria.So suppose if i run psquery 'X' in database 'FIN91' the result will give 8 and if i run psquery 'X' in database 'FIN92' the result will give 100.

Using 'RUNTOFILE' command i am able to get the result of database FIN92 into a file.But how to get the result of database FIN91 into a file using 'runtofile' command?

Please give me sample peoplecode for this.

Note: Dblink is created but not getting how to use it in 'RUNTOFILE' command.

Please help

Thanks
PS

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
4 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.