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? |
Put an OUTPUT TO 'filespec' APPEND after each SELECT, and run the script via dbisql in batch mode. 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
|