Products | Versions |
---|---|
TIBCO Collaborative Information Manager | - |
Not Applicable | - |
Resolution:
Description:
============
The requirement is to populate the PRODUCTID with sequence.nextVal during the Import operation.
Environment:
===========
TIBCO Product name and version: TIBCO Collaborative Information Manager 8.0.1
Operating System(s): All Operating Systems
Database: Oracle
Symptoms:
========
N/A
Cause:
=====
N/A
Resolution:
==========
There are two ways of doing this:
1). Use the following Oracle function that returns the nextval for the sequence:
CREATE OR REPLACE function TESTSEQ return number is
v_num number;
begin
select MYSEQ.NEXTVAL into v_num from dual;
return v_num;
end;
Here MYSEQ is the sequence in question.
2). Call the sequence from the rulebase of the ImportCatalogRecords activity:
<action>
<assign>
<var>PRODUCTID</var>
<op func="sequence">
<const type="string">MYSEQ</const>
</op>
</assign>
</action>
Refer to the CIM Workflow Guide for more details on how to use the rulebase in conjunction with ImportCatalogRecords activity.
Attachments:
===========
None.
References:
==========
None.