Home > Informix Error > Informix Error Cannot Modify Table Or View Used In Subquery

Informix Error Cannot Modify Table Or View Used In Subquery

Read 16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Re: Update query with table reference in subquery (views: 382)Art Kagel -- Tuesday, 8 December 2009, at 6:24 a.m. Find the Infinity Words! What you have to do is something like UPDATE adm_rec SET cnsir_init = ( expression ) WHERE EXISTS (SELECT adm_rec.id FROM adm_rec, ed_rec, sch_rec WHERE adm_rec.id = ed_rec.id AND .... weblink

For MS SQL servers, such opertaion should be allowed; for MS Access for example not. –Arvo May 26 '11 at 10:06 possible duplicate of Error 360: Cannot modify table Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Join them; it only takes a minute: Sign up Error 360: Cannot modify table or view used in subquery up vote 2 down vote favorite INFORMIX-SE 7.32: I'm getting error 360

How to find positive things in a code review? One of the advances is that multiple rows (in the same or different tables) can reference the same smart blob. Go to Solution 5 Comments LVL 7 Overall: Level 7 Databases 3 Message Expert Comment by:jhp3332010-09-07 The correct query is: update audit1 set mks_prospectid = (select newclientid Read 13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ...

Read 3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Can I switch between two users in a single click? more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Bravo For Buckets!

Which Sitecore fields can be rendered using a FieldRenderer Are leet passwords easily crackable? Why aren't sessions exclusive to an IP address? Why was the identity of the Half-Blood Prince important to the story? Join our community for more solutions or to ask questions.

PS: The subquery means it is in DB2 database.... These resources can help you build awareness and prepare for defense. another query we use get the same err update mktngsurvey_bcs set mks_newclientid = (select newclientid from pro_bcs inner join I need to update table a (adm_rec) with the data from table s (sch_rec).

  1. Join our community for more solutions or to ask questions.
  2. two servers 24 31 3d SQL Database Mail Setup 1 13 5d SQL Server Piecemeal Restore Explained Article by: Yashwant This article explains all about SQL Server Piecemeal Restore with examples
  3. INFORMIX-SE 7.32: I'm getting error 360 when I try to execute the following statement: update transaction set transaction.colx = (select tab1.cola from tab1) where transaction.num = (select max(transaction.num) from transaction) and
  4. Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access...
  5. SQLState: IX000 ErrorCode: -360 Position: 73 Here is the code: update adm_rec set cnslr_init = (select sch_rec.cnslr_init from adm_rec, ed_rec, sch_rec where ed_rec.id = adm_rec.id and ed_rec.sch_id = sch_rec.id and adm_rec.cnslr_init
  6. Jun 21 '10 at 13:18 2 But the error is an Informix error, and Oracle would not raise any error for this SQL, it would work just fine. –Tony Andrews
  7. Resolving the problem INTRODUCTION Smart blobs (columns of type CLOB or BLOB) are more advanced than "simple" blobs (TEXT or BYTE datatypes).
  8. To follow along with this video, you can draw your own shapes or download the fileā€¦ Illustration Software Photos / Graphics Software Web Graphics Software Adobe Creative Suite CS Advertise Here
  9. FROM t ...); share|improve this answer edited Jun 21 '10 at 10:09 answered Jun 21 '10 at 10:02 Amarghosh 42.3k769105 So is there an alternative method for locating the

Sci-Fi movie, about binary code, aliens, and headaches Find and display best Poker hand How can I get a visa for India on a 2-day notice? http://members.iiug.org/forums/ids/index.cgi/read/18300 MS SQL Server Databases 5 Lessons the Delta Outage Should Teach Us About Datacenter Security and Disaster Prevention Article by: Concerto Cloud The Delta outage: 650 cancelled flights, more than 1200 Read 20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read 9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix...

Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode December 16th,05:22 PM #1 -360 Cannot modify table http://colvertgroup.com/informix-error/informix-error-956.php Read 2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... In version 11.50.xC2 the use of the same table in a subquery of a delete or update was greatly improved. Lunacy - what does it mean?

Here raw_str in my_table_view has reference to raw_str in my_table. Pact enables five-city smart meter pilot in Europe... Join & Ask a Question Need Help in Real-Time? http://colvertgroup.com/informix-error/informix-error-229.php If we simplify what you have there you get this ...

Move To Video Answer Error 360: Cannot modify table or view used in subquery Tags: sql informix By : FrankComputerAtYmailDotCom Source: Stackoverflow.com Question! sending to informix-list... Peter Land - What or who am I?

This same trick can be used to avoid error 360 with simple (non blob) data, and with earlier IDS versions like 7.x.

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation For other dbms (ORACLE Informix) you have to load subquery into temp which is your platform ? not in Informix SQL sintax. not in Informix.

Are D&D PDFs sold in multiple versions of different quality? Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Plausibility of the Japanese Nekomimi dired - sort and hide by default How to add line separators between columns in Latex table? this content UPDATE adm_rec SET cnsir_init = ( expression ) WHERE adm_rec.id = ed_rec.id ....

But a isn't joined directly with s, I have to join them via table e (ed_rec). Jun 21 '10 at 13:22 3 @Frank Why don't you run select max(transaction.num) from transaction first and use the value in the query. –Amarghosh Jun 21 '10 at 13:25 1 If, as I understand from other questions, you are primarily working with a single-user system, that will be safe enough. Thanks Omar.

Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We asked 5 years ago viewed 773 times active 5 months ago Blog Stack Overflow Podcast #91 - Can You Stump Nick Craver? sending to informix-list LUQUE Guest December 16th,08:53 PM #2 Re: -360 Cannot modify table or view used in subquery LUQUE Valdivia Omar wrote: What version of Informix? -- "C'est pas

Linked 50 How to create a temporary table in Oracle 3 Insert into temp values (select… order by id) 2 Error 360: Cannot modify table or view used in subquery Related Read 21 Mar 11 - Yahoo! Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Suggested Solutions Title # Comments Views Activity How to Select one or All record in a table using a form 3 43 109d Changing the order of columns 9 56 102d

Read 21 May 10 - CNET - IBM to help people monitor energy use... Because of the danger of entering an endless loop, this action is not allowed, except in the case of an uncorrelated subquery in the WHERE clause of the DELETE or UPDATE Is it legal to bring board games (made of wood) to Australia? Ciao Diego Sql server 2005 2008 update from: UPDATE B1 SET B1.PARAMETER_DS = 'UPDATED' FROM B_PARAMETERS B1 WITH(ROWLOCK) INNER JOIN (SELECT B2.* FROM B_PARAMETERS B2 WITH(NOLOCK) WHERE FAMILY_ID = 5 )

Read 14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... How do they lure the college crowd?...