How to run SQL query from object type and export results to txt file?
I need to run the SQL statement below from an object type and have it save the results to a text file. I need it in text file format to run a vb script against it. I can export from SQL runner, but I am trying to automate it from a workflow. I am not sure how to do this. Do I use ksc_itg_run_sql?
select meaning from knta_lookups where lookup_type like 'Windows%' and enabled_flag='Y'
Make sure you set a source environment on execution step, otherwise the command won't be executed.
ksc_run_sql ------------ This command runs a SQL query against the chosen environment. The result of the last row queried is returned in the [SQL_OUTPUT] token. The result of the entire query is placed in the [AS.PKG_TRANSFER_PATH][PKGL.SEQ].txt file in .