connect to pfiaint user pfiaread using use4all

select * from pfiai.ps_vbs_aush_kr_tbl

select count(*) from pfiai.ps_vbs_aush_kr_tbl

describe select *  from pfiai.ps_zda_truppen_tbl


Proxy
http://www-proxy.dikvbs.admin.ch/gstproxy.pac
file://c:\dualproxy.pac

T:\pt818\bin\client\winx86>pstools -QUIET -CT DB2ODBC -CD PFIATST -CO PV54040 -C
P malongo -PJC kintana_tst -TD PFIAINT -TO PV54040 -TP malongo1 -LF c:\temp\kint
ana.log

pstools -QUIET -CT DB2ODBC -CD PFIATST -CO KINTANA_TST1 -CP kintana -PJC kintana_test    -TD PFIAINT -TO Kintana      -TP Officer     -LF c:\temp\kintana.log
 

Check Basetable content:
select count(*) from pfiai.ps_accomp_tbl;
select count(*) from pfiai.ps_accomp_tbl_lang;
select count(*) from pfiai.ps_chklst_item_tbl;
select count(*) from pfiai.ps_chklst_itm_lang;
select count(*) from pfiai.ps_comp_prop_tbl;
select count(*) from pfiai.ps_comp_prop_lang;
select count(*) from pfiai.ps_state_names_tbl;
select count(*) from pfiai.ps_state_names_lng;
select count(*) from pfiai.ps_vbs_appfld1_tbl;
select count(*) from pfiai.ps_vbs_appfld1_lng;
select count(*) from pfiai.ps_vbs_appfld2_tbl;
select count(*) from pfiai.ps_vbs_appfld2_lng;
select count(*) from pfiai.ps_vbs_arbgebg_tbl;
select count(*) from pfiai.ps_vbs_arbgebg_lng;
select count(*) from pfiai.ps_vbs_attrib_tbl;
select count(*) from pfiai.ps_vbs_attrib_lng;
select count(*) from pfiai.ps_vbs_aush_kr_tbl;
select count(*) from pfiai.ps_vbs_aush_kr_lng;
select count(*) from pfiai.ps_vbs_ausz_tbl;
select count(*) from pfiai.ps_vbs_ausz_lng;
select count(*) from pfiai.ps_vbs_befasne_tbl;
select count(*) from pfiai.ps_vbs_befausn_tbl;
select count(*) from pfiai.ps_vbs_befeffd_tbl;
select count(*) from pfiai.ps_vbs_befgrad_tbl;
select count(*) from pfiai.ps_vbs_beruf_tbl;
select count(*) from pfiai.ps_vbs_beruf_lng;
select count(*) from pfiai.ps_vbs_berufgr_tbl;
select count(*) from pfiai.ps_vbs_berufgr_lng;
select count(*) from pfiai.ps_vbs_brief_1_tbl;
select count(*) from pfiai.ps_vbs_delikt_tbl;
select count(*) from pfiai.ps_vbs_delikt_lng;
select count(*) from pfiai.ps_vbs_dienstb_tbl;
select count(*) from pfiai.ps_vbs_dienstb_lng;
select count(*) from pfiai.ps_vbs_diepfl_tbl;
select count(*) from pfiai.ps_vbs_diepfl_lng;
select count(*) from pfiai.ps_vbs_fhr_tbl;
select count(*) from pfiai.ps_vbs_fhr_lng;
select count(*) from pfiai.ps_vbs_konsu_tbl;
select count(*) from pfiai.ps_vbs_konsu_lng;
select count(*) from pfiai.ps_vbs_mil_pfl_tbl;
select count(*) from pfiai.ps_vbs_mob_det_tbl;
select count(*) from pfiai.ps_vbs_mob_det_lng;
select count(*) from pfiai.ps_vbs_mob_fkt_tbl;
select count(*) from pfiai.ps_vbs_mob_fkt_lng;
select count(*) from pfiai.ps_vbs_rkdpfl1_tbl;
select count(*) from pfiai.ps_vbs_spezaus_tbl;
select count(*) from pfiai.ps_vbs_spezaus_lng;
select count(*) from pfiai.ps_vbs_spezif_tbl;
select count(*) from pfiai.ps_vbs_spezif_lng;
select count(*) from pfiai.ps_vbs_taugli_tbl;
select count(*) from pfiai.ps_vbs_taugli_lng;
select count(*) from pfiai.ps_vbs_zivausb_tbl;
select count(*) from pfiai.ps_vbs_zivausb_lng;
select count(*) from pfiai.ps_vbs_ort_tbl;
select count(*) from pfiai.ps_vbs_plz_tbl;
select count(*) from pfiai.xlattable;