Re: Long insert statement in PCC ireclen exceeded.

In article <By0u21.I5A_at_da_vinci.it.uswc.uswest.com> twood_at_windward.it.uswc.uswest.com (Tim Woodward) writes:
> 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
This may not help. As far as I know the ireclen has an upper bound < 200 chars. However, you could always compose the statement using several steps so that no line is longer than say 132 chars (or even 80 chars for readability).

Hope this helps.

--
                         
    ___           _____2
   /   )  /  /   /        Richard H. E. Eiger
  /_ _/  /__/   /__       Ing. Informatik HTL
 /\     /  /   /          Unregistered NeXT fan
/  \   /  /   /_____      rheiger_at_renext.open.ch (NeXT mail welcome)