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

Informix Error Cannot Modify Table Or View Used In Subquery

Featured Post Threat Intelligence Starter Resources Promoted by Recorded Future Integrating threat intelligence can be challenging, and not all companies are ready. update my_table set flag = 'X' where raw_str = ( select raw_str from my_table_view where a_num in ( select num_id from num_table where state not in (0, 1, 7, 99, 10, This video shows the Mac version, but the tool works the same way in Windows. 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? navigate here

This same trick can be used to avoid error 360 with simple (non blob) data, and with earlier IDS versions like 7.x. What I think should work is this: update adm_rec set cnslr_init = (select s.cinit from adm_rec a, ed_rec e, sch_rec s where e.id = a.id and e.sch_id = s.id and a.cinit Solved Need to write Complicated SQL Update Query in Informix Posted on 2008-10-10 Databases MS SQL Server DB2 1 Verified Solution 10 Comments 3,041 Views Last Modified: 2013-12-24 I am trying Browse other questions tagged sql informix or ask your own question. navigate to this website

It also can import existing Access or SQL Server tables with relationships. sending to informix-list... Featured Post How to run any project with ease Promoted by Quip, Inc Manage projects of all sizes how you want.

  1. Browse other questions tagged sql or ask your own question.
  2. Read 19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto...
  3. another query we use get the same err update mktngsurvey_bcs set mks_newclientid = (select newclientid from pro_bcs inner join
  4. Best regards.
  5. Miller III STSM, Support Architect [email protected] 503-578-5645 IBM Informix Dynamic Server (IDS) = From: "PRADEEP KUMAR" = = To: [email protected] = = Date: 12/07/2009 10:16 PM = = Subject: Update
  6. F. create temp table audit1 ( id integer, mks_prospectid integer); insert into audit1 (id) values(1); insert into audit1 (id) values(2); insert into audit1 (id) values(3); create table client1 (
  7. When I need do it , I use to create a temp table with the lines pre-selected in the subquery and after that I use that temp table in the subquery.
  8. Pact enables five-city smart meter pilot in Europe...
  9. Read 22 Mar 12 - developerWorks - Optimizing Informix database access...
  10. Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?...

asked 6 years ago viewed 1492 times active 6 years ago Blog Stack Overflow Podcast #91 - Can You Stump Nick Craver? Ferronato Guest December 24th,02:32 AM #4 Re: -360 Cannot modify table or view used in subquery In my last message, I wrote: "The subquery means be a DB2 database", I did 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 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

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 Nest a string inside an array n times High School Trigonometric Integration Interaction between a predictor and its quadratic form? For other dbms (ORACLE Informix) you have to load subquery into temp which is your platform ? http://www.justskins.com/forums/360-cannot-modify-table-173849.html Join our community for more solutions or to ask questions.

Join the community of 500,000 technology professionals and ask your questions. All rights reserved. One of the advances is that multiple rows (in the same or different tables) can reference the same smart blob. Example This SQL inserts one image to a blob column, then attempts to link 4 more rows to the same smart blob: create table jpgs ( id integer not

The the section title in the release notes is called "Subquery support in update and delete statement" John F. If you were dealing with a multi-user system (like most people have to), then you'd have to be a lot more worried about the TOCTOU (time of check, time of use) Read 09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. But regardless, your solution would have worked if that option was on. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We

Read 8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... http://mttags.com/informix-error/informix-error-951.php What are cell phone lots at US airports for? The time now is 09:38 PM. 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

Join Now For immediate help use Live now! if statement - short circuit evaluation vs readability Farming after the apocalypse: chickens or giant cockroaches? Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... his comment is here Peter Land - What or who am I?

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 sql informix share|improve this question edited Jun 21 '10 at 10:08 Amarghosh 42.3k769105 asked Jun 21 '10 at 9:52 Frank R. 1,10111753 Why the Oracle and MySQL tags for MS SQL Server Advertise Here 775 members asked questions and received personalized solutions in the past 7 days.

What happens if one brings more than 10,000 USD with them into the US?

For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... (SELECT ... more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed 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 not in Informix SQL sintax.

Read 06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Roberto F. "LUQUE Valdivia Omar" wrote in message news:... Read 9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... weblink So here is the select SQL: select a.id, a.yr, a.cid, a.cinit, s.cid, s.cinit from adm_rec a, ed_rec e, sch_rec s where e.id = a.id and e.sch_id = s.id and a.cinit is

That WHERE clause is the problem, it's joining adm_rec to ed_rec and you can't do that in an update. I can do that in SQLServer and Access, why not in Informix? All rights reserved. Not the answer you're looking for?

Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe? But I am getting this error now: Error: Cannot modify table or view used in subquery. Read 21 May 10 - CNET - IBM to help people monitor energy use... Read 10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products.

Why was the identity of the Half-Blood Prince important to the story? Join the community of 500,000 technology professionals and ask your questions. dired - sort and hide by default Professional name different from legal name How to create a company culture that cares about information security? Read 2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service...

Read 27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read 17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Read 9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools...