insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9763In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
8 19010I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
3218what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
2 12450OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
1 6766Post New Syntel DB2 Interview Questions
What are the template tags in WordPress?
Is anything faster than c?
How to use limit in hibernate query?
please send the last 5 years {{{JUNIOR ENGINEER - ELECTICAL, ELECTRONICS RRB CHENNAI}}} TECHNICAL question papers TO MY EMAIL ID pushpapappu@yahoo.co.in
What is .net framework & its benefits?
What do you mean by table control???Where will we use this?
my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also
What's java swing?
How to use of return keywords in python?
How do I configure jms security? : BEA Weblogic
What is Java Pool in Oracle?
name the components of report net?
What is a dom in jquery? How can we make sure that dom is ready?
Should I use mbr or gpt?
How equipment master is integrated with asset master in fi module?