clear all
* Main routine for attachting all tables from Database Server. This routine is based on */
/* DSN  */
/* and compound for each month that the child is resident and alive */
set memory 800M
global chililab ="dss"
global username ="sa"
global password ="123456"
cd \chililabdata\data
/*individual information*/
odbc load,  dsn($chililab)user($username) password($password) table("individual")clear
save individual, replace
odbc load, exec("SELECT * FROM membership" ) dsn($chililab)user($username) password($password) clear
save membership, replace
odbc load, exec("SELECT * FROM individres" ) dsn($chililab)user($username) password($password) clear
save individres, replace
odbc load, exec("SELECT * FROM relationship" ) dsn($chililab)user($username) password($password) clear
save relationship, replace
odbc load, exec("SELECT * FROM religion" ) dsn($chililab)user($username) password($password) clear
save religion, replace
odbc load, exec("SELECT * FROM education" ) dsn($chililab)user($username) password($password) clear
save education, replace
odbc load, exec("SELECT * FROM occupation" ) dsn($chililab)user($username) password($password) clear
save occupation, replace
odbc load, exec("SELECT * FROM indmarstatus" ) dsn($chililab)user($username) password($password) clear
save indmarstatus, replace
odbc load, exec("SELECT * FROM medinsurance" ) dsn($chililab)user($username) password($password) clear
save medinsurance, replace


/*household information*/
odbc load, exec("SELECT * FROM socialgroup" ) dsn($chililab)user($username) password($password) clear
save socialgroup, replace
odbc load, exec("SELECT * FROM householdInfo" ) dsn($chililab)user($username) password($password) clear
save householdInfo, replace
odbc load, exec("SELECT * FROM houseres" ) dsn($chililab)user($username) password($password) clear
save houseres, replace

/*location information*/
odbc load, exec("SELECT * FROM location" ) dsn($chililab)user($username) password($password) clear
save location, replace
odbc load, exec("SELECT * FROM locationinfo" ) dsn($chililab)user($username) password($password) clear
save locationinfo, replace

/*household information*/
odbc load, exec("SELECT * FROM householdInfo" ) dsn($chililab)user($username) password($password) clear
save householdInfo, replace
odbc load, exec("SELECT * FROM socialgroup" ) dsn($chililab)user($username) password($password) clear
save socialgroup, replace
odbc load, exec("SELECT * FROM household_head" ) dsn($chililab)user($username) password($password) clear
save household_head, replace

/*death*/
odbc load, exec("SELECT * FROM death" ) dsn($chililab)user($username) password($password) clear
save death, replace

/*migration both  individual and whole household*/

odbc load, exec("SELECT * FROM outmigration" ) dsn($chililab)user($username) password($password) clear
save outmigration, replace
odbc load, exec("SELECT * FROM inmigration" ) dsn($chililab)user($username) password($password) clear
save inmigration, replace
odbc load, exec("SELECT * FROM householdin" ) dsn($chililab)user($username) password($password) clear
save householdin, replace
odbc load, exec("SELECT * FROM householdout" ) dsn($chililab)user($username) password($password) clear
save householdout, replace

/*pregnance and birth*/

odbc load, exec("SELECT * FROM pregnance" ) dsn($chililab)user($username) password($password) clear
save pregnance, replace
odbc load, exec("SELECT * FROM birth" ) dsn($chililab)user($username) password($password) clear
save birth, replace
odbc load, exec("SELECT * FROM observation" ) dsn($chililab)user($username) password($password) clear
save observation, replace

/*Libraries */
odbc load, exec("SELECT * FROM CountryList" ) dsn($chililab)user($username) password($password) clear
save countylist, replace
/*Health service using information*/
/*odbc load, exec("SELECT * FROM healthserviceusing" ) dsn($chililab)user($username) password($password) clear*/
/*save healthservice, replace */
/*odbc load, exec("SELECT * FROM ah3" ) dsn($chililab)user($username) password($password) clear*/
/*save ah3, replace */

/*disability*/

odbc load, exec("SELECT * FROM tbldisability" ) dsn($chililab)user($username) password($password) clear
save tbldisability, replace 
/*Smoking*/

odbc load, exec("SELECT * FROM tblSmoking" ) dsn($chililab)user($username) password($password) clear
save tblSmoking, replace 
odbc load, exec("SELECT * FROM tblSmokingDetails" ) dsn($chililab)user($username) password($password) clear
save tblSmokingDetails, replace 
/*Pregnance*/

odbc load, exec("SELECT * FROM pregnance" ) dsn($chililab)user($username) password($password) clear
save pregnance, replace 
window stopbox note "All data was saved in d:\chililabdata\Data folder"
cd \chililabdata
clear all