create an additional column on the load script and fill it with a fixed value.

[#1]

Hello,

I have a table and on the load script I want to add an additional column (eg named year)

and then fill that column with a given fixed value ( eg 2010)

is this possible?

thanks!

[#2 · Accepted solution]

load

ID,

Emp_Name,

Add,

2010 as Year

Resident tablename;

Regards

Ashish

[#3]

LOAD

'2010' as Year,

ID,

Nane,

......;

[#4]

It works! thanks!