Talend community forum / Strange characters at the beggining of a field when using AS400 output

cho7 · 2008-12-16 21:09:27

Tags: [as400, bug, character, database, line, size, tos3.0.0]

Hi,

I'm new in TOS world, and since yesterday i'm doing a lot of jobs in order to enhance my knowledge of the product. Now, i'm trying to output some data read from a position delimited file into an AS400 table (in order to save me a lot of time at work)

Between the file input and the DB output, I simply modify the line in order to truncate the 200 first characters (with the substring java function) and I submit the whole line as a single field in a new table (drop if exists)

In the log, my lines are good, their size is 601 bytes (which is OK), but on the AS400 side, lines appears to have 603 bytes ! I can see 1 or 2 extra characters at the begining of the field, which is very strange.

The same file transfered using iSeries software is good at the end, so I don't understand what I'am doing wrong.

Thank you for your help.

ps : i'm using the "translate binary=true" option

edit : oh, and ofcourse if I do a substring(201) instead of substring(200) on the row, the garbage character is still there, but the first real character of my string is now truncated :-/

Uploaded Images

Last edited by cho7 (2008-12-16 21:12:33)

cho7 · 2008-12-17 13:40:13

Hi again,

this morning I tried to split my column into several field in the database, and on the AS400 side now I've got an extra character in front of *each* field !

It really sounds like bug of the AS400Output component, isn't it ?

ps :
Version: 3.0.2
Build id: r20205-20081119-1100

chris doudet · 2008-12-17 13:51:05

hi,
no prbm for me
test a more simple job,
generator>as400output

cho7 · 2008-12-17 14:12:35

[off topic]
Very weird...I also notice that when I declare one of my position field as "Integer", I've got some "For input string" errors (and the incriminated lines are dropped somewhere in the middle of nowhere), and if I declare my field as Long, I've got now a truncated Error launched by the AS400 Output... Even my tSchemaCompliance don't catch this (and it's logical, i'm in positional, not in delimited mode, so I KNOW my field is 15 characters long...)
[/off topic]

Anyway, I can't do all the tests I'd like, because each time I do a change, I have to ask some people to check my data in the AS400, kinda boring for them !

My first attempt was pretty simple, and I already had this character. Now, i'm not truncate anymore my file, because I have put a tMap in which I drop the first field (which is 200 characters long !) cf picture above.

[img=http://img223.imageshack.us/img223/7085/as400errorpz7.th.jpg]

Last edited by cho7 (2008-12-17 14:16:19)

cho7 · 2008-12-18 10:05:32

Argh... I give up... I tried everything i could, and this damned character is still in front of each of my columns !

Announcement

Unanswered posts

#1 2008-12-16 21:09:27

Strange characters at the beggining of a field when using AS400 output

#2 2008-12-17 13:40:13

Re: Strange characters at the beggining of a field when using AS400 output

#3 2008-12-17 13:51:05

Re: Strange characters at the beggining of a field when using AS400 output

#4 2008-12-17 14:12:35

Re: Strange characters at the beggining of a field when using AS400 output

#5 2008-12-18 10:05:32

Re: Strange characters at the beggining of a field when using AS400 output

Board footer