Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2015
    Posts
    5

    Unanswered: Creating ebcdic table with graphic type column

    I want to know whether I can create a table with column types graphic or vargraphic on ebcdic tablespace ? Facing sqlcode - -879. My platform is db2 zOS. Anyway to do this ?

    Thanks
    Last edited by paresh89; 08-19-15 at 07:15.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have you looked up the sqlcode ?
    stating :...when the MIXED DATA installation option is set to NO.
    have you checked this setting
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jun 2015
    Posts
    5
    Quote Originally Posted by przytula_guy View Post
    have you looked up the sqlcode ?
    stating :...when the MIXED DATA installation option is set to NO.
    have you checked this setting
    Where we can check this MIXED DATA installation option ? Can you please guide.
    Thanks

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    why do you think has IBM created the doc and infocenter ?
    to help you to find all information YOURSELF.... without having to ask each setting to the forum....
    google : db2 infocenter z 10.1
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    +1. or you could ask your DBA who would know or would look up the item in the doco
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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