Shell Programming and Scripting

hi all,
I am working on awk scripting.I have created two awk files and now have a requirement of replacing the contents of first file with some contents of second file.
Please find below the two files created.File1 has 3 records and File2 has 4 records.
My requirement is to replace the second column and fourth column of File1 with matching codes from File2.My final file should look like:

Code:

111,JP,CB21031251,JP,
112,CI,T12014BA01,CI,
118,UU,MC100005  ,UU,

Can you please suggest a solution.The File1 and File2 in actual scenario can have any number of records.

Code:

awk -F, 'NR==FNR{a[$2]=$1;next}a[$2]{$4=a[$2];$2=a[$2]}1' OFS=, File2 File1

Hi ,I tried using the above code ,but got the following error

awk: syntax error near line 1
awk: bailing out near line 1

I am using ksh shell.

Use nawk or /usr/xpg4/bin/awk on Solaris.