sql - DB2 Alias for Concatenated string in Select statement -

I am trying to make the following selection statement in the DB2 archive process:

  For C AS (SELECT o.id id, o.col1 col1, o.title title, o.locale locale, lower (desc1.detail1) CONCAT lower (desc1.detail2) CONCAT lower (desc1.detail3) CONCAT lower (desc1 .detail4) Description, lower (aspc 1d ct 1) || lower (aspc 1 dtt3) || lower (aspc 1dct4) abstract table_name from ONIIR = in the table = Open 1 SOMIID and o on dsc1 = desc1.id Include INNER table_detail absc1 o.id = absc1.owner_id and o.abstract = absc1.id OID = xid) DO   
 and taking the following error:  
  [IBM] [CLI driver] [DB2 / NT64] Data type "DESCRIPTION" for the SQL078 9N parameter or SQL variable is not supported in the regular, compound SQL statement or parameter list. A cursor value creator line number = ... SQLSTATE = 429BB   
 The problem is  low (desc1.detail1) CONCAT low (desc1.detail2) CONCAT low (desc1.detail3) CONCAT Low (Desc1.detail4) Description  line seems to be nickname  details  Sanam Not suitable for wires.  
 is for the same condition:  
  lower (asp 1 decay 1) || Lower (absc1.detail2) || Lower (absc1.detail3) ||  
 Thank you   
 
 
 If the description is a reserved word , Then rename it or put it in double quote.  
 You can also get a slightly better performance by using the bottom portion of your concatenated wire.    Less (a || b || c)