DB2/400 – Source Physical File Deletion?
I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted. Please correct me if I ma wrong in this? If I am right please tell me the way to restrict the deletion of source physical file.
Thanks & Regards
Bibin George
Software/Hardware used:
Software/Hardware used:
ASKED:
May 12, 2009 2:19 AM
UPDATED:
May 12, 2009 1:55 PM
Answer Wiki:
One more question related to same, If i create a physical file with same name as that of source physical file "QDDSSRC" in "QCLSRC" source file. Then what will happen?
To see all answers submitted to the Answer Wiki: View Answer History.
Hi,
It sounds to me like you’re confusing members with files.
A file name is unique within a library – ie you can only have one QDDSSRC file in a specific library, you can have other QDDSSRC files in other libraries. Within a file the member name is unique, ie you can only have one member called QDDSSRC in file QDDSSRC, you can have many other members within your QDDSSRC file.
You can create a member called QCLSRC in a file called QDDSSRC, this will have no effect on an existing QCLSRC file.
If you try to create a file that already exists you will receive an error message. If you try to add a member that already exists you will also receive an error message.
It doesn’t matter whether a file is a physical file or a source physical file (this is really just an attribute of a file – source or data) – the rules apply regardless.
Regards,
Martin Gilbert.