I created a Temp file and used to load a table data using Where exist funtion. I am getting error that the fields from where exists funtion could not found. Please help
SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;($#,##0.00)'; SET TimeFormat='h:mm:ss TT'; SET DateFormat='M/D/YYYY'; SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Table: Load *, [@1:3] as [Rep-Off], [@4:6] as [Cur-Cd], [@7:8] as Org, [@9:10] as [Mgr-Cd], [@11:12] as [Maj-Lin], [@13:14 ] as [Min-Lin], [@15:21] as [Iss-Comp], [@22:23] as [Prod-Src], [@24:25] as [Tran-Type], [@26:27] as [Acct-Ln], [@28:30] as [Prod-Off], [@31:40] as [Polcy-No], [@41:46] as [Cert-No], [@47:56] as [Claim-No], [@57:63] as [Acct-Prd], [@64:72] as [Plcy-Inc-Dt] , [@73:81] as [Prem-Eff-Dt], [@82:90] as [Loc-Edit-Dt], [@91:99] as [Accid-Dt], [@100:108] as [Prem-Exp-Dt], [@109:117] as [Claim-Cre-Dt], [@118:118] as [Correct-Cd], [@119:128] as [Plcy-Id], [@129:129] as [Rsrve-Tp], [@130:138] as [Req-No], [@139:140] as [Meth-Of-Pay], [@141:149] as [Ind-Acct-No], [@150:154] as [Catas-No], [@155:155] as [Ho-Rev-Cd], [@156:161] as [Prod-No], [@162:163] as [RI-Type], [@164:170] as [RI-Comp], [@171:173] as [Cls-Prl], [@174:189] as [Vess-Name], [@190:197] as Blank1, [@198:201] as [Cause-Of-Loss], [@202:204] as [Inj-Dam], [@205:207] as [Anat-Prop], [@208:210] as [Req-Rev-No], [@211:214] as Blank2, [@215:220] as [RI-Stat-Id], [@221:227] as Blank, [@228:230] as [Cntry-Cd] , [@231:247] as [Grp-Curr-Amt], [@248:252] as Blank3, [@253:259] as [Acqu-Rte-Grp], [@260:266] as [Agy-Comm-Rte-Grp], [@267:273] as [Fac-Rte-Grp], [@274:274] as [Pay-Tp], [@275:276] as [Loc-Br-Anal], [@277:281] as [Lob], [@282:284] as [Loc-Prd-Src], [@285:285] as Blank4, [@286:291] as [Ins-Stat-Cd1], [@292:297] as [Ins-Stat-Cd2], [@298:n] as Blank5
FROM (fix, codepage is 1252, no eof) Where Exists(Key, [Acct-Ln] & '-' &[Tran-Type] ); DROP Table TEMP;
