I am using File Listener to get some csv files at a particular folder location and load those to a target table.
It is successful and i use SOURCE_FILE_NAME as an INSTANCE to get the source file name in the target table.
So when i use this dataflow in my process flow,how can i grab the source file name.?
I need to include the source file name in a procedure to store the log regarding each dataflow.
Can i grab the SOURCE_FILE name out of data_flow.?This message has been edited. Last edited by: FP Mod Chuck,
After the data flow completes you can have a stored procedure that reads that column out of the target table, hold the results and then do a -READFILE of the hold file into a variable and then reference the variable in your procedure.
Using a global variable so it will be available in your subsequent procedure.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
I will try the solution you provided and then close the post as solved.
|Powered by Social Strata|