09-30-2002, 08:16 AM
I'm trying to run the CPYTOIMPF to comma delimit a file with 391 fields and 2706 record length. I'm taking defaults on all parameters, except for the from and to files. The to file is defined as a flat file with record length 5000. I'm getting the following error message. Message ID: SQL0101 "SQL Statement too long or too complex" Reason code 2 - The total number of columns, constants, and operators is greater than the SQL limits. Has anyone seen this and or know about a solution? Thanks in advance.