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 VenkatThis message has been edited. Last edited by: Tamra,
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