#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    5
    Rep Power
    0

    Exclamation Urgent Help- PostreSQL query to DB2 Query


    I need this VERY urgently.
    I am working on PostreSQL migration to IBM DB2.
    I have this query in PostgreSQL-

    CREATE DATABASE "CHIS Maintenance"
    WITH OWNER = postgres
    ENCODING = 'UTF8'
    TABLESPACE = pg_default
    LC_COLLATE = 'German_Austria.1252'
    LC_CTYPE = 'German_Austria.1252'
    CONNECTION LIMIT = -1;


    I want this in db2 sql syntax.
    Can anybody help?
    Thanks in advance!!!
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Location
    Katy, Texas
    Posts
    495
    Rep Power
    199
    Originally Posted by db2
    I need this VERY urgently.
    I am working on PostreSQL migration to IBM DB2.
    I have this query in PostgreSQL-

    CREATE DATABASE "CHIS Maintenance"
    WITH OWNER = postgres
    ENCODING = 'UTF8'
    TABLESPACE = pg_default
    LC_COLLATE = 'German_Austria.1252'
    LC_CTYPE = 'German_Austria.1252'
    CONNECTION LIMIT = -1;


    I want this in db2 sql syntax.
    Can anybody help?
    Thanks in advance!!!
    If you are in the mainframe, here's the syntax:
    http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_sql_createdatabase.htm

    If you are LUW, here's the syntax:
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
    Do you agree? Disagree? And remember, it's all about the reputation power...
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    5
    Rep Power
    0
    These are generic ones. I want the colaate using part and LC_Type. Also, Is there any syntax for connection limit?
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Location
    Katy, Texas
    Posts
    495
    Rep Power
    199
    What platform?
    Do you agree? Disagree? And remember, it's all about the reputation power...
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    5
    Rep Power
    0
    Window

IMN logo majestic logo threadwatch logo seochat tools logo