Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to runDB2 commands

  1. #1
    Join Date
    Mar 2007
    Posts
    158

    Default How to runDB2 commands

    Hi all,


    I am running multiple transformation in a job.

    But befor final job I want to run these db2 commands


    db2 "REORG INDEXES ALL FOR TABLE REPORTS.DESCISION"

    db2 "REORG INDEXES ALL FOR TABLE REPORTS.DESCISION2"

    db2 "REORG INDEXES ALL FOR TABLE REPORTS.ACCT"



    How can I run these type of sql commands in db2 using kettle?

    Thanks

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

    Default

    Via a shell job entry... only way for now.

    Regards,
    Sven

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.