topic Re: [TOS 3.0] Generate sequence numbers in Talend Studio

[TOS 3.0] Generate sequence numbers

Anonymous — Sat, 16 Nov 2024 14:09:30 GMT

Hi
When inserting into database, I'd like to generate a sequence number for each inserted row.

Is it possible to do it with a Talend component ?

Best Regards
msomso
P.S.
I can't use ROWID pseudo column - doesn't exist in Sybase database (ASE) and we don't use the identities.

Re: [TOS 3.0] Generate sequence numbers

Anonymous — Wed, 19 Nov 2008 13:50:11 GMT

Hi,
Solution founded in :
http://www.talendforge.org/forum/viewtopic.php?pid=12996#p12996
Regards
msomso

Re: [TOS 3.0] Generate sequence numbers

Anonymous — Wed, 19 Nov 2008 16:09:47 GMT

Would this work also: http://www.talendforge.org/forum/viewtopic.php?pid=18595#p18595

Re: [TOS 3.0] Generate sequence numbers

Anonymous — Thu, 20 Nov 2008 09:21:38 GMT

Hi,
The suggested solution isn't clear for me ...
Could you explain please, how has to be defined the SelectTitleId component in Shong uploaded screenshot ?
Or maybe, upload your job's screenshots ...
Thanks
msomso