what is the difference between adding keys & constraints
into a phisical file
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 to update physical file using logical file with example?
Can we concatenate fields in physical file? If yes how can we do?
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?
what is open data base command
1 Answers Active Brains, Cognizant, CSC, CTS,
what is general and type of general
What is open data path?
What is open data path? And what is the difference between access path and open data path?
In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.
What is the purpose of the chain and setll and setgt?
What is the interactive job? What is the batch job?
How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?
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.