Hi,
I have implemented a process flow in DM with some procedures and flows linked in.
at the begining of the process flow I want to assign a unique session number and I want to use that in my flows , please can some one advise?

similar to the concept of ODI session number at the begining of a ODI package which has several interfaces.

Regards
Venkat

This message has been edited. Last edited by: Tamra,

See if the technique in DMC Variables - Job ID post helps you.

thanks for your reply , I have seen this but i want to initialise a sesson number before the process flow kicks off.
I am calling a sequence number from oracle , I think I have got wat i needed.thanks

SQL SQLORA SET DEFAULT_CONNECTION CFA
SQL SQLORA
SELECT CFA_DCA.DCA_USER_CHANGES_SEQ.NEXTVAL AS SN FROM DUAL;
TABLE HOLD AS FOCCACHE/CFA_SESSION
END
DEFINE FILE CFA_SESSION
SN1/I5=SN;
END
TABLE FILE CFA_SESSION
PRINT SN1
ON TABLE HOLD AS SN2 FORMAT ALPHA
END
-RUN

-READ SN2,&&SESSION_NUMBER.I5
-TYPE SESSION_NUMBER &&SESSION_NUMBER


Regards
Venkat