Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


db2 maintains information about the data... a.in tables.
b.in a set of tables known as db2 catalog. c.in db2
database. d.none of the above. 1
What is the maximum number of tables that can be stored on a
Partitioned Table Space ? 1
what is contained in the DB2 node lock file? A) data base
names B) data base users names C) license keys D) server
names Accenture 5
Can a primary key have null values? If we try to insert a
null value in a primary key column, will it work or give an
error code? 6
When you are working with the project after coding what will
u do? Like what type of documents u will prepare? How will u
do testing? 2
how to delete perticular row from table for ex. how you will
delete 3rd row from table please answer THANKS IN ADVANCE IBM 7
max number of columns in a db2 table? 6
What is package versioning? Please give an example. 1
What is the picture clause of the null indicator variable? 6
How do you filter out the rows retrieved from a Db2 table ? 1
What is DB2 (IBM Database 2)? 3
Can any one tell me about Restart logic in DB2.

Answers were Sorted based on User's Feedback



db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog...

Answer / guest

que) can primary key have null values?
ans) no, primary key muse have the value (not null)

que)how to delete particular row from table.(3rd row)
delete from emp
where rowid=3

que)What is the picture clause of the null indicator variable?
ans) 01 sal-ind pic s9(4) usage comp
exec sql
select empno,sal
into :empno,:sal:sal-ind
from emp
where empno='e007'
end-exec.

Restart Logic...
- There is only one commit or rollback before termination of
transaction.
- suppose a application program is processing 1 million
records and the program abends at 90th thousand record. so
after restart of the program it is going to process all 90
thousand successfully but not committed records once again.
then this will became a problem..
- so when ever we are doing such huge updation we need to
use commit frequency properly. Let us say we have design
application commit frequency at 1000 record. If the program
abands at 1500 record it should get restart at 1001 record.
this is called as restart logic.
- for that create a temporary table with dummy record and
insert a record in the table for every commit with a key and
occurrence of the commit. this should happen just before the
issue of the commit.
- then the first paragraph from the procedure should read
last record from the table and skipped all the records that
are successfully processed and committed (1000th record).
After the processing of all the records, delete the entries
in the table and issue one final commit.


correct me if i am wrong
thanks














Is This Answer Correct ?    0 Yes 0 No

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog...

Answer / guest

que) can primary key have null values?
ans) no, primary key muse have the value (not null)

que)how to delete particular row from table.(3rd row)
delete from emp
where rowid=3

que)What is the picture clause of the null indicator variable?
ans) 01 sal-ind pic s9(4) usage comp
exec sql
select empno,sal
into :empno,:sal:sal-ind
from emp
where empno='e007'
end-exec.

Restart Logic...
- There is only one commit or rollback before termination of
transaction.
- suppose a application program is processing 1 million
records and the program abends at 90th thousand record. so
after restart of the program it is going to process all 90
thousand successfully but not committed records once again.
then this will became a problem..
- so when ever we are doing such huge updation we need to
use commit frequency properly. Let us say we have design
application commit frequency at 1000 record. If the program
abands at 1500 record it should get restart at 1001 record.
this is called as restart logic.
- for that create a temporary table with dummy record and
insert a record in the table for every commit with a key and
occurrence of the commit. this should happen just before the
issue of the commit.
- then the first paragraph from the procedure should read
last record from the table and skipped all the records that
are successfully processed and committed (1000th record).
After the processing of all the records, delete the entries
in the table and issue one final commit.


correct me if i am wrong
thanks














Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More JCL Interview Questions

Explain the purpose of dd * statement in jcl?

0 Answers  


Explain how can the attributes of one sms dataset be copied to another dataset?

0 Answers  


Suppose i have a file with 10 recs and i want to skip only the 7 th record and copy the rest into another file. How do i do it using SORT?

7 Answers   VS, Wipro,


can i sort packed decimal if i can tell the syntax

1 Answers   Barclays,


Explain COND used in JCL?

1 Answers   Patni,






At what stage, operator can change the class and priority of a submitted job?

2 Answers  


. What is the difference between the following statements : I) step#1 exec PGM=accpay ii) step#1 exec tbalance

1 Answers  


mainframe questions like basic&depth

0 Answers   TetraSoft,


what is alternate index?

1 Answers  


Matching Logic in Jcl not in cobol.Could any one please answer this question

0 Answers  


How do you create a temporary dataset? Where will you use them?

2 Answers   IBM,


How much space OS allocates when you create a PS or PDS?

4 Answers  






Categories