Getting Banner one_up number with RA solution

Document ID : KB000090362
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 8.0

Getting Banner one_up number with RA solution
Resolution:
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.?


Solution

Create a Character subvar and name it something similar to #GET_ONE_UP

In the SQL Statment portion you can use the following:

select substr(so_full_pathname,
(instr(so_full_pathname,'_',-1)+1),
(((instr(so_full_pathname,'.',-1)) - (instr(so_full_pathname,'_',-1))-1))
)
from appworx.so_print_log
where so_jobid={#jobid_{chain_id}}
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.?