you’re missing the from clause of your sql statement. > Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM > <eric-van.l...@klm.com> het volgende geschreven: > > Hi guys! > I'm trying to select all ANE4987E messages for all nodes with the text > 'Component Team Windows' in the contact field. For some reason I cannot get > the SQL statement to work. What am I doing wrong? > > select actlog.date_time, actlog.nodename, actlog.message, nodes.node_name, > nodes.contact where nodes.contact like 'Component Team Windows%%' and > actlog.nodename=nodes.node_name and actlog.msgno=4987 > > ANR2905E Unexpected SQL identifier token - 'NODESVIEW.CONTACT'. > > | > .......................V....................................... > ODESVIEW.CONTACT where NODESVIEW.CONTACT like 'Component Team W > > ANS8001I Return code 3. > > Thank you very much for your help in advance! > Kind regards, > Eric van Loon > AF/KLM Storage Engineering > ******************************************************** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain confidential > and privileged material intended for the addressee only. If you are not the > addressee, you are notified that no part of the e-mail or any attachment may > be disclosed, copied or distributed, and that any other action related to > this e-mail or attachment is strictly prohibited, and may be unlawful. If you > have received this e-mail by error, please notify the sender immediately by > return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission of > this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ********************************************************
-- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
