insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9780In 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 19028I 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.
3222what 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 12460OUTER 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 6770Post New Syntel DB2 Interview Questions
What is Master (access point) mode?
How you contact or initiate communications with customers?
What is the difference between react components extend, createclass and mixins, hocs?
What is Extensible Markup Language?
describe the cell theory & discuss the parameters for cell differentiation
Can the query output be sorted by multiple columns in oracle?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is a view cursor?
Can varchar be primary key?
1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?
List out some of the air commands used in abintio?
what is schema of broker?
what is difference between dry and flooded type chiller?
Explain me does de-activated plugins slow down a wordpress site?
Is linkedlist thread safe in java?