Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
321977 I pic 99 value 5 Perorm para-A I times. Para -A. move 10 to I. How many times the para-A will be executed.?
TCS,
9 13204Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
1 8964Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
IBM,
2 7210suppose there is one PF having two members PF1 PF2.PF has one unique key Emp ID.could you tell me uniqueness in PF will be effective across members as well ? assume emp iD 3333 is in member PF1 would same Emp id be exist also in member PF2 ?
2 7363do we need to mention the location of catalogued procedure for each it's call in a single job?
1 5430Plan has the optimized access path in it. But is that optimized access path is attained or known
IBM,
1 4646
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
What is the information associated with sysibm.syslinks table?
What is control interval?
Explain how many conditions can you include in a single handle condition command?
Define RCT.
How can we retrieve the total number of records in RPG & CLLE?
Why is free space left in ksds dataset?
What is a base cluste?
What is dl/i?
Explain the difference between a schema and a subschema in idms?
What is host variable in db2 cobol?
What is catelog procedure and how many catelog procedure to use in one job?
What is the meaning of a (new, catalog, keep) disposition mean?
explain sorting techniques in cobol program?
Define concatenating?