topic Re: Need Explaination in QlikView https://community.qlik.com/t5/QlikView/Need-Explaination/m-p/710548#M255973 <HTML><HEAD></HEAD><BODY><P>Based on the value in variable <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">v_schema</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">- Previous database connection is disconnected using <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DISCONNECT</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">- Connected to database based on <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">UserId and Password</SPAN></SPAN></P><P></P><P>Is UserId differs in the if block? If yes, then that UserId might have access to that schema mentioned in v_schema</P></BODY></HTML> Sat, 27 Sep 2014 07:42:45 GMT anbu1984 2014-09-27T07:42:45Z Need Explaination https://community.qlik.com/t5/QlikView/Need-Explaination/m-p/710547#M255972 <HTML><HEAD></HEAD><BODY><P>Can any body tell me the meaning of this code</P><P></P><P>set path = 'D:\DIAL MIS\Data Files\Source QVD\AMDB';</P><P></P><P>if v_schema = 'CEDA_MIS' then</P><P>DISCONNECT;</P><P>ODBC CONNECT TO [AMDB;DBQ=AMDB] (XUserId is , XPassword is </P><P>ENDIF</P><P>if v_schema = 'CEDA_SAP' then</P><P>DISCONNECT;</P><P>ODBC CONNECT TO [AMDB;DBQ=AMDB] (XUserId is , XPassword is );</P><P>ENDIF</P><P>if v_schema = 'BME' then</P><P>DISCONNECT;</P><P>ODBC CONNECT TO [AMDB;DBQ=AMDB] (XUserId is , XPassword is );</P><P>ENDIF</P></BODY></HTML> Sat, 27 Sep 2014 07:29:27 GMT https://community.qlik.com/t5/QlikView/Need-Explaination/m-p/710547#M255972 2014-09-27T07:29:27Z Re: Need Explaination https://community.qlik.com/t5/QlikView/Need-Explaination/m-p/710548#M255973 <HTML><HEAD></HEAD><BODY><P>Based on the value in variable <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">v_schema</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">- Previous database connection is disconnected using <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DISCONNECT</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">- Connected to database based on <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">UserId and Password</SPAN></SPAN></P><P></P><P>Is UserId differs in the if block? If yes, then that UserId might have access to that schema mentioned in v_schema</P></BODY></HTML> Sat, 27 Sep 2014 07:42:45 GMT https://community.qlik.com/t5/QlikView/Need-Explaination/m-p/710548#M255973 anbu1984 2014-09-27T07:42:45Z