103 lines
4.6 KiB
Plaintext
103 lines
4.6 KiB
Plaintext
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
|