perl 连接Teradata

wxlwxlwxlwxl 2015-11-23 04:27:34

rt，根据dbd::Teradata说明，
my $dbh = DBI->connect('dbi:Teradata:dbc:1025;DATABASE=foobar;CHARSET=UTF8;MODE=ANSI;RSPBUFSZ=1048576', ...)
自己增加了ACCOUNT，
my $dbh = DBI->connect('dbi:Teradata:dbc:1025;DATABASE=foobar;ACCOUNT=usr,pwd;CHARSET=UTF8;MODE=ANSI;RSPBUFSZ=1048576', ...)
运行报错：
failed: Username required for connect. at test.pl line 17.

又换了一种
my $dbh = DBI->connect(
"dbi:Teradata:ip:port",
"user",
"passwd)
or die "Cannot connect\n";
还是报错：
failed: Deprecated logons are not allowed.

哪位用perl连过Teradata数据库，麻烦帮忙解答下，谢谢！

...全文

182 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

人傻且呆但不萌 2015-11-24

打赏
举报

how about this one :http://www.presicient.com/tdatdbd/ and refer this one: http://stackoverflow.com/questions/6524789/connecting-to-teradata-via-perl 你在链接的时候参数都是否完全？

matlab导入excel代码utl_joining_and_updating_excel_sheets_without_importing_data 无需导入数据即可连接和更新Excel工作表。关键字：sas sql join合并大数据分析宏oracle teradata mysql sas社区stackoverflow statistics人工智慧AI Python R Java Javascript WPS Matlab SPSS Scala Perl CC＃Excel MS Access JSON图形映射NLP自然语言处理机器学习igraph DOSUBL DOW循环stackoverflow SAS社区。 Joining and updating excel sheets without importing data; I do not modify sheet1, which is possible, but rather create sheet3 with the table join. Not really a table join but rather a for

matlab导入excel代码utl_sas_defensive_programming_and_error_checking SAS防御性编程和错误检查关键字：sas sql连接合并合并大数据分析宏oracle teradata mysql sas社区stackoverflow统计信息人工智慧AI Python R Java Javascript WPS Matlab SPSS Scala Perl CC＃Excel MS Access JSON图形映射NLP自然语言处理机器学习igraph DOSUBL DOW循环stackoverflow SAS社区。 SAS防御性编程和错误检查 Below are some techniques for defensive programming 1. SAS error handling options 2. Using text 'ERROR" but preventing log checkers from flaging your code when an error did not occur. 3. Definition of re

matlab导入excel代码utl_rowwise_frequencies_in_R_and_sas R和SAS中的行频率关键字：sas sql连接合并大数据分析宏oracle teradata mysql sas社区stackoverflow统计信息人工智慧AI Python R Java Javascript WPS Matlab SPSS Scala Perl CC＃Excel MS Access JSON图形映射NLP自然语言处理机器学习igraph DOSUBL DOW循环stackoverflow SAS社区。 R和SAS中的行频率 github https://github.com/rogerjdeangelis/utl_rowwise_frequencies_in_R_and_sas see https://goo.gl/mcrgXE https://stackoverflow.com/questions/45084312/calculate-column-wise-sum-for-each-row-add-new-columns-for-each-value-in-

matlab转换java代码utl_passing_sas_macro_variables_to_R_and_retrieving_macro_variables_from_R 将宏变量传递给R并从R中检索宏变量。关键字：sas sql连接合并大数据分析宏oracle teradata mysql sas社区stackoverflow统计信息人工智慧AI Python R Java Javascript WPS Matlab SPSS Scala Perl CC＃Excel MS Access JSON图形映射NLP自然语言处理机器学习igraph DOSUBL DOW循环stackoverflow SAS社区。将宏变量传递给R并从R中检索宏变量 Macro utl_submit_r64 is on the end of this messsage see github https://tinyurl.com/y7fn6lhz https://github.com/rogerjdeangelis/utl_passing_sas_macro_variables_to_R_and_ret

matlab导入excel代码utl_numbering_unique_and_duplicated_values_in_data_frame 编号数据帧中的唯一值和重复值关键字：sas sql连接合并大数据分析宏oracle teradata mysql sas社区stackoverflow统计信息人工智慧AI Python R Javascript WPS Matlab SPSS Scala Perl CC＃Excel MS Access JSON图形映射NLP自然语言处理机学习igraph DOSUBL DOW循环stackoverflow SAS社区。在数据框中编号唯一和重复的值 Two solutions 1. WPS/SAS 2, WPS/R or IML/R github https://goo.gl/a81YCf https://github.com/rogerjdeangelis/utl_numbering_unique_and_duplicated_values_in_data_frame see https://goo.gl/VnV4WA https://sta