Q:
Diff. between PF and a sql table
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.....
ASKED:
Sep 25 2009 8:35 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
+2
Click to Vote:
+2
Click to Vote:
- 2
0
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
