November 15, 2006 Hey, Ted
While using interactive SQL/400 from a green-screen session, I can direct the output of an SQL command to a database file. Is there a way to direct the output of a dynamically created SQL command to a database file from a batch job?
Yes, you have a few options. First, let’s review the steps you use in your interactive session, for the benefit of the readers.
From the interactive session, press F13 to access the Services panel. From there select option 1 (change session attributes), and enter 3 at the SELECT output prompt. Fill in file name, library, and