using Netezza sequence through kettle get sequrence

[ssagar]

I'm trying to use the Netezza DB to get the sequence in kettle but no able to make it work. It's giving me following error


2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Because of an error, this step can't continue:
2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error reading next value of sequence [autoincrement] from database
2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unable to get next value for sequence : autoincrement
2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ERROR: Relation 'autoincrement' does not exist


See below for testing of sequence in Netezza

TEST_DB=> create sequence test_num as int start with 1 increment by 1 maxvalue 100;
CREATE SEQUENCE

TEST_DB=> insert into aa select next value for test_num, 'name';
INSERT 0 1

TEST_DB=> select * from aa;
ID | NAME
----+------
1 | name
(1 row)

TEST_DB=> insert into aa select next value for test_num, 'name';
INSERT 0 1

TEST_DB=> select * from aa;
ID | NAME
----+------
2 | name
1 | name
(2 rows)


In kettle i did select or tick the "Use DB to get sequence" with Connection name and sequence name. Sequence is in the correct schema.

I'm using 3.2 and when i run the transformation, it showing a red box around the sequence step.

Any help would be highly appreciable.

[MattCasters]

To my knowledge Netezza sequences aren't supported yet.
File a feature request.