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
