Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between adding keys & constraints
into a phisical file
- 4 Answers
- 11733 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kkk
Contraints check the existing data
But keyfields doesnot check the existing data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / praseetha sandeep
when we add keys in a pf it has effect only in that
particular field of pf but when we add constrains to a pf it
has an effect to entire pf
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / megha
1. Keyfileds are with in DB and constraits are added from
addpfcst command externally
2. Using Addpfcst you can maintain the referential integrity
| Is This Answer Correct ? | 2 Yes | 0 No |
how can i know logical file belongs to which physical file without source?
What is the use of member in pf?
How to know logical file belongs to which physical file without source?
what is open data base command
1 Answers Active Brains, Cognizant, CSC, CTS,
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.
I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?
how to restrict upon adding the data for field reference file in DB400
how to know total no of records in pf with out using sql??????
How to find the list of source physical files in a library?
When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why
What is the batch job?
RPG400 
