Error: [NetSuite][SuiteAnalytics Connect JDBC Driv...
# suiteanalytics
s
Error: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Syntax Error in the SQL statement.[10104] SQLState: 42000 ErrorCode: 10104
p
I am not able to use TOP 5 in our installation. I have to put AND rownum<6 in the WHERE clause.
s
Interesting. It makes sense to use ROWNUM though, as that is supported internally by the Oracle database. I wonder if different NetSuite accounts could be on different versions of database software?