RE: SQL update make fields match

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

> "Frogger Array Template..." 
> 
> Huh?
> 
> Where are you running these statements?

RUNSQLSTM from command line.

>From joblog:

MCH1869    Escape                  40   06/22/05  11:04:48.283272  ExSndPm
000000   QQQQUERY    QSYS        *STMT

To module . . . . . . . . . :   QQQQUERY

To procedure  . . . . . . . :   QQQQUERY

Statement . . . . . . . . . :   16186

Message . . . . :   Frogger Array Template had an error,  The error type is

  24.

Cause . . . . . :   An error was found in Frogger Array Template with an

 identifier X'0002'. The error type is 24, the current frogger range number

 is 1, and the current bound number is 1. The low/high bound indicator is 0,

 (0=low 1=high). The selection template identifier is located in the header

 of each selection template and is used to distinguish between the multiple

 selection templates that are allowed for any particular data space. The

 error type definitions follow: Error         Definition -----

 -------------------------------------- 01 -- number of bytes is too small
02
 -- number of frogger ranges is zero 03 -- Invalid reserved area 04 --
number
 of key fields is zero 05 -- number of key fields exceeds the number of
index
key fields 06 -- Invalid reserved area in frogger range 07 -- key field     
cannot be severed 08 -- low bound end truncation position is larger than key
field 09 -- high bound end truncation position is larger than key field 10  
-- one bound specifies is not null and the other specifies is null. 12 --   
bound is null indicator contains an invalid value 13 -- bound infinity      
indicator contains an invalid value 14 -- bound exclusion indicator contains
an invalid value 15 -- bound location value is invalid 16 -- bound position 
value is invalid 18 -- bound reserved area not all zeros 19 -- bound        
datatype does not match key field datatype 20 -- global literal list        
template not provided 21 -- invalid datatype for dynamic substring selection

And that's the end of that particular message.