SQL Syntax Error SQL0104
I have to recreate a duplicate logical file, but I can’t use the crtdupobj command because it doesn’t recreate the correct library pointers. Using the dspfd command. I’m attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library) I’m attempting to create the file in SQL using the [...]

Answer Question   |  May 26, 2010  6:37 PM
SQL, SQL error messages, SQL Statement Syntax Errors, Syntax errors

tell me why I’m getting the message “The multi-part identifier “134062-DB1.netFORUMSTaging.dbo.Individual.individualKey” could not be bound”
I’m trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in (‘MIBNOM1′,’MIBNOM2′) order by add_date asc But I keep getting an error message PLEASE HELP

Answer Question   |  March 7, 2009  3:36 PM
SQL, SQL error messages, SQL Statement Syntax Errors, SQL statements