|
View previous topic :: View next topic
|
| Author |
Message |
nag.kolli
New User
Joined: 20 Apr 2007
Posts: 5
Location: Hyderabad
|
|
|
|
1. I am having two pgms a,b
a will delete all the records in the file.
b will read all the deleted records.
I have scheduled two jobs in CA7
what does b will do?
2. I am having a lot of indexes in my pgm and the performance has been reduced due these indexes .
i..e of which sql statement?
3. FBA MEANS ? |
|
| Back to top |
|
 |
murmohk1
Senior Member
.jpg)
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
Nag,
| Quote: |
I am having two pgms a,b
a will delete all the records in the file.
b will read all the deleted records.
I have scheduled two jobs in CA7
what does b will do? |
Will do nothing. Can you read cannot read deleted records. I assume DELETION is a physical deletion not a logical one.
Go thru the prev post -
ibmmainframes.com/about5034.html |
|
| Back to top |
|
|
Ajay Baghel
Active User
.jpg)
Joined: 25 Apr 2007
Posts: 206
Location: Bangalore
|
|
|
|
RECFM=FBA
If given in jcl, will cause 1byte carriage return control character to be written in first byte of the data record. Actual data will start from 2nd position onwards. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Are you sure you have quoted the interview question correctly?
| Quote: |
2. I am having a lot of indexes in my pgm and the performance has been reduced due these indexes .
i..e of which sql statement? |
Programs do not "have indexes"; tables have indexes. If you have a performance issue due to indexes it may be the insert/delete (or certain types of select) that are affected. Insert and delete must create and remove all of the index entries for that row. |
|
| Back to top |
|
|
|
|
