If your organization's coding standards allow for it, then the easiest thing to do is to set the column default value to the sequence.NEXTVAL you want to use, and ignore the entire column in the insert statement. This works with JDBC store, I think it should work with DB Store.
------------------------------
Peter Sykes
Vontobel Holding AG
ZUERICH
------------------------------
Original Message:
Sent: 03-24-2023 15:09
From: Dhinmar James Cayog
Subject: Use Oracle Sequence and add to incoming data
Hi,
I want to insert incoming records from transformation node to "TABLE_A" using DB Store node. But before I insert it to "TABLE_A", I want to add the database sequence used by "TABLE_A" as ID.
That would be something like this:
Incoming |
column A |
column B |
A1 |
B1 |
A2 |
B2 |
A3 |
B3 |
select sequence_name.nextval as ID from dual;
with sequence |
ID |
column A |
column B |
6 |
A1 |
B1 |
7 |
A2 |
B2 |
8 |
A3 |
B3 |
Is this feasible or are there other ways of doing it?
------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
------------------------------