Error: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Syntax Error in the SQL statement.[10104]
SQLState: 42000
ErrorCode: 10104
p
peter metcalf
03/18/2021, 4:21 PM
I am not able to use TOP 5 in our installation. I have to put AND rownum<6 in the WHERE clause.
s
scottvonduhn
03/18/2021, 4:39 PM
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?