Oracle Load Characteristic

[gsym]

Hey,

I am using LOAD option in oracle enterprise stage. When i load onto the VARCHAR Field, the data is getting loaded with spaces.

Example

Assume the job as follows

Oracle -----> Transformer------->Oracle

In transformer i am defaulting a value 'SM' for column "Code" of datatype Varchar (5). when i load the data, its getting loaded as 'SM '

is there any env variable to solve this issuse or any workaround?

[changming]

Hey,

I am using LOAD option in oracle enterprise stage. When i load onto the VARCHAR Field, the data is getting loaded with spaces.

Example

Assume the job as follows

Oracle -----> Transformer------->Oracle

In transformer i am defaulting a value "SM" for column "Code" of datatype Varchar (5). when i load the data, its getting loaded as 'SA '

is there any env variable to solve this issuse or any workaround?

Do you mean Datastage turned 'SM' to 'SA ' ?
that is more seriously.

[gsym]

That was a typo.