on 01-05-2015 5:49 PM
I need to automate the output of an HR InfoSet Query to a csv file.
What is the best, straight forward approach to this?
Thank you,
Tammy Strole
I'm still looking for a solution, but did find information an enhancement called SQUE0001. There are also statements that this is an "older" solution. I followed the instruction I found to install this enhancement, which activates a "Private File' radio button on SQ01. Can anyone comment on this approach? Is there a newer solution I should be reviewing? Although I successfully implemented the enhancement and added the necessary include, SQ01 does not output a file to the location I specify.
Thank you,
Tammy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As mentioned by Shivendra, after you activate the enhancement point, you have to write logic into the actual user exit to derive the filename to store at the Application server along with the path, and then capture the list and drop it using that information.
Elsewhere in SDN, I've seen a suggestion about writing a wrapper program that will call your query saving the results, and then after execution, pull the results from memory and write it wherever you
need/want it to go.
This is the direction I am likely to go in -- writing a wrapper program that accepts query name and variant details, along with a path for the eventual output. This will then be re-usable for anyone seeking to do the same task for another query using a repetitive execution via batch job/scheduler.
I am working on this now -- so if you want the details, I can post/share them when finished, hopefully before the end of this week.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.