Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Parameters usage

  1. #1
    Join Date
    Oct 2011
    Posts
    2

    Default Parameters usage

    Hi all,
    i'm a new user here.

    I'm trying to use "Execute SQL script" to create a table if table doesn't exists.
    This is the sql:
    CREATE TABLE ?(
    field INTEGER
    );

    i've checked "Variables substitution" and added parameters in parameters grid but the error is still:
    "Couldn't execute SQL: CREATE TABLE ?( field INTEGER )
    Invalid table name"

    Suggestions?

    P.S. sorry for my bad english ...

    Thanks @all.

    Bye,
    Nicola.

  2. #2
    Join Date
    Oct 2011
    Posts
    2

    Default

    Quote Originally Posted by Ixo View Post
    Hi all,
    i'm a new user here.

    I'm trying to use "Execute SQL script" to create a table if table doesn't exists.
    This is the sql:
    CREATE TABLE ?(
    field INTEGER
    );

    i've checked "Variables substitution" and added parameters in parameters grid but the error is still:
    "Couldn't execute SQL: CREATE TABLE ?( field INTEGER )
    Invalid table name"

    Suggestions?

    P.S. sorry for my bad english ...

    Thanks @all.

    Bye,
    Nicola.
    Maybe JDBC does not allow binding parameters for table names? ... i have to build a string rappresenting my sql statement? Ok let's try!

  3. #3

    Default

    Hi,
    try to use '?'. If you use only ?, The steps think is a number.... use pls '?', same to char...

    I Hope can U help in something

    Regards!
    D.

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.