DSXchange

Tera_Con_ENGR_ITM_VERS: [IIS-CONN-TERA-005009] Query returned 0 row(s). SQL statement: LOCK ROW FOR ACCESS SELECT TRIM(TableKind) FROM DBC.Tables WHERE DatabaseName = 'DB_NAME' AND TableName = 'Table_Nm' (CC_TeraConnection::getTableKind, file CC_TeraConnection.cpp, line 1,714)


When i try to Load data into Table it throws up this error and Job aborts. Can any body understand me what kind of error and why do we get this?

Need any more info please ask, I will provide.

What happens when you execute the same query under the same userid outside of DataStage? Does it return any rows?

Yes , it does return rows when i do a select on that table. but I think i am unable to insert right?

Let's make sure we're talking about the same "that table"... I meant can you run the query in the error message, not can you select from your target table.

Maybe you don't (and shouldn't have?) INSERT privilege to this table?

What is the initial SQL statement and which stage are you using?

Try this:

SELECT TRIM(TableKind) as TableKind FROM DBC.Tables WHERE DatabaseName = 'DB_NAME' AND TableName = 'Table_Nm'