Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
load
ID,
Emp_Name,
Add,
2010 as Year
Resident tablename;
Regards
Ashish
LOAD
'2010' as Year,
ID,
Nane,
......;
It works! thanks!