Re: File size with varlen fields

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.