proc编译之后，运行程序显示sqlcode:-1002，怎么解决？小白求帮忙，谢谢

Question

select '1.0.1',40,'4.3.1',case datalength(a.IDENTITUNO) when 11 then 1020004 when 12 then 1020002 else 1029999 end,a.IDENTITUNO,case datalength(a.IDENTITUNO) when 11 then 19 when 12 then 81 else 15 end,a.IDENTITUNO,null,null,null,null,null,distinct(b.netbar_wacode),'a.SITETYPE',STUFF((STUFF(a.ARR,5,1,'-'),8,1,'-')),substring(c.MAC,1,2)+'-'+substring(c.MAC,4,2)+'-'+substring(c.MAC,7,2)+'-'+substring(c.MAC,10,2)+'-'+substring(c.MAC,13,2)+'-'+substring(c.MAC,16,2),c.CLIENT_IP,null,null,0,0,0,0,'704252847'+substring(b.MAC,1,2)+substring(b.MAC,4,2)+substring(b.MAC,7,2)+substring(b.MAC,10,2)+substring(b.MAC,13,2)+substring(b.MAC,16,2),substring(b.MAC,1,2)+'-'+substring(b.MAC,4,2)+'-'+substring(b.MAC,7,2)+'-'+substring(b.MAC,10,2)+'-'+substring(b.MAC,13,2)+'-'+substring(b.MAC,16,2),b.LONGITUDE,b.LATITUDE,'rssi',distinct(b.netbar_wacode)+substring(b.MAC,1,2)+substring(b.MAC,4,2)+substring(b.MAC,7,2)+substring(b.MAC,10,2)+substring(b.MAC,13,2)+substring(b.MAC,16,2)+convert(varchar(4),datepart(yy,a.ARR))+convert(varchar(4),datepart(mm,a.ARR))+convert(varchar(4),datepart(dd,a.ARR))+substring(convert(varchar(11),a.ARR,108),1,2)+substring(convert(varchar(11),a.ARR,108),4,2)+substring(convert(varchar(11),a.ARR,108),7,2),null,null,null,null,null,null,null,21,99,null,0,'ssid',null,null,30,0,from HOTELMASTER a,HOTEL b, GUESTWEBLOG c where a.IDENTITUNO is not nulland a.HOTELID=b.H_ID=c.HOTEL_IDand a.STA='I'and b.online_flad='Y'and length(b.netbar_wacode)=14and a.ARR > to_date('2016-11-11 17:21:23', 'yyyy-mm-dd hh24:mi:ss')
sqlcode:-1002.

Answer 1

http://blog.itpub.net/354732/viewspace-714114/