Getting Banner one_up number with RA solution

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): 8.0

Getting Banner one_up number with RA solution

Environment

Release:
Component: ARABNR

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.?