Informix Sql Error Sqlstate 42000
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up update query statement in informix [closed] up vote 0 down vote favorite I would to get help https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.em.doc/errors.html from you all regarding my sql statement in Infomix.Please find my code below.I'm joining 5 tables and link with the primary keys. what I need is, I have to update export_flag column to Y based on the export_flag='N' and country='MA'. But right now i'm hitting a syntax error like this 13:34:12 [UPDATE - 0 row(s), 0.000 secs] [Error Code: -201, SQL State: 42000] A syntax error has occurred. I couldn't find where http://stackoverflow.com/questions/14930237/update-query-statement-in-informix could be the problem in my SQL. update a set a.export_flag ='Y' FROM sc_ob_temp_audit AS a JOIN sc_ob_allocation AS b ON a.sc_ob_profile_code = b.sc_ob_profile_code AND a.sc_orig_country= b.sc_orig_country OUTER JOIN sc_fac_group AS f ON b.sc_orig_country = f.sc_orig_country AND b.sc_orig_sf_group_code = f.sc_fac_group_code OUTER JOIN sc_ob_prod_group AS d, JOIN gbl_produce AS e ON d.sc_prod_cont_code = e.gp_cnt_cd AND b.sc_orig_country= d.sc_orig_country AND b.sc_prod_cont_group_code = d.sc_prod_group_code WHERE a.sc_orig_country ='MY' AND a.export_flag='N'; sql hibernate informix share|improve this question edited Feb 18 '13 at 5:51 mithunsatheesh 15.6k104171 asked Feb 18 '13 at 5:47 suga 57139 closed as not a real question by Mitch Wheat, Steven Penny, Lipis, bobs, Ram kiran Feb 19 '13 at 2:49 It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question. -> OUTER JOIN sc_ob_prod_group AS d, JOIN gbl_produce AS e –Mitch Wheat Feb 18 '13 at 5:50 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote Informix does not support that sort of UPDATE with JOINs — see th
from GoogleSign inHidden fieldsSearch for groups or messages
from GoogleSign inHidden fieldsBooksbooks.google.com - IBM® Informix® is a low-administration, easy-to-use, and embeddable database that is ideal for application development. It supports a wide range of development platforms, such as JavaTM, .NET, PHP, and web services, enabling developers to build database applications in the language of their choice....https://books.google.com/books/about/IBM_Informix_Developer_s_Handbook.html?id=eprEAgAAQBAJ&utm_source=gb-gplus-shareIBM Informix Developer's HandbookMy libraryHelpAdvanced Book SearchBuy eBook - $0.00Get this book in printAmazon.comBarnes&Noble.comBooks-A-MillionIndieBoundFind in a libraryAll sellers»IBM Informix Developer's HandbookWhei-Jen Chen, Krishna Doddi, Manoj Ghogale, David Jay, Javier Sagrera, IBM RedbooksIBM Redbooks, Jan 17, 2011 - Computers - 510 pages 1 Reviewhttps://books.google.com/books/about/IBM_Informix_Developer_s_Handbook.html?id=eprEAgAAQBAJIBM® Informix® is a low-administration, easy-to-use, and embeddable database that is ideal for application development. It supports a wide range of development platforms, such as JavaTM, .NET, PHP, and web services, enabling developers to build database applications in the language of their choice. Informix is designed to handle RDBMS data and XML without modification and can be extended easily to handle new data sets.This IBM Redbooks® publication provides fundamentals of Informix application development. It covers the Informix Client installation and configuration for application development environments. It discusses the skills and techniques for building Informix applications with Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate.The book uses code examples to demonstrate how to develop an Informix application with various drivers, APIs, and interfaces. It also provides application development troubleshooting and considerations for performance.This book is intended for developers who use IBM Informix for application development. Although some of the topics that we discuss are highly technical, the information in the book might also be helpful for managers or database administrators w