db2 - How to removing spacing in SQL -

i have data in db2 want insert data sql.

the db2 data had :

select char('aaa   ') test table_1

but then, when select in sql after doing insert, data become this.

select test table_1

result :

test ------ aaa

why space character read box character. how fix space character read into.

or there setting need change? or have use parameter?

i used as400 , datastage.

thank you.

datastage appends pad characters know there spaces there. pad character 0x00 (nul) default , that's you're seeing.

research apt_string_padchar environment variable; can set else if want.

the 0x00 characters not in database. short answer is, can safely ignore it.

CSS