AutoSys Workload Automation

Expand all | Collapse all

SQL statement output to spool to file

  • 1.  SQL statement output to spool to file

    Posted 10-15-2015 09:16 AM


    I am executing a select statement, but, I want the output to spool to a file in AutoSys 11.3.6 using the Database Plugin.  Please advise.

     

    Regards,

    AkBar Dar



  • 2.  Re: SQL statement output to spool to file

    Posted 10-15-2015 09:20 AM

    Akbar,

    you did read how to create a SQL job, it clearly has the outfile listed as a parameter.

    you need to remove it everytime. unless they fixed that bit.

     

    Good luck

    Steve C.



  • 3.  Re: SQL statement output to spool to file

    Posted 10-15-2015 10:08 AM

    Thanks, Steve, would you please give me the link?  I am working out of Reference guide, and there are much examples in there.

     

    Regards,

    AkBar Dar



  • 4.  Re: SQL statement output to spool to file

    Posted 10-15-2015 10:17 AM

    if you have the reference guide it should be right there.. I don't have one handy with me at this time. but its output or spool_destination:

    I believe..



  • 5.  Re: SQL statement output to spool to file

    Posted 10-15-2015 10:20 AM

    It looks like, it's destination_file: parameter.

     

    Thanks for you help.



  • 6.  Re: SQL statement output to spool to file

    Posted 10-15-2015 10:25 AM

    as i said it was in the book, I just dont have it on hand. I am off assignment at the moment.