>Hi All,
>
>Is there a limit to the number of fields a view can handle, in this case 40?
>If I increase the size of the table/view to 41 fields, regardless of name or type, and then use SCATTER/GATHER MEMVAR, any action on the view thereafter, such as SKIP, generates a 'SQL: Statement too long' error. Same with SCATTER/GATHER TO/FROM ARRAY. If I use REPLACE v_fieldname WITH m.variable, and run through it that way, it works fine. It just doesn't seem to like GATHER MEMVAR.
>
>Any idea why?
>
>Thanks.
>
>Luke

See SYS(3055, nn)

Issuing SYS(3055, 2040) should resolve it.

Walter,