Raul_Rodriguez_8894

SQL to File automation

Discussion created by Raul_Rodriguez_8894 on Feb 13, 2017
Latest reply on Apr 4, 2017 by Wolfgang_Brueckler_1288
Hi, I am new to this forum (Disclosure  ) I have follow the instructions on this posting:

https://community.automic.com/discussion/comment/27187/#Comment_27187

 In my objects in the post Process Tab, I have
:SET &SQL_RESULT# = PREP_PROCESS_REPORT(,,,"BU*") :PROCESS &SQL_RESULT# :ENDPROCESS :SET &ACT_JOB#=ACTIVATE_UC_OBJECT('JOBS.UNIX.STAHFM.…
MOVE.SQL.FILE',,,,,PASS_VALUES)

In the Job File I have in the Process Tab
cd\Inbox
echo &SQL_RESULT# > Functions.txt

As I go to my inbox, I see the newly created file, so the ACTIVATE_UC_OBJECT appears to properly call the Job File, for that is the only place where the echo command is written. The problem is that the file is empty. The SQL Query does produce the appropriate information, because before I went in this direction, I downloaded the file from the Reports>Directory>Download option. The file did contain the appropriate data. Two columns of data separated by a semicolon, For example:
BU_PHLEGY;PH51

Could anyone tell me where is the process failing or point me in the right direction?

Thanks

Outcomes