Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Folks ! Very Interesting !

    Hi Folks,

    This is a create table statement in DB2 z/ODS and OS/390 ( mainframe versions ) :

    create table test(sno int) IN DATABASE database1 AUDIT NONE DATA CAPTURE NONE

    This will create a table in the named database 'database1'.

    1) In SQL Server, is there any equivalent for this 'IN DATABASE' syntax in DB2 ?

    2) 'Data capture none' will not store any extra info about the data replication in the log files. Is there any eqiuivalent for this in SQL Server ?


    Thanks,
    Sam

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by SamCute
    Hi Folks,

    This is a create table statement in DB2 z/ODS and OS/390 ( mainframe versions ) :

    create table test(sno int) IN DATABASE database1 AUDIT NONE DATA CAPTURE NONE

    This will create a table in the named database 'database1'.

    1) In SQL Server, is there any equivalent for this 'IN DATABASE' syntax in DB2 ?

    PHP Code:
    use DatabaseNAme
    go
    create table test
    (sno int
    go 
    its the "use" statement u r looking for

Posting Permissions

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