My below SQL query is running fine:
- SELECT a.USRP,a.USER1, SUBSTR(a.USER1,23,3) as Template, BRCB, b.MGRP,b.ICDE,INAR,a.SECL,ACA1,ACA2,ACA3,ACA4,ACA5,ACA6 FROM muserdd as a left outer join MACBRDD as b on a.USRP = b.USRP left outer join MITEMDD as c on b.MGRP = c.MGRP and b.ICDE = c.ICDE order by a.USRP
But same is giving error when I'm trying to execute it by RUNSQLSTM by giving my source file and library name and also I have given member type as text and pasted this query in this text type member.
My RUNSQLSTM command getting failed any suggestion/idea to make this RUNSQLSTM command successful. However I doubt some syntax error in my Text type source member but not sure how to correct it. However getting error message that positional value can not follow KEYWORD something like that.
Please help me by providing the exact correct source which will help to run my RUNSQLSTM command flawlessly.
September 10, 2013 10:35 AM
December 4, 2013 6:54 PM