Diff. between PF and a sql table

10 pts.
Tags:
DB2/400
DDS
Physical File
SQL tables
can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are addition fuctions that can be done to a table created with SQL vs a PF created with DDS.
IBM statement of direction is there are no plans to add function to DDS in the future.
Here is a link to a web page that has a link on it to hear a pod case SQL vs DDS.

http://www.systemideveloper.com/sessionRoadMap.html

==========================================================

IMO, the major difference between the two is that data is verified a write-time for a SQL table and at read-time for a DDS PF. There are various other differences (e.g., you cannot add new members to a SQL table), but data integrity has to be at the top of the list. You aren’t allowed to write invalid dates to date fields, you won’t find non-numeric values showing up in numeric fields, etc.

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following