Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2016

    Unanswered: DB2 CREATE TABLE with COLLATE statement


    Do you know if there is a way to create a TABLE with columns with different collations (This is possible for example with SQL-Server)
    I didn't found anything about collate statement in CREATE TABLE documentation and nor any anouncement about it
    The goal is to easily show differences to students on sorting and grouping operations, depending on collation

    I work on DB2 11.010 for Z/OS

    thank you in advance

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    have you looked it up in infocenter db2/Z and create table... all info is over there...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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