Re: File size with varlen fields

[Albert York <alfromme@xxxxxxxxx>]

I did that (only I used RPG). The field size looks okay:

..+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0

 ±CallableStatementCallback; uncategorized SQLException for SQL ¢{call XDISVC.
 08C8998898EA8A8989AC899888954A988A88998A884EDDCA889A89948994EDD44C88994ECCEEC4
 2F3133123523135455331332132E045313576999540283573573965066902830A031330749253B

 à/xtime/output/x000045301.out HTTP/1.1 400 Bad RequestDate: Fri, 06 Aug 2
 046AA89869AA9AA6AFFFFFFFFF49AA004CEED6F4F4FFF4C884D89A8AA02C8A874C9864FF4CA84F
 14173945164374317000045301B643000833711B10400021409584523D54135A0699B006014702

 ±CallableStatementCallback; uncategorized SQLException for SQL ¢{call XDISVC.
 08C8998898EA8A8989AC899888954A988A88998A884EDDCA889A89948994EDD44C88994ECCEEC4
 2F3133123523135455331332132E045313576999540283573573965066902830A031330749253B

On Tue, Sep 14, 2010 at 4:30 PM, James Perkins <jrperkinsjr@xxxxxxxxx> wrote:
> Make sure the data being inserted into the table is trimmed. You can run an
> SQL statement over it to trim up the long field and see if that's the issue.
>
> UPDATE your_table
> SET long_field = TRIM(long_field)
> --
> James R. Perkins
>
>
> On Tue, Sep 14, 2010 at 16:03, Albert York <alfromme@xxxxxxxxx> wrote:
>
> > I have a very long field (32000 bytes) that I defined in a file using
> > varlen. Most of the time the field will be around 1 K but sometimes it
> > could be 32000 bytes.
> >
> > When I look at the file size it shows 1.357 GB for 44180 records. When
> > I look at the records the field size for that field looks correct.
> >
> > Why is the file so large?
> >
> > Thanks,
> >
> > Albert
> > --
> > This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.