Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JoaoMendes
- Order by date
-
if then drop table
Thanks for your answer Shriyan, but i think i did not give you all the elements. Suppose that i want to do if then drop in an automated way(like a SP-but i believe SP can't drop tables :-( ). Is it possible? My problem is that i might have several tables that i want to drop and i can't be sure...- JoaoMendes
- Post #3
- Forum: Informix solutions
-
if then drop table
Hi Can I in Informix do something like this if ExistsTable( 'table1' ) then drop table table1; end if; Regards- JoaoMendes
- Thread
- Replies: 3
- Forum: Informix solutions
-
Avoid Long Transactions
Hi ! I have a query that inserts several hundreds of thousands of recors in a table and i get this error-long transaction aborted. Is there a way to avoid this? Is there an automated way of breaking the insert in several smaller pieces(by the way, removing the transactions in the database is...- JoaoMendes
- Thread
- Replies: 2
- Forum: Informix solutions
