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.Loon AT
> KLM DOT 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.post AT plcs DOT nl
+31 6 248 21 622
|