none
The multi-part identifier " " could not be bound.

    Question

  • HI ,

    I am using ODI, and working on SQLSERVER.

    my task is to extract numbers from a string and populate it to target column.I need to use a single line function

    SUBSTRING(table_name.column_name,PATINDEX('%[0123456789]%',table_name.column_name),len(table_name.column_name)-PATINDEX('%[0123456789]%',table_name.column_name) + 1)

    this above query runs good in Database, but when used on ODI , it gives runtime error as - The multi-part identifier "table_name.column_name" could not be bound.
    com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier ",table_name.column_name" could not be bound.

    Please help.

    Thanks,

    Neha

    Wednesday, December 12, 2012 12:06 PM

Answers

  • Not sure what is ODI but have you made sure that you are in proper database? Here is the sample

    create database Neha;
    go
    use Neha;
    go
    create table Me(myname int);
    go
    Select you.myname from Neha.dbo.me;
    /*
    Msg 4104, Level 16, State 1, Line 1
    The multi-part identifier "you.myname" could not be bound.
    */
    use master;
    go
    Select myname from Neha.dbo.me;
    /*
    this works
    */


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Wednesday, December 12, 2012 12:20 PM