DSXchange

Iam trying to write a user defined sql in DB2 stage
user define sql :select * from DW001.DLY_TIME_DEP

the error when iam trying to view data is as follows

##E TNDB 000209 01:46:10(000) <dw001_dly_time_dep> Unrecognized argument: select * from DW001.DLY_TIME_DEP [argvcheck/argvcheck.C:3832]

can any one help??

Ramesh - you've marked this as having a "workaround" - does that mean you found the problem?

try not using "*" but define what columns ,also include the ; at the end of your sql statement.

yes this topic was resolved...that was a DB2 connectivity problem

thanks john smith