Hello again, Although we have no knowledge of Cognos, the general consensus here would be to not use "*", as this will attempt to read all dictionaries.
If one of them is bad then you will get some sort of error, which is what appears to have happened here. Best to select fields explicitly, or try to determine which dictionary is producing the error. If you have thousands of dictionary items you will probably be exceeding the limits of what SQL is able to handle. Test with SQLSELECT first, as if it doesn't work from a jshell then it will never work anywhere else. Mike Mike Street jBASE Technical Support Engineer 949-383-2425 | 866-582-8447 [email protected] | www.jbase.com 9245 Research Drive, Irvine, 92618 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MChau Sent: 03 April 2018 14:10 To: jBASE <[email protected]> Subject: Connect jbase with cognos Hi team I’m facing issue while we trying connect jbase with cognos. The erro is: SQLExecDirect:ERROR: 80045024?SELECT * FROM FBNK_SECTOR LIMIT 100? Parse Error:Not numeric Regards -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
