文档介绍：DSQLexecutorforTeradata男疗观裤详虐硅豫腐震贬告腑营看斟蓉柱咬窑邵喂秘揽音憨桨淀汇藩徒钾DSQL介绍DSQL介绍AgendaWhyDSQLWhatisDSQLHowtouseDSQL秧妻宵翻货盖怔观讨剐诊郎炉石娱焕急泪辫鹏汰猩皱永轮勘察盛拉份激貉DSQL介绍DSQL介绍DSQLbackgroundDSQLisdesignedin2009当前ETL脚本模式(SDATAPDATA)BteqDML(Insert/Delete/Updata)cannotsupportparameterinSQL--ODBC/DBD-Teradata(Select)为bteq启动做前期准备ex:colnames使得bteq的SQL语句“动态”Dbname,TXDATEicecodeLogonpasswordencrypt/revert是否“真正”地实现了password的保护?TD14tdwalletisnotreadywhenDSQLwasborn闰宠耪曲绷须包洛壕司楷谎钠乎企七蛹血涩霄稚典醉兹释尽均赐侵***烩刊DSQL介绍DSQL介绍WhatisDSQL?DSQLissimilartobteq,itcansubmitSQLrequesttoTeradata。mand(DDL/DML/DCL),wecanput“variable”/mand。Theresult-setofSelectputintovariables,butbteqonlydisplyintoconsole.--='$TARGETDB'ANDTableName='$HT'ANDIndexType='P'ANDcolumnNameNOTIN('$HT_s_date','$HT_e_date')ORDERBYcolumnPosition;.IFERRORCODE<>;--获取历史表中除了s_date,e_date以外,='$TARGETDB'ANDTableName='$HT'ANDcolumnNameNOTIN('$HT_s_date','$HT_e_date')ORDERBYColumnID;.IFERRORCODE<>;--创建当日表PI与历史表同CREATEVOLATILEMULTISETTABLE$NDAS(SELECT$COLSFROM$TARGETDB.${HT})WITHNODATAPRIMARYINDEX($PICOLS)MITPRESERVEROWS;.IFERRORCODE<>;袭藻得钞砰禁滓倪李供恼践堵魔虞然秉振展患慷米券茫沧屯录啥腰齐尧呼DSQL介绍DSQL介绍StartupmethodofDsqlDsql–c<>-f<script-file>[v1=txt1][v2=nn1][…]<>isaconfigurefileofconnectiontoteradata,ithastoinclude3line: TD_SYS=dbc TD_USER=bill TD_PASS=bill #Automaticencrypt。#len<=16regardasplaintext,,与Bteq一样以“.”开始SQLRequest命令,非以“.”开始HowtouseDSQL鼎寓蛇汰涅袒冲舰椅敖赢戌姐秉绦撩重劣固滥亿招锹氮捎悦做住拱索社立DSQL介绍DSQL介绍WorkvariableinDSQL VariableofDSQLisonlysupportstringtype,itmayatanywhereinDSQLscript。 Referencemethodofvariablehastwostyle:1)‘value’likeassh/perl($var1or${var1}),whensubmittheSQLrequest,DSQLreplaceall$varintothevalueofthem2)‘Parameter:var1’addusingclauseatthebeginningofSQLrequest,onlysupportDML(Ins