Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    30

    Red face Unanswered: Dynamic SQL stmt to create table

    Hi All,

    Has anyone writen a script for generating dynamically create table statement.

    I am trying to make a dynamic sqlstatement by using syscat.columns, but couldnt got Luck

    All answers/Suggestions are welcomed.


    Regards,
    Pushp

  2. #2
    Join Date
    Nov 2003
    Location
    Jakarta, Indonesia
    Posts
    32

    Re: Dynamic SQL stmt to create table

    Originally posted by pushp
    Hi All,

    Has anyone writen a script for generating dynamically create table statement.

    I am trying to make a dynamic sqlstatement by using syscat.columns, but couldnt got Luck

    All answers/Suggestions are welcomed.


    Regards,
    Pushp
    There a command line utility called db2look (if you are using db2)

    example:
    db2look -d DBNAME -z SCHEMANAME -u USERNAME -e -c ;
    Regards,
    Adam Ac

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •