Re: Long insert statement in PCC ireclen exceeded.
From: Tim Woodward <twood_at_windward.it.uswc.uswest.com>
Date: Fri, 20 Nov 1992 15:37:13 GMT
Message-ID: <By0u21.I5A_at_da_vinci.it.uswc.uswest.com>
Date: Fri, 20 Nov 1992 15:37:13 GMT
Message-ID: <By0u21.I5A_at_da_vinci.it.uswc.uswest.com>
In article <BxvLKB.4uC_at_inews.Intel.COM> kortikar_at_mipos2.intel.com (Aniruddha Kortikar) writes:
>I have a long insert statement in PRO*C insert into table ( ....) values (...)
>ireclen is exceeded.
>
>I tried
>char stmt[1000];
>sprintf(stmt,"insert into ... values (:v1,:v2);");
>exec sql execute s using :val1,:val2 ....
>but even then the exec sql execute s using is about 300 chars long.
>
Did you set IRECLEN=1000 (or whatever size is needed) on the precompiler invocation line?
Tim Woodward
U S WEST
Received on Fri Nov 20 1992 - 16:37:13 CET