Hi!
I have to get information about steps codes looking for it in the database server, but I can't find where the field "and_or" is, in order to obtain the logical relationship between two or more on_statement.
Does anyone know where (table and field name) is this field? Is it in the server database, enterprise database or both?
Thanks in advance.
question about step codes
Hi
There is no field "and_or".
In fact Steps use some different tables :
* must be replace by CMR and CMS in Control-M database
*_ON_STMT
*_DO
*_SETVAR
*_SHOUT
*_CON_J
*_CTL_J
*_QR_J
....
For CMS tables (jobs definition)
All of them includes JOBNO, DO_NO and IF_NO to build link between tables.
For CMR tables (actives jobs)
All of them includes ORDERID, DO_NO and IF_NO to build link between tables.
It's exactly the same wit Control-EM database.
There is no field "and_or".
In fact Steps use some different tables :
* must be replace by CMR and CMS in Control-M database
*_ON_STMT
*_DO
*_SETVAR
*_SHOUT
*_CON_J
*_CTL_J
*_QR_J
....
For CMS tables (jobs definition)
All of them includes JOBNO, DO_NO and IF_NO to build link between tables.
For CMR tables (actives jobs)
All of them includes ORDERID, DO_NO and IF_NO to build link between tables.
It's exactly the same wit Control-EM database.
On- Post-processing parameter.
Mauriziog,
I'm sorry, but I don?t understand the explanation (maybe I didn?t explain the question in the right way). I read this from the Control-M user Manual about post-processing parameters (page 3-110):
"A/O Optional. Specifying either A (And) or O (Or) opens a new ON statement
in the ON block (described later) and links the new statement to the
statement containing the A/O specification, as follows:
A (And) Indicates AND logic between the two ON statements. ON
block criteria are satisfied only if both ON statements are
satisfied.
O (Or) Indicates OR logic between the two ON statements. ON block
criteria are satisfied if either (or both) ON statements are
satisfied."
I read this too:
"The relationship between multiple codes in an ON statement is OR ..."
so I suppose that's what you are talking about, but I need to find the link between two ON statement in the same ON block, that's what i'm looking for in the database.
Thanks.
I'm sorry, but I don?t understand the explanation (maybe I didn?t explain the question in the right way). I read this from the Control-M user Manual about post-processing parameters (page 3-110):
"A/O Optional. Specifying either A (And) or O (Or) opens a new ON statement
in the ON block (described later) and links the new statement to the
statement containing the A/O specification, as follows:
A (And) Indicates AND logic between the two ON statements. ON
block criteria are satisfied only if both ON statements are
satisfied.
O (Or) Indicates OR logic between the two ON statements. ON block
criteria are satisfied if either (or both) ON statements are
satisfied."
I read this too:
"The relationship between multiple codes in an ON statement is OR ..."
so I suppose that's what you are talking about, but I need to find the link between two ON statement in the same ON block, that's what i'm looking for in the database.
Thanks.
Fyot,
please, look at this example:
This is table's cmr_stmt information for a specific orderno:
IF_NO STMT CODE ROWORDER
------ -------- ------- ---------
1 ANYSTEP OK 1
2 PASO10 C0008 1
2 PASO10 C0012 2
3 PASO20 C0008 1
3 PASO20 C0012 2
4 PASO40 C0008 1
4 PASO40 C0012 2
and this is table's cmr_do information for the same orderno:
IF_NO ACTION ROWORDER EX DO_NO
---- ------- -------- -- -------
1 SYSOUT 0 N 1
1 SYSOUT 0 N 2
2 OK 0 N 1
3 OK 0 N 1
4 OK 0 N 1
let's talk about if_no 2, 3 and 4; I translate the information in this way:
ON STMT="PASO10" CODE="C0008" AND_OR="OR"
ON STMT="PASO10" CODE="C0012"
DO ACTION="OK"
ON STMT="PASO20" CODE="C0008" AND_OR="OR"
ON STMT="PASO20" CODE="C0012"
DO ACTION="OK"
ON STMT="PASO40" CODE="C0008" AND_OR="OR"
ON STMT="PASO40" CODE="C0012"
DO ACTION="OK"
as you can see, field AND_OR (A/O) is always OR, because I'm not able to establish the link between to on statement in the same on block just with the if_no, do_no, and roworder information.
So, please, can you help me?
Thanks in advance.
please, look at this example:
This is table's cmr_stmt information for a specific orderno:
IF_NO STMT CODE ROWORDER
------ -------- ------- ---------
1 ANYSTEP OK 1
2 PASO10 C0008 1
2 PASO10 C0012 2
3 PASO20 C0008 1
3 PASO20 C0012 2
4 PASO40 C0008 1
4 PASO40 C0012 2
and this is table's cmr_do information for the same orderno:
IF_NO ACTION ROWORDER EX DO_NO
---- ------- -------- -- -------
1 SYSOUT 0 N 1
1 SYSOUT 0 N 2
2 OK 0 N 1
3 OK 0 N 1
4 OK 0 N 1
let's talk about if_no 2, 3 and 4; I translate the information in this way:
ON STMT="PASO10" CODE="C0008" AND_OR="OR"
ON STMT="PASO10" CODE="C0012"
DO ACTION="OK"
ON STMT="PASO20" CODE="C0008" AND_OR="OR"
ON STMT="PASO20" CODE="C0012"
DO ACTION="OK"
ON STMT="PASO40" CODE="C0008" AND_OR="OR"
ON STMT="PASO40" CODE="C0012"
DO ACTION="OK"
as you can see, field AND_OR (A/O) is always OR, because I'm not able to establish the link between to on statement in the same on block just with the if_no, do_no, and roworder information.
So, please, can you help me?
Thanks in advance.