Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Problems with parameters in sql execute step

  1. #1
    Join Date
    Mar 2011
    Posts
    1

    Default Problems with parameters in sql execute step

    Hello,

    i have a transformation with the switch/case step which two cases is to process. In the first case, a table should be truncatet and in the second case, a new partition to be created. For both cases i used the sql execute step. I get error when i run the transformation.

    The sql statement for the truncation is:
    DELETE FROM ${SCHEMA}.${TABLE_NAME} WHERE PROCESS_ID = PROCESS_ID;
    In this statement i have replaced the placeholder ? with PROCESS_ID then i get the error.
    The error from the truncation step is at attachment.

    The statement for the partition is:
    ALTER TABLE ${SCHEMA}.${TABLE_NAME} ADD PARTITION (PARTITION ? VALUES IN (?);

    Can someone help me?
    Attached Images Attached Images  

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.