Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on SQL of a table (any object) within the DB2 forums, part of the Databases category; What is the command to view the sql script of a table or any other object which is in the database....
|
|||||||
|
|||
|
Re: SQL of a table (any object)
If you are using mainframes and if utilities installed like FILE-AID or CA-Platinum tool, you can find it easily using DDL option as a line command.
If you are using DB2 on linux/AIX use db2look command. If you are using DB2 on Windows, right-click on table or any other object and select "Generate DDL" option. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how QTP indentifies the object plz provide me all the ways of identifying the object | dasiga | QTP | 12 | 03-25-2009 07:13 AM |
| question about of the design of fact table and dimension table | joseluiselaprendiz | Data Warehousing | 0 | 09-05-2008 06:39 PM |
| WinRunner not identified object , what 2 do other than virtual object wizard method. | jayant_gajbhiye | WinRunner | 6 | 10-16-2007 07:23 AM |
| Subtract dimenstion object from measure object | jgd.ramesh | Data Warehousing | 0 | 09-29-2007 02:11 AM |
| Adding dropdown and table objects to Object Repository | praveenchandupatla | QTP | 0 | 08-02-2007 08:54 AM |