So, what does it 'tell' you? C'mon, this is not that hard.
Dan On Thu, Jan 21, 2010 at 6:21 PM, Vlad <[email protected]> wrote: > Of course it tells. It was just a reply to Mr.Jai Jagadish, suggesting > to replace dots with underscores. > Anyway, It seems that SQLSELECT doesn't like dots in field names. > > On Jan 21, 3:56 pm, Daniel Klein <[email protected]> wrote: >> Parse Error: unable to access dict column: CUSTOMER_NO. >> >> Doesn't that tell you something? >> >> DanOn Thu, Jan 21, 2010 at 3:35 AM, Vlad <[email protected]> wrote: >> > Underscore does not work. CUSTOMER_NO >> >> > Error in Statement "SELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER_NO = >> > '100300'" >> > Parse Error: unable to access dict column: CUSTOMER_NO. >> >> > --- >> > RELEASE Information : Major 5.0 , Minor 16 , Patch 0323 >> > (Change 78410) >> > System : AIX 6.1.2.0 >> > --- >> >> > On Jan 20, 5:58 pm, Jai Jagadish <[email protected]> wrote: >> >> Hi Mujtaba, >> >> >> Find below the Query : you need to replace ' . ' by Underscore ' _ >> >> ' >> >> in SQL Queries.. >> >> >> SQLSELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER_NO LIKE 100300 >> >> >> this will work . >> >> >> Regards, >> >> >> Jai Jagadish >> >> >> On Wed, Jan 20, 2010 at 4:37 PM, Mujtaba Khan <[email protected]> >> >> wrote: >> >> > Hi, >> >> >> > can any one Help i am also stuck up at >> >> >> > jsh ~ -->SQLSELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER.NO LIKE 100300 >> >> > Error in Statement "SELECT * FROM FBNK.CUSTOMER WHERE CUSTOMER.NO LIKE >> >> > 100300" >> >> > Parse Error: unrecognized alias. >> >> >> > On Thu, Aug 7, 2008 at 10:24 PM, Daniel Klein >> >> > <[email protected]>wrote: >> >> >> >> On Thu, Aug 7, 2008 at 11:59 AM, Sankararam K >> >> >> <[email protected]>wrote: >> >> >> >>> Hi All, >> >> >>> I was trying to run this command from jsh >> >> >>> SQLSELECT MAX(OVDATA) FROM F.FSMD.OVERDRAFT >> >> >>> and was getting Parse error:.. >> >> >>> Any Ideas how to get rid of this error. >> >> >> >>> Thanks for the Help >> >> >> >>> Cheers >> >> >>> Sankar >> >> >> >> SQLSELECT offers limited SQL functionality and one of those 'limits' is >> >> >> that it does not support using functions against the data. >> >> >> >> Dan >> >> >> >> --~--~---------~--~----~------------~-------~--~----~ >> >> >> Please read the posting guidelines at: >> >> >>http://groups.google.com/group/jBASE/web/Posting%20Guidelines >> >> >> >> IMPORTANT: Type T24: at the start of the subject line for questions >> >> >> specific to Globus/T24 >> >> >> >> 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 >> >> >> -~----------~----~----~----~------~----~------~--~--- >> >> >> > -- >> >> > Please read the posting guidelines at: >> >> >http://groups.google.com/group/jBASE/web/Posting%20Guidelines >> >> >> > IMPORTANT: Type T24: at the start of the subject line for questions >> >> > specific to Globus/T24 >> >> >> > 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 >> >> > -- >> > Please read the posting guidelines >> > at:http://groups.google.com/group/jBASE/web/Posting%20Guidelines >> >> > IMPORTANT: Type T24: at the start of the subject line for questions >> > specific to Globus/T24 >> >> > To post, send email to [email protected] >> > To unsubscribe, send email to [email protected] >> > For more options, visit this group >> > athttp://groups.google.com/group/jBASE?hl=en > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions specific > to Globus/T24 > > 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 > -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 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
