文档介绍: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