informix SQL语句分析解决方法_Informix

informix SQL语句分析
Select Count(*) From [email protected]:acnt19 Where Exists(Select 1 From [email protected]:acnt03 Where unitcode='41010000' And articlecode='UU010153' And useflag[1]='1' And gradeflag[1]='2') And acbookcode='11' And unitcode='41010000' And itemcode='2112' And 'UU010153' Matches trim(articlecode)||'*' And seqno= 3 And articlecode[1,2] In ('UU','QQ','PP','FF','CC','HH');
这条语句查询的表是什么？[email protected]:acnt19?
还是acnt19？，[email protected]？
articlecode[1,2] In ('UU','QQ','PP','FF','CC','HH');
articlecode[1,2]这个又怎么理解？
------解决方案--------------------

引用:

Select Count(*) From [email protected]:acnt19 Where Exists(Select 1 From [email protected]:acnt03 Where unitcode='41010000' And articlecode='UU010153' And useflag[1]='1' And gradeflag[1]='2') And acbookcode='11' And unitcode='41010000' And itemcode='2112' And 'UU010153' Matches trim(articlecode)
------解决方案--------------------
'*' And seqno= 3 And articlecode[1,2] In ('UU','QQ','PP','FF','CC','HH');
这条语句查询的表是什么？[email protected]:acnt19?
还是acnt19？，[email protected]？
articlecode[1,2] In ('UU','QQ','PP','FF','CC','HH');
articlecode[1,2]这个又怎么理解？

这条语句查询的表是什么？[email protected]:acnt19? -- 对哦
还是acnt19？，[email protected]？ -- 是instance @ host
articlecode[1,2] In ('UU','QQ','PP','FF','CC','HH');

------解决方案--------------------
articlecode[1,2]，是articlecode的第一到第二的字符值。
感觉上，表设立的不是很好。
------解决方案--------------------
[email protected]:[email protected]（在局域网环境中，你当前所连接的服务器中不包含此数据库，此数据库存在另外一台服务器中）中的表acnt19
articlecode[1,2]：同楼上解释；如果是articlecode[1,3]：就是第一位到第三位；articlecode[2,3]：表示第二位到第三位以此类推。