Hello,
I have a Unix script and is defined as a Banner as a job (i.e., can submit from Job sub in Banner)
The script calls a SQL script and produces a comma delimited file (ex. "21342","20170323"). The place the extracted value in an e-mail.
After the job is complete I want to extract the first line of text.
I created a condition in the Job (Timing: AFTER; Condition: STATUS; Fi status - FINISHED; Then EXTRACT VALUE first time). I know this part works.
In the extract Detail...
FILE Filter I have tried Substitution variables that give the full path to the output file - {#LIS_FILE_FULL_PATH}.
FILE Filter: {#LIS_FILE_FULL_PATH}.
Tried both "Report files " and "External Files"
Search: "," (I tried just " did not work)
Position: 1-100
The subvar: #TWRBMEN_RECORD
I placed {#LIS_FILE_FULL_PATH} in my e-mai text body. The e-mail does show its value (ex./dmp/automic/jobtest_twrbmen_67910.lis) so I know {#LIS_FILE_FULL_PATH} has a value. However, the value of #TWRBMEN_RECORD is blank.
When I hard code the FILE Filter: to /dmp/automic/jobtest_twrbmen_67910.lis (a report created by a previous run) the Extract works. The value of #TWRBMEN_RECORD is in the e-mail.