Geeks Talk

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.

SQL of a table (any object)

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

Go Back   Geeks Talk > Databases > DB2
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 03-18-2009
Junior Member
 
Join Date: Mar 2009
Location: HYDERABAD
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Kshravank is on a distinguished road
SQL of a table (any object)

What is the command to view the sql script of a table or any other object which is in the database.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 05-07-2009
Junior Member
 
Join Date: Oct 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
satyender is on a distinguished road
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.
Reply With Quote
Reply

  Geeks Talk > Databases > DB2

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


All times are GMT -4. The time now is 02:48 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved