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

    Unanswered: create a new table in CLOB dbspace

    Hi All ,

    Can any one tell me how I can create a table in CLOB dbspace

    please share the sql program scripts.

    Thanks
    Prashant

  2. #2
    Join Date
    May 2008
    Posts
    35
    you have to create a sbspace by runnig

    onspace -c -S <SBSPACENAME> -p <PATH> -o <OFFSET> -s <SIZE in KB>
    (optionally add -Df <DEFAULTLIST-OPTIONS> to add logging and so on, depends on what you want to do).
    Afterwards, there are two ways:
    First , put the name you provided earlier in the SBSPACENAME - Parameter in onconfig (Instance restart required). Every CLOB you create will automatically be stored in that sbspace.

    Second, use "put" clause, see here:
    https://www.ibm.com/support/knowledg...s_sqs_0107.htm

Posting Permissions

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