Re: File size with varlen fields

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.