Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error in Execute SQL script statement

  1. #1
    Join Date
    Nov 2015
    Posts
    1

    Default Error in Execute SQL script statement

    I am getting an error on this step and I don't know why.

    UPDATE sales_fact_1997 SET sales_fact_1997.store_cost = sales_fact_1997.store_cost * 0.75 WHERE promotion.media_type LIKE '%TV%'; UPDATE sales_fact_1997 SET sales_fact_1997.store_cost = sales_fact_1997.store_cost - 0.50 WHERE media_type = 'Radio'; UPDATE sales_fact_1997 SET sales_fact_1997.store_cost = sales_fact_1997.store_cost * 0.9 WHERE media_type = 'In-Store Coupon';

  2. #2
    Join Date
    Oct 2013
    Posts
    216

    Default

    Can you post your error ? that will make better explanations...
    -- NITIN --

  3. #3
    Join Date
    Nov 2009
    Posts
    688

    Default

    Which version of PDI you work. I think there where problems with ; in a SQL script in some versions of PDI

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.