tLogRow not showing all characters in field

Six Stars

tLogRow not showing all characters in field

I have a CHAR(6) field in my schema.  I am using a tdbRow to execute INSERT statements to populate a temp table.  When I display my output via a tLogRow, I am only getting the first character on the field.  

 

For example:

 

INSERT INTO ACCTS (ACCT_ID,EFF_DT) VALUES('256874','2018-10-01')

INSERT INTO ACCTS (ACCT_ID,EFF_DT) VALUES('987414','2018-09-01')

 

The tLogRow_1 outputs:

|ACCT_ID|EFF_DT 
|=------+----------
|2 |2018-10-01
|9 |2018-09-01
'-------+----------+----------+----------'

 

Any ideas on why this may be happening?  I appreciate any help!

Ten Stars

Re: tLogRow not showing all characters in field

Dont know the database you are inserting data into but CHAR(6) should equals VARCHAR(6), change to this. CHAR(6) always (should) store 6bytes as VARCHAR(6) stores only the amount of bytes inserted ... switch !
Id=12
CHAR(6) '12____' <> VARCHAR(6) '12' (3bytes)

 

In bytes varchar stores an extra byte...
If you only store number switch to INT or whatever number type is needed.

Nine Stars

Re: tLogRow not showing all characters in field

Highlighted
Four Stars

Re: tLogRow not showing all characters in field

this issue has been solved by one of the members ,this is what they said-It seems as though the data type was the issue. I changed it to String in the schema and synced up the columns and I got all the value now instead of only the first character. Thanks for your continued help, it's nice to see an active forum that helps.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch