Re: File size with varlen fields

[Alan Campin <alan0307d@xxxxxxxxx>]

When you defined the VARLEN you did something like this?

A R RECORD1
A    FIELD1 32000A VARLEN(1024)

FIELD1 is defined as a variable-length field with a maximum length of 100
and an allocated length of 30. FIELD2 is defined as a variable-length field
with a maximum length of 200 and no allocated length.

On Tue, Sep 14, 2010 at 6:20 PM, Albert York <alfromme@xxxxxxxxx> wrote:

> 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 Request  Date: 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.
> --
> 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.