DB2 error

ramesh_inform · Post by **ramesh_inform** » Fri Apr 04, 2008 2:47 am

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??

ArndW · Post by **ArndW** » Sat Apr 05, 2008 5:24 am

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

John Smith · Post by **John Smith** » Sun Apr 06, 2008 5:06 pm

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

ramesh_inform · Post by **ramesh_inform** » Mon Apr 07, 2008 11:14 pm

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

ramesh_inform · Post by **ramesh_inform** » Mon Apr 07, 2008 11:15 pm

thanks john smith