Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: very simple update sql

  1. #1
    Join Date
    Nov 2008
    Posts
    8

    Default very simple update sql

    we are trying to put an update sql:

    update table_name set ppyd_start_date = ppyd_end_date - 13

    This works fine in SQLPLUS but fails in the table input. Is that the wrong mod for update....
    (access > oracle

  2. #2
    Join Date
    Oct 2007
    Posts
    107

    Default

    Hello Steven,

    Table input is for .... actually input :-) not for update.

    For this, use an Execute SQL Script.

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.