insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 8299In 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 16112I 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.
2744what 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 11120OUTER 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 5951Post New Syntel DB2 Interview Questions
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?
Describe the (status) flag register of 8085?
What is Nothing in Scala? What is Nil in Scala? What is the relationship between Nothing and Nil in Scala?
What is well formed xml?
Difference betweek javascript, jquery and angularjs?
what is the thickness tolerances up to 32 mm
How to prevent client side validation from the ASP.NET validation controls?
what are the main functions of project img?
Can you define oozie?
X is a solid having a white colour at room temperature. It has a density about 2g/cc. Although it has melting point near 325 degree Celsius, its properties start degrading above 260 degree Celsius. The coefficient of friction is very low about 0.1. It has very good dielectric properties especially at higher radio frequencies. It has a very high bulk resistivity. It is chemically inert. It is also resistant to van der Waals force. It is hydrophobic as well as lipophobic. Creep or ‘Cold Flow’ has been observed in X.
How do you access an element in an HTML document with JavaScript?
Where do raw materials for manufacturing ayurvedic medicines come from?
What is the use of media setting?
Where is activex located on my computer?
Bpc for nw need to install .net application server and web server or not?