Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Sesson Number
 Login/Join
 
Member
posted
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
 
Posts: 9 | Registered: July 29, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
See if the technique in DMC Variables - Job ID post helps you.
 
Posts: 382 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 9 | Registered: July 29, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.