question about step codes

[updt1]

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.

[fyot]

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.

[mauriziog]

In the steps there isnt a logical AND, they works only with the OR: they are all read and if the case mode then one ON-DO group can be executed.

[updt1]

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.

[updt1]

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.

[mauriziog]

For me the aswer is that is always "OR", there isnt AND value, for one or two on statements in the same block.
I havent esperienced the possibility to do logical AND in the steps panel in ON blocks.