}Drill process return handle

[Drg]

Hello all.

Has anyone encountered returning data from a drill process where the source is specified as a csv file?
The official doc is silent on this matter, but there are still some references that the function is reserved and works through the rest api. So maybe I’m doing something wrong or it doesn’t work very well in old clients? PA 2.0.9

as I expected it only works in PAW

csv columns (variables) define as 'Other' in the source variables tab.

Epilog code:

Code: Select all

ReturnCSVTableHandle;

documentation: https://www.ibm.com/docs/ro/planning-an ... llsets.htm

[Wim Gielis]

Hello,

George Tonkin and Edward Stuart have been working on this in the past:
https://community.ibm.com/community/use ... utput-file

Does this help ?

[Drg]

yep Wim thanks

[lotsaram]

I wasn't aware of this. Will have to look up ReturnCSVTableHandle and see if I can get it to work.

The "classic" way of doing this is to use a text to ODBC driver and set up a public ODBC DSN pointed to a specific folder then have a TI process write a CSV to the folder which can then be displayed as a drill-through result. However, just being able to reference a CSV directly for a drill-through seems like a betrter option.