Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to set "Use a database to generate a sequence"

  1. #1

    Default How to set "Use a database to generate a sequence"

    Hi,

    Pls help me. Can someone tell me how to set parametres of step Add sequence if i want to fetch next value of some id column? I need to know what exactly i have to write there, if i have got for example schema SCHEMA, table TABLE, and column with id's called ID. There is no documentation and samples about setting this step that

    Thx a lot.

    Paul

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Auto-increment (auto-id, serial data types, etc) columns typically are incremented automatically by the database.
    It is not possible to get the value out of them separately.
    You need to insert a record ("Table Output") and then you can get the inserted id back.

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.