10 pts.
 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.....

Software/Hardware used:
ASKED: September 25, 2009  8:35 PM
UPDATED: October 9, 2009  2:13 AM

Answer Wiki:
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
Last Wiki Answer Submitted:  October 9, 2009  2:13 am  by  CharlieBrowne   33,730 pts.
All Answer Wiki Contributors:  CharlieBrowne   33,730 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _