|
The easiest way to do this is to use Operations Navigator, Database, click on a library and do a right mouse and select new table. You now have a GUI to build the table. When you are done building, click the Show SQL and you have all your SQL. The later the version of Client Access the better. Best if V5R4 but V5R3 ok. I build all my tables in the GUI, even DDS now. I just extract the DDS from SQL table.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.