Focal Point
[SOLVED] Sesson Number

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7107098276

September 30, 2014, 05:10 AM
VS4
[SOLVED] Sesson Number
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,


WebFOCUS8,IWAY DM
Windows, All Outputs
September 30, 2014, 08:12 AM
Clif
See if the technique in DMC Variables - Job ID post helps you.
September 30, 2014, 08:26 AM
VS4
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


WebFOCUS8,IWAY DM
Windows, All Outputs