#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. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    Originally Posted by db2
    I am not able to understand what is this {Region} and {PeriodReceived}.
    That is not valid Postgres syntax.

    I guess those are placeholder replaced by whatever programming language you are using.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    5
    Rep Power
    0
    Thanks for ur response.
    I learnt that after more search work that these are placeholders.
    Could you please help me my new doubt? Could you please help me convert above query in DB2

    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;

IMN logo majestic logo threadwatch logo seochat tools logo