Don't use "*" as this will attempt to read all dictionaries, and if one of them is bad then you'll get some sort of error, which is what appears to have happened.
Best to select fields explicitly, or try to determine which dictionary is producing the error. I should also point out that if you have hundreds or thousands of dictionary items you will probably be exceeding the limits of what SQL is able to handle. I'd recommend first test with SQLSELECT first because if it doesn't work from a jshell then it will never work anywhere else. Daniel On Tue, Apr 3, 2018 at 9:10 AM, MChau <[email protected]> wrote: > 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.
