Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions in DB2?
- 3 Answers
- 9428 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mainframe virumbi
the following functions ( Aggregate functions )applied on
the columns.
Count
Avg
Min
MAx
....
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / bhaskar reddy
the aggrigate function are
min, max, avg, sum, count
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the connection string to connect to the DB2 Database ?
What is package in db2 mainframe?
How many Buffer pools are there in DB2 and what are they?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Suppose if I need to update a column, how you do that using cursor?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
wht are the restrictions for union ?
What is Reorg Recovery? when will you run it?
Where do you specify them?
Which transaction use a command thread ?
COBOL 
