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