Need Explaination

[#1]

Can any body tell me the meaning of this code

set path = 'D:\DIAL MIS\Data Files\Source QVD\AMDB';

if v_schema = 'CEDA_MIS' then

DISCONNECT;

ODBC CONNECT TO [AMDB;DBQ=AMDB] (XUserId is , XPassword is

ENDIF

if v_schema = 'CEDA_SAP' then

DISCONNECT;

ODBC CONNECT TO [AMDB;DBQ=AMDB] (XUserId is , XPassword is );

ENDIF

if v_schema = 'BME' then

DISCONNECT;

ODBC CONNECT TO [AMDB;DBQ=AMDB] (XUserId is , XPassword is );

ENDIF

[anbu1984]

Based on the value in variable v_schema

- Previous database connection is disconnected using DISCONNECT

- Connected to database based on UserId and Password

Is UserId differs in the if block? If yes, then that UserId might have access to that schema mentioned in v_schema