- 论坛徽章:
- 0
|
本帖最后由 Ray001 于 2010-09-28 21:29 编辑
- select oldactno,
- case clrflg
- when '0' then '1'
- when '1' then '1'
- when '2' then '9'
- when '6' then '8'
- end case,
- case curcd
- when '0' then 'EUR'
- when '1' then 'HKD`'
- when '1' then 'JPY'
- when '1' then 'USD'
- end case,
- lnamt,
- rstamt,
- case acctype
- when '1' then '10'
- when '2' then '20'
- when '3' then '20'
- when '4' then '30'
- when '5' then '40'
- end case,
- lpday,
- matday,
- ' ',
- case intrflg
- when '1' then '3'
- when '3' then '4'
- end case,
- case intrflg
- when '1' then '2'
- when '3' then '4'
- end case,
- 0.00,
- 0.00,
- lnrate,
- xratio,
- lnrate,
- brno
- from fxlndtl into temp test_t;
复制代码 在Informix10下,不加into temp test_t,能正常执行,加上into temp test_t后,显示- 328: Column (case) already exists in table or type.
复制代码 额,我已经猜到是什么问题了。明天去试试。 |
|