logo  
Google
 

DB2 SQL-Error: -874

SQLState: 53091

Short Description: THE ENCODING SCHEME SPECIFIED FOR THE MUST BE THE SAME AS THE CONTAINING TABLE SPACE OR OTHER PARAMETERS

If CCSID ASCII was specified, then the containing table space is EBCDIC or UNICODE. If CCSID EBCDIC was specified, then the containing table space is ASCII or UNICODE. If CCSID UNICODE was specified, then the containing table space is ASCII or EBCDIC. The encoding scheme of a table must be the same as the table space which contains the table. If a table is created using a fullselect, then the following must be the same: v The encoding scheme of the result table of the fullselect v The encoding scheme in the CCSID clause (if specified) v The encoding scheme of the target table spaceSystem action: The statement cannot be executed. Programmer response: Correct the SQL statement.

 <-  BACK TO INDEX