<http://schema.org/articleBody>
" For that error SQL0153 [sqlcode -153], the resolution is to give the expression a name. The CREATE TABLE needs to have a name for each column that will be created, and as the message suggest, the SELECT list includes an expression without an AS-name clause. Variants of the following would suffice: create table wrk/counter as ( select cat# , CHAR_LENGTH(STRIP(CAT#)) AS CatLen /* Use AS clause to name col; either System or Alternative name */ from ... create table wrk/counter ( catnbr, CatCharLength ) /* use..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201402/msg00132.html>