Hi I need to create some sql which will tell us how our application is being used at each client site. I created some sql statements to generate the necessary data, but I am not sure about how to label the data and send it out to a report. I've pasted the sql below. Thanks for any assistance. --How many schedules in the last 90 days? asked 27 Sep '13, 19:06 dejstone |
Put an OUTPUT TO 'filespec' APPEND after each SELECT, and run the script via dbisql in batch mode. answered 28 Sep '13, 08:31 Breck Carter If dbisql isn't an option, you could also use UNLOAD SELECT ... TO CLIENT FILE ... APPEND ON although it takes a bit of work to get that going in a client app (option settings, callbacks, etc).
(29 Sep '13, 08:56)
John Smirnios
|