Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Simple Table Update

  1. #1
    Join Date
    Apr 2006
    Posts
    9

    Default Simple Table Update

    Hello,

    is it possible, that ther is no simple update Step? I read the manual searched in this forum and also tried to google the answer, but without success.

    I just want a step, which updates on or more fields in my table.
    Just like an simple Update SQL:
    update table1 set accessflag=1, update=0 where id < 100

    Is something like that possible without defining a hand of steps?

    Thank you for help


    Alex

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Why would you want to do that ... there is an SQL exec job entry.

    Regards,
    Sven

  3. #3
    Join Date
    Oct 2007
    Posts
    15

    Default simple table update

    im not sure I understand your question.

    if you have a look at the output steps for a transformation, you will see two similar steps there, Insert/Update and Update.

    or you can use the sql!

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.