Detailed Description and Symptoms
Customers often want to name files associated with specific banner jobs by attaching the One_up number to them. This process has changed a bit in the Banner Rapid Automation Solution.?
Create a Character subvar and name it something similar to #GET_ONE_UP
In the SQL Statment portion you can use the following:
(((instr(so_full_pathname,'.',-1)) - (instr(so_full_pathname,'_',-1))-1))
and so_full_pathname like ('%.log')
You can now use this as a prompt on a chain component to assign the one up number to things like output files etc.
You may need to modify this a bit to fit your personal needs and this is only a template or basic example.?