DSXchange

any insights on this please? thanks

tried both robert END_DATE > CURDATE() CURDATE Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -440: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS...

yes, did that robert and ray, adding one by one, all these logs where found in iaserver.log COL1 = 'APPLE' ---> No problem when put in single quotes when validated only with this condition END_DATE > DATE() error received: Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC fu...

robert thanks first of all for responding did exactly the same... on the GUI, the error message is "Too many open or close parantheses, Missing one or more columns Invalid Date value entered, cannot be converted to date format." In the iaserver.log file the error is this one 4 times ODBC f...

robert, one basic question... whether multiple where conditions and these kind of function are even possible in IA?? ..

am i keep hitting a metal wall???

tried that as well, table is getting created but when tried to open, getting the error as "The edit virtual table cannot be opened" <?xml version="1.0" encoding="UTF-8"?> <iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name="IA"...

Hi robert i tried exactly like below, but getting an error as " </stacktrace><message>The XML request passed as parameter could not be parsed for the following reason: The entity "le" was referenced, but not declared.</message><classn cential.investigate.api.exceptions.CannotParseRequ...

any idea on <sqlexpression> ????

Hi thanks for responding.. i tried so many ways.. but couldnt nail it.. can you please tell what's the issue in the below code.. the command finishes successfully, but i'm not even able to even open the table, its showing "the edit virtual table cannot be opened" <?xml version="1.0&qu...

Hi rj, thanks for responding..

your command has worked, thanks a lot...

but i'm struggling to get the rest of the syntax for the where conditions right, can you please specify me how to specify multiple where conditions with "AND" in that xml..

thanks a lot

thanks ray

i have pasted the entire error message i got....

any idea???

thanks for your response..

tried that
col1 < Currentdate()

but not working, getting error as
"The where clause is invalid, please make sure the structure is correct, the column names are correct, and if necessary values are properly quoted.

Hi As i was getting issue creating virtual table through "GUI", I tried one of the examples posted in the http://www.dsxchange.com/viewtopic.php?t=146526&highlight=virtual+table but the xsd provided there was not working for me, below are the issues i tried running this command C:\IBM\...

Hi I'm trying to create a virtual table, as i tried to use the free form editor in the virtual table, i'm getting the below error, i tried so many times restarting the application but no use at all, i couldn't even type a single word, anyway to post screenshot here? error ==== System.ArgumentNullExc...

Hi i'm trying to create conditions for virtual table in column analysis, having difficulty in specifying "current date" and extracting date from timestamp column and comparing, like below, can someone help me? col1 <= sysdate /* how to specify sysdate in the condition box date(col2) < '201...