cancel
Showing results for 
Search instead for 
Did you mean: 

InfoSet Query export to csv

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Go To transaction SMOD and activate SQUE0001.

and  you can create user exit from FM EXIT_RSAQEXCE_001

Modify your query from SQ01 again with Private Folder selected


david_flad3
Explorer
0 Kudos

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.