RE: JAVA400-L Digest, Vol 1, Issue 631

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>although I got another problem now:
>When I execute 
>        stmt.executeUpdate("CALL MYPGM('parm1')";
>where 
>        parm1="xxxxxxxxxx               "
>it seems that the trailing spaces are left out at execution_time.... 
>
>The CL/RPG program receives: "xxxxxxxxxx???????????????"
>where ??...?? is 'rubbish' in stead of spaces.
>Because the application checks if that part is blank
>it goes wrong.
>
>To be complete, the parameter is in fact a bit longer 
>(first 15 chars are filled, next 350chars are a list
>of 10-35char fields which sometimes contain data, sometimes not!

This is because the command line (in this case stmt.executeUpdate()) does
not know what size to declare the literal 'parm1'.  See the FAQ at
http://faq.midrange.com for an explanation.  Search for 'garbage'.  The
search link is in the lower left corner.

My bet is that you will create a command instead of directly calling the
program.
  --buck