CODEWITHSUNDEEP
db2zosdb2-zos
Dave Ford
Dave Ford

Reputation: 363

CREATE TABLE LIKE in DB2 10 for z/OS throwing an error

Using DB2 for z/OS v.10, I'm getting an error when I specify a tablespace when using CREATE TABLE ... LIKE.

I can successfully use CREATE TABLE ... LIKE if I don't specify a new tablespace, but it throws an error when I specify a tablespace. The manual seems to say that this should work, but I must have an error in the syntax.

Create Table MySchema.Deleteme2
  Like MySchema.Deleteme;

Table MYSCHEMA.DELETEME2 created.

Create Table MySchema.Deleteme2
  Like MySchema.Deleteme
    in MYDB.SOMETS
;

THE STATEMENT COULD NOT BE PROCESSED BECAUSE ONE OR MORE IMPLICITLY CREATED OBJECTS ARE INVOLVED 1.

Any ideas?

Thank you for your help!

Dave

Upvotes: 0

Views: 472

Answers (1)

mao
mao

Reputation: 12267

Resolved by ensuring that the target tablespace was first created with the correct attributes and permissions, before running the create table .... like ... in ...

Upvotes: 1

Related Questions