Re: RE: How to create data with a seq_next val

[podunk]

What's the sense to manually increment row ID?

 

You can use SQL Script as well.

 

INSERT INTO my_table (id, name) VALUES (nextval('db."myfield_seq"'), ?);

 

 

Sent: Tuesday, December 17, 2024 at 2:07 PM
From: mh...@lstelcom.com
To: users@hop.apache.org
Subject: RE: How to create data with a seq_next val

Thank you Bart,

 

I’ve just found that I could actually also use the ‘Add Sequence’ transform

 

Silly Me !

 

Thanks for the help

 

 

 

From: Bart Maertens <bartm...@apache.org>
Sent: Tuesday, 17 December 2024 13:46
To: users@hop.apache.org
Subject: Re: How to create data with a seq_next val

 

Hi MHeyd, 

 

What database engine do you use? 

For a supported database, you could try the "Use DB to generate the sequence" option in the Add sequence transform [1]. 

Another option could be to use an option similar to an auto increment, where your table's primary key uses that sequence to create the next value, but a lot depends on your use case and requirements there. 

 

[1] https://hop.apache.org//manual/latest/pipeline/transforms/addsequence.html

 

Regards, 

Bart 

 

 

On Tue, Dec 17, 2024 at 1:39 PM <mh...@lstelcom.com> wrote:

Hello Apache Hop Users,

 

I’m trying to Create data via a ‘Table Output’ transform.

 

One of the field shall contain a sequence value. The next db sequence value can be generated like this

nextval('db."myfield_seq"')

 

Do you know how to pass this to the ’table output’ transform?

 

(I have  also tried to read first all new sequences but could not combine a ‘table input’ with an ‘excel input’)

 

Thank you in advance for your help