insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 8351In 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 16191I 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.
2757what 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 11162OUTER 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 5982Post New Syntel DB2 Interview Questions
How many methods of bdc are there?
What are the best practices for devops implementation?
What is msil, il?
iam looking for te best business idea ihave a sspace of about 10thousand covered factory shed with equal amount of open space on the outskirts of mumbai checkpost dahisar the sopace is situated on the w.e. highways please sugest the best idea to do a business
Is int an object in c#?
what is a text table ?
how can be calibrate flow indication transmitter (rosemount) it shows excess milli amps nearly about 24 ma on full scale, but its scale was set on 20ma on full scale..???how can be simiulate..???
Describe the PCR contamination i.e contamination with degenerate primers?
What is unix used for?
What is servervariables collection in asp?
What is difference between .net and .net core?
What is appletviewer?
When should need to value a company using a revenue multiple vs. Ebitda?
How do you inspect a selection option?
What are the types of relationships applicable to salesforce?