It's not a 'sneaky question'. It uses the Socratic Method to stimulate rational thinking, of which Pat Pogson is the Master.
Your reply is too restrictive. The 'solution' is whatever needs to be done. So if you have to change the dots to underscores then you also need to make sure the new dictionary item exists. Dan If you can solve your problem, then what is the need of worrying? If you cannot solve it, then what is the use of worrying? -- Shantideva On Fri, Jan 22, 2010 at 8:35 AM, Vlad <[email protected]> wrote: > It tells me the parser could not find CUSTOMER_NO item in file > dictionary, and changing dots into > underscores does not solve anything.. And what's your point with such > sneaky questions? Do you have a solution (but not the one of adding > new dict pointers without dots)? > > On Jan 22, 1:38 am, Daniel Klein <[email protected]> wrote: >> 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 >> > 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
