请高手帮我看下这条语句出了什么问题!
db2 export to c:/20100728_130_KZL.dat of del modified by nochardel decplusblank striplzeros Select cardno,rtrim(issuebrc),rtrim(issuebrc),rtrim(custno),rtrim(acctno),cardflg,case when substr(cardstat,1,1)='0' then '0' else '1' end,substr(usedate,1,4)||substr(usedate,6,2)||substr(usedate,9,2),substr(usedate,1,4)||substr(usedate,6,2)||substr(usedate,9,2),case when closedate=' ' then '29991231' else closedate end,case when teller=' ' then ' ' else rtrim(teller) end from cmscardinfo
单独执行SELECT语句不报错,但是在DB2命令行里执行这个EXPORT就报错,报在,SUBSTR(USEDATE,1,4)之后发现意外的标记,
SUBSTR不是内部或者外部命令!