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.
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
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?
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"
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...