what is the maximum number of tables that can be joined ?
Answers were Sorted based on User's Feedback
Answer / vipin kumar verma
IN EARLIER VERSION OF DB2(DB2 V7)
15 Tables CAN BE JOINED AT A TIME
But in LATEST VERSION OF DB2(DB2 V8)
225 Tables
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / jitinder
IN DB2 V7
You can have the maximum upto 15 Tables
But in DB2 V8
You can have the maximum upto 225 Tables
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / ashish kumar(einstein)
u can have as many tables as u want
Is This Answer Correct ? | 6 Yes | 3 No |
Why select is not preferred in embedded sql programs?
How to fetch the uncommited data from table ?
In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is lock escalation in db2?
Mention and explain the contention situations caused by locks?
Write a query to retrive partial string.
What language is db2 written in?
How can you classify the locks in db2?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?