|
Archives of the TeradataForumMessage Posted: Tue, 26 May 2009 @ 10:37:07 GMT
Hello to All, sorry for my bad english I hope will be enought clear: -- CONTEST: I'm using a Teradata V2R5.1 with Perl driver. I've just donwload a Table in a file using code example in documentation with driver. -- PROBLEM: I'm trying to upload a file using MLOAD Perl interface. But I can't understand why I always get a generic Teradata SQL Message: UtilitySetup: Invalid SQL statement for MLOAD. Will be apreciate if it's possible to understand better the "syntax" problem in some way. Here the simplified "code" : my $ctldbh = DBI->connect( 'dbi:Teradata:'.$server.';database=jedi_kbo_db' , $username , $password , { RaiseError => 0 , PrintError => 0 , tdat_lsn => 0 , tdat_no_cli => 'NO' , tdat_mode => 'DEFAULT' , tdat_charset => 'ASCII' # , trace => 2 } ) || die "NOT CONNECTED !!!"; # THIS WORKS .... # HERE THE MLOAD ISTRUCTION: my $total = $ctldbh->tdat_UtilitySetup( { Utility => 'MLOAD', Sessions => $sesscount, SQL => [ "$select" ] , SourceFields => $sourceFields, Source => "VARTEXT '|' ".$filenameF , MP => 1 }); print "PROBLEM!!!!:\n" ."str:".$ctldbh->errstr."\n" ."err:".$ctldbh->err."\n" .$DBI::errstr."\n" unless ($total && ($total > 0)); # HERE THE ROWS FOR $select and $sourceFields # (To put before command ) my $select = $opt_B_Sel || <<"ENDSELECT"; IGNORE DUPLICATE INSERT ROWS; INSERT INTO PARTY ( bus_duns_no = :f_bus_duns_no , bus_fed_tax_id = :f_bus_fed_tax_id , bus_legal_class_cd = :f_bus_legal_class_cd , bus_legal_class_ds = :f_bus_legal_class_ds , bus_main_objct_ds = :f_bus_main_objct_ds , bus_pub_priv_co_in = :f_bus_pub_priv_co_in , bus_stock_symb_cd = :f_bus_stock_symb_cd , bus_vat_no = :f_bus_vat_no , call_class_id = :f_call_class_id , delete_in = :f_delete_in , insert_dt = :f_insert_dt , last_update_dt = :f_last_update_dt , party_accept_var_pct = :f_party_accept_var_pct , party_amps_in = :f_party_amps_in , party_assoc_ds = :f_party_assoc_ds , party_atc_ds = :f_party_atc_ds , party_bnl_relation_in = :f_party_bnl_relation_in , party_bt_relation_in = :f_party_bt_relation_in , party_carr_type_ds = :f_party_carr_type_ds , party_consctd_ds = :f_party_consctd_ds , party_correlatd_cd = :f_party_correlatd_cd , party_correlatd_eff_dt = :f_party_correlatd_eff_dt , party_correlatd_end_dt = :f_party_correlatd_end_dt , party_correlatd_in = :f_party_correlatd_in , party_cred_am = :f_party_cred_am , party_cred_owner_nm = :f_party_cred_owner_nm , party_ds = :f_party_ds , party_eni_relation_in = :f_party_eni_relation_in , party_exclude_cred_check_in = :f_party_exclude_cred_check_in , party_exp_am = :f_party_exp_am , party_export_pct = :f_party_export_pct , party_ext_src_ds = :f_party_ext_src_ds , party_frode_in = :f_party_frode_in , party_grp_ass_id = :f_party_grp_ass_id , party_id = :f_party_id , party_import_pct = :f_party_import_pct , party_indiv_birth_dt = :f_party_indiv_birth_dt , party_indiv_gender_cd = :f_party_indiv_gender_cd , party_indiv_social_secur_no = :f_party_indiv_social_secur_no , party_isp_in = :f_party_isp_in , party_lead_by_ds = :f_party_lead_by_ds , party_lead_dt = :f_party_lead_dt , party_loc_no = :f_party_loc_no , party_med_relation_in = :f_party_med_relation_in , party_org_abroad_site_in = :f_party_org_abroad_site_in , party_org_bus_in = :f_party_org_bus_in , party_org_clerk_no = :f_party_org_clerk_no , party_org_emp_no = :f_party_org_emp_no , party_org_exp_dest_ds = :f_party_org_exp_dest_ds , party_org_exp_in = :f_party_org_exp_in , party_org_imp_dest_ds = :f_party_org_imp_dest_ds , party_org_imp_in = :f_party_org_imp_in , party_org_legal_dt = :f_party_org_legal_dt , party_org_reg_loc_nm = :f_party_org_reg_loc_nm , party_org_reg_no = :f_party_org_reg_no , party_org_svc_org_in = :f_party_org_svc_org_in , party_org_type_cd = :f_party_org_type_cd , party_org_url_ds = :f_party_org_url_ds , party_org_wrk_no = :f_party_org_wrk_no , party_orignl_atlanet_cd = :f_party_orignl_atlanet_cd , party_orignl_cd = :f_party_orignl_cd , party_outsourcing_in = :f_party_outsourcing_in , party_preact_in = :f_party_preact_in , party_rvnu_dt = :f_party_rvnu_dt , party_rvnu_growth_pct = :f_party_rvnu_growth_pct , party_soph_lvl_no = :f_party_soph_lvl_no , party_src_ds = :f_party_src_ds , party_src_list_cd = :f_party_src_list_cd , party_tam_farming_ds = :f_party_tam_farming_ds , party_tam_origin_ds = :f_party_tam_origin_ds , party_tax_mode_ds = :f_party_tax_mode_ds , party_tlc_data_am = :f_party_tlc_data_am , party_tlc_exp_dom_pct = :f_party_tlc_exp_dom_pct , party_tlc_exp_inter_pct = :f_party_tlc_exp_inter_pct , party_tlc_exp_intnl_pct = :f_party_tlc_exp_intnl_pct , party_tlc_exp_urb_pct = :f_party_tlc_exp_urb_pct , party_tlc_exp_wirels_pct = :f_party_tlc_exp_wirels_pct , party_type_cd = :f_party_type_cd , party_yr_rvnu_am = :f_party_yr_rvnu_am , src_id = :f_src_id , unit_of_measure_id = :f_unit_of_measure_id ); ENDSELECT my $sourceFields = <<"ENDSOURCEFIELDS"; USING ( f_bus_duns_no varchar(30) , f_bus_fed_tax_id varchar(16) , f_bus_legal_class_cd char(6) , f_bus_legal_class_ds varchar(30) , f_bus_main_objct_ds varchar(100) , f_bus_pub_priv_co_in char(1) , f_bus_stock_symb_cd char(6) , f_bus_vat_no varchar(11) , f_call_class_id byteint , f_delete_in char(1) , f_insert_dt date , f_last_update_dt date , f_party_accept_var_pct byteint , f_party_amps_in char(1) , f_party_assoc_ds varchar(100) , f_party_atc_ds varchar(100) , f_party_bnl_relation_in char(1) , f_party_bt_relation_in char(1) , f_party_carr_type_ds varchar(50) , f_party_consctd_ds varchar(100) , f_party_correlatd_cd varchar(50) , f_party_correlatd_eff_dt date , f_party_correlatd_end_dt date , f_party_correlatd_in char(1) , f_party_cred_am decimal(18,4) , f_party_cred_owner_nm varchar(50) , f_party_ds varchar(255) , f_party_eni_relation_in char(1) , f_party_exclude_cred_check_in char(1) , f_party_exp_am decimal(13,6) , f_party_export_pct decimal(3,0) , f_party_ext_src_ds varchar(50) , f_party_frode_in char(1) , f_party_grp_ass_id integer , f_party_id integer , f_party_import_pct decimal(3,0) , f_party_indiv_birth_dt date , f_party_indiv_gender_cd char(6) , f_party_indiv_social_secur_no char(9) , f_party_isp_in char(1) , f_party_lead_by_ds varchar(100) , f_party_lead_dt date , f_party_loc_no integer , f_party_med_relation_in char(1) , f_party_org_abroad_site_in char(1) , f_party_org_bus_in char(1) , f_party_org_clerk_no decimal(5,0) , f_party_org_emp_no decimal(18,4) , f_party_org_exp_dest_ds varchar(255) , f_party_org_exp_in char(1) , f_party_org_imp_dest_ds varchar(255) , f_party_org_imp_in char(1) , f_party_org_legal_dt date , f_party_org_reg_loc_nm varchar(30) , f_party_org_reg_no varchar(30) , f_party_org_svc_org_in char(1) , f_party_org_type_cd char(6) , f_party_org_url_ds varchar(100) , f_party_org_wrk_no integer , f_party_orignl_atlanet_cd varchar(100) , f_party_orignl_cd varchar(40) , f_party_outsourcing_in char(1) , f_party_preact_in char(1) , f_party_rvnu_dt date , f_party_rvnu_growth_pct decimal(3,0) , f_party_soph_lvl_no varchar(30) , f_party_src_ds varchar(50) , f_party_src_list_cd char(6) , f_party_tam_farming_ds varchar(255) , f_party_tam_origin_ds varchar(2000) , f_party_tax_mode_ds varchar(50) , f_party_tlc_data_am decimal(18,6) , f_party_tlc_exp_dom_pct decimal(18,4) , f_party_tlc_exp_inter_pct decimal(18,4) , f_party_tlc_exp_intnl_pct decimal(18,4) , f_party_tlc_exp_urb_pct decimal(18,4) , f_party_tlc_exp_wirels_pct decimal(18,4) , f_party_type_cd char(6) , f_party_yr_rvnu_am decimal(18,6) , f_src_id byteint , f_unit_of_measure_id integer ) ENDSOURCEFIELDS Any help will be apreciate, thanks in advance Giulio Giulio Bertani
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||