XSD issue in virtual table creation
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
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 function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
when validated only for
BEGINDATE <= DATE()
received error as:
Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
when validated only for
DATEVAL(EFDATE)
received error as:
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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. DATEVAL
com.ascential.asb.cas.shared.ConnectorServiceException: 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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. DATEVAL
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
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 function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
when validated only for
BEGINDATE <= DATE()
received error as:
Error [IBM-IA-SERVER] [] Something went wrong. More details follow... ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
com.ascential.asb.cas.shared.ConnectorServiceException: ODBC function "SQLNumResultCols" reported: SQLSTATE = HY000: Native Error Code = -170: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]NUMBER OF ARGUMENTS SPECIFIED FOR DATE INVALID.
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
when validated only for
DATEVAL(EFDATE)
received error as:
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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. DATEVAL
com.ascential.asb.cas.shared.ConnectorServiceException: 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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. DATEVAL
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURDATE
com.ascential.asb.cas.shared.ConnectorServiceException: 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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURDATE
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
BEGINDATE <= CURRENT_DATE()
CURRENT_DATE
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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURRENT_DATE
com.ascential.asb.cas.shared.ConnectorServiceException: 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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURRENT_DATE
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
according to this doc, curdate() should have worked, but not working.. know why???
http://pic.dhe.ibm.com/infocenter/dzich ... clidat.htm
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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURDATE
com.ascential.asb.cas.shared.ConnectorServiceException: 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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURDATE
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
BEGINDATE <= CURRENT_DATE()
CURRENT_DATE
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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURRENT_DATE
com.ascential.asb.cas.shared.ConnectorServiceException: 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]No function or procedure was found with the specified name (FUNCTION) and compatible arguments. CURRENT_DATE
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.processCreateDataProducerRequest(ConnectorAccessHandler.java:840)
at com.ascential.asb.cas.handler.ConnectorAccessHandler$Worker.run(ConnectorAccessHandler.java:518)
according to this doc, curdate() should have worked, but not working.. know why???
http://pic.dhe.ibm.com/infocenter/dzich ... clidat.htm
Two more thoughts:
() is not the last thing one the line. Just a silly guess as I don't have a DB2 Z system to test with...
If that does not work, then open a PMR with JUST 'END_DATE > CURDATE() not working.'
Good luck!
Code: Select all
Try END_DATE > CURDATE() AND COL1 = 'APPLE'
If that does not work, then open a PMR with JUST 'END_DATE > CURDATE() not working.'
Good luck!
Regards,
Robert
Robert
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm