123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571 |
- [Builtin Functions]
- c:cast_char(%1bcxdinst {,%2n})=CAST(%1 AS CHAR{(%2)})
- d:cast_date(%1cdt)=CAST(%1 AS DATE)
- n:cast_decimal(%1cin {,%2n,%3n})=CAST(%1 AS DECIMAL{(%2,%3)})
- n:cast_double_precision(%1cn)=CAST(%1 AS DOUBLE PRECISION)
- n:cast_float(%1cn)=CAST(%1 AS FLOAT)
- n:cast_integer(%1cin)=CAST(%1 AS INTEGER)
- c:cast_numberToString(%1bcdinst)=CAST(%1 AS CHAR(254))
- n:cast_numeric(%1cin {,%2n,%3n})=CAST(%1 AS NUMERIC{(%2,%3)})
- n:cast_real(%1cn)=CAST(%1 AS REAL)
- n:cast_smallint(%1cin)=CAST(%1 AS SMALLINT)
- c:cast_varchar(%1bcxdinst {,%2n})=CAST(%1 AS VARCHAR(%2))
- t:localtime({%1n})=CURRENT_TIME
- s:localtimestamp({%1n})=CURRENT_TIMESTAMP
- d:_add_days(%1d,%2n)=( %1 + cast( ( %2 ) as INTERVAL DAY(4) ) )
- s:_add_days(%1s,%2n)=( %1 + cast( ( %2 ) as INTERVAL DAY(4) ) )
- d:_add_months(%1d,%2n)=ADD_MONTHS( %1, %2 )
- s:_add_months(%1s,%2n)=ADD_MONTHS( %1, %2 )
- d:_add_years(%1d,%2n)=ADD_MONTHS( %1, ( (%2) * 12 ) )
- s:_add_years(%1s,%2n)=ADD_MONTHS( %1, ( (%2) * 12 ) )
- n:_days_between(%1d,%2d)=(%1 - %2)
- n:_days_between(%1s,%2s)=case when ((%1 - CAST(CAST(%1 AS DATE) AS TIMESTAMP) ) HOUR TO SECOND < (%2 - CAST(CAST(%2 AS DATE) AS TIMESTAMP) ) HOUR TO SECOND) and (CAST (%1 AS DATE) - CAST (%2 AS DATE) > 0) then CAST (%1 AS DATE) - CAST (%2 AS DATE) - 1 when ((%1 - CAST(CAST(%1 AS DATE) AS TIMESTAMP) ) HOUR TO SECOND > (%2 - CAST(CAST(%2 AS DATE) AS TIMESTAMP) ) HOUR TO SECOND) and (CAST (%1 AS DATE) - CAST (%2 AS DATE) < 0) then CAST (%1 AS DATE) - CAST (%2 AS DATE) + 1 else CAST (%1 AS DATE) - CAST (%2 AS DATE) end
- n:_months_between(%1ds,%2ds)=((EXTRACT( YEAR from %1 ) - EXTRACT( YEAR from %2 )) * 12 + EXTRACT( MONTH from %1 ) - EXTRACT( MONTH from %2 ) + CASE WHEN cast(%1 as DATE ) > cast( %2 as DATE ) THEN CASE WHEN EXTRACT( DAY from %1 ) < EXTRACT( DAY FROM %2 ) AND EXTRACT( DAY from LAST_DAY(%1) ) <> EXTRACT( DAY from %1 ) THEN -1 ELSE 0 END WHEN cast(%1 as DATE ) < cast( %2 as DATE ) THEN CASE WHEN EXTRACT( DAY from %1 ) > EXTRACT( DAY from %2 ) AND EXTRACT( DAY from LAST_DAY(%2) ) <> EXTRACT( DAY from %2 ) THEN 1 ELSE 0 END ELSE 0 END)
- n:_years_between(%1ds,%2ds)=((EXTRACT( YEAR from %1 ) - EXTRACT( YEAR from %2 )) * 12 + EXTRACT( MONTH from %1 ) - EXTRACT( MONTH from %2 ) + CASE WHEN cast(%1 as DATE ) > cast( %2 as DATE ) THEN CASE WHEN EXTRACT( DAY from %1 ) < EXTRACT( DAY FROM %2 ) AND EXTRACT( DAY from LAST_DAY(%1) ) <> EXTRACT( DAY from %1 ) THEN -1 ELSE 0 END WHEN cast(%1 as DATE ) < cast( %2 as DATE ) THEN CASE WHEN EXTRACT( DAY from %1 ) > EXTRACT( DAY from %2 ) AND EXTRACT( DAY from LAST_DAY(%2) ) <> EXTRACT( DAY from %2 ) THEN 1 ELSE 0 END ELSE 0 END)/12
- n:_days_to_end_of_month(%1ds)=(EXTRACT( DAY FROM (ADD_MONTHS(%1 - CAST( EXTRACT( DAY FROM %1 ) AS INTERVAL DAY) + INTERVAL '1' DAY, 1) - INTERVAL '1' DAY)) - EXTRACT(DAY FROM %1))
- n:_age(%1ds)=
- d:_first_of_month(%1d)=(%1 - CAST( EXTRACT( DAY FROM %1 ) AS INTERVAL DAY ) + INTERVAL '1' DAY)
- s:_first_of_month(%1s)=(%1 - CAST( EXTRACT( DAY FROM %1 ) AS INTERVAL DAY ) + INTERVAL '1' DAY)
- d:_last_of_month(%1d)=(ADD_MONTHS( ( %1 - CAST( EXTRACT( DAY FROM %1 ) AS INTERVAL DAY ) + INTERVAL '1' DAY ), 1 ) - INTERVAL '1' DAY)
- s:_last_of_month(%1s)=(ADD_MONTHS( ( %1 - CAST( EXTRACT( DAY FROM %1 ) AS INTERVAL DAY ) + INTERVAL '1' DAY ), 1 ) - INTERVAL '1' DAY)
- s:_make_timestamp(%1n,%2n,%3n)=
- n:_ymdint_between(%1ds,%2ds)=
- n:_day_of_year(%1ds)= CAST( ( CAST (%1 AS DATE) + 1 - CAST( ( CAST( EXTRACT( YEAR FROM (CAST ( %1 AS DATE) )) AS CHAR(4)) || '-01-01' ) AS DATE) ) AS INTEGER)
- n:_round(%1n, %2n)=CASE WHEN (%1) < 0 THEN (CAST( ( (%1) * ( 10 ** (%2) ) - 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) ELSE (CAST( ( (%1) * ( 10 ** (%2) ) + 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) END
- n:_week_of_year(%1ds)=
- n:_day_of_week(%1ds, %2n)=
- t:_add_hours(%1t,%2n)=( %1 + cast( ( %2 ) as INTERVAL HOUR(4) ) )
- s:_add_hours(%1s,%2n)=( %1 + cast( ( %2 ) as INTERVAL HOUR(4) ) )
- t:_add_minutes(%1t,%2n)=( %1 + cast( ( %2 ) as INTERVAL MINUTE(4) ) )
- s:_add_minutes(%1s,%2n)=( %1 + cast( ( %2 ) as INTERVAL MINUTE(4) ) )
- t:_add_seconds(%1t,%2n)=( %1 + cast( ( %2 ) as INTERVAL SECOND(4,0) ) )
- s:_add_seconds(%1s,%2n)=( %1 + cast( ( %2 ) as INTERVAL SECOND(4,0) ) )
- n:_hours_between(%1ds,%2ds)=
- n:_minutes_between(%1ds,%2ds)=
- n:_seconds_between(%1ds,%2ds)=
- bcxdinst:nullif(%1dbcxdinst, %2dbcxdinst)=(NULLIF(%1, %2))
- n:round(%1n, %2n)=CASE WHEN (%1) < 0 THEN (CAST( ( (%1) * ( 10 ** (%2) ) - 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) ELSE (CAST( ( (%1) * ( 10 ** (%2) ) + 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) END
- n:power(%1n,%2n)=((%1) ** (%2))
- n:position(%1cx,%2cx)=INDEX(%2,%1)
- n:random(%1n,%2n)=RANDOM(%1,%2)
- c:coguda
- c:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- i:coguda
- [Database Functions]
- c:concat(%1,%2)=\{fn CONCAT(%1, %2)\}
- n:mod(%1,%2)=\{fn MOD(%1, %2)\}
- [Exceptions Aggregates]
- Avg="avg"
- Count="count"
- Count_Star="count(*)"
- Max="max"
- Min="min"
- Stddev_Pop="stddev_pop"
- Stddev_Samp="stddev_samp"
- Sum="sum"
- Var_Pop="var_pop"
- Var_Samp="var_samp"
- [Exceptions OLAP Functions]
- Olap_Avg="avg"
- Olap_Count="count"
- Olap_Count_Star="count(*)"
- Olap_Max="max"
- Olap_Min="min"
- Olap_Sum="sum"
- Olap_Rank="rank"
- Olap_Percent_Rank="percent_rank"
- Olap_Row_Number="row_number"
- [Exceptions Clauses]
- From="from"
- Group_By="group by"
- Having="having"
- Where="where"
- With=
- With_Recursive=
- [Exceptions Commands]
- Call="call "
- Delete="delete "
- Insert="insert "
- Select="select "
- Update="update "
- Max_Literal_Len="30502"
- [Exceptions Delimiters]
- Catalog_Delimiter="\""
- Schema_Delimiter="\""
- Table_Delimiter="\""
- Column_Delimiter="\""
- Procedure_Delimiter="\""
- Wholename_Delimiter=""
- [Exceptions General]
- Aggregate_In_Expr=T
- Aggregate_Value_Expr=T
- Boolean_Comparison=F
- Correlated_Subqueries=T
- Count_Blob=F
- Count_Non_Distinct=T
- Count_Value_Expr=T
- Count_Literal=T
- Cross_Product=T
- Distinct_Aggregates=T
- Distinct_Aggr_In_Case=F
- Group_By_Alias=T
- Group_By_Expr=T
- Group_By_Ordinal=T
- Group_By_Sorted=F
- Is_Null_Value_Expr=T
- Is_Null_Value_Parm=T
- Like_Value_Expr=T
- Multiple_Distinct=T
- Nested_Case=T
- Not_In_Subquery=T
- Nulls_Sort_Last=F
- Order_By_Alias=F
- Order_By_Name=F
- Substring_On_Expr=T
- Subqueries=T
- Subquery_Column_Alias=T
- Subquery_In_Case=F
- Olap_Distinct=F
- Olap_Null_Order=F
- Distinct_To_GroupBy=F
- Parameter_In_Select_List=F
- Expression_In_In=F
- [Exceptions General DATABASE:TERADATA VERSION:12.00]
- Distinct_To_GroupBy=T
- [Exceptions Joins]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Non_Equi_Join=T
- Full_Outer=T
- Full_Post=""
- Full_Pre=""
- Full_Syntax=" FULL OUTER JOIN "
- Inner=T
- Inner_Col_Post=""
- Inner_Col_Pre=""
- Inner_Syntax=" INNER JOIN "
- Inner_Tbl_Restrict=F
- Left_Eql=" LEFT OUTER JOIN "
- Left_Nested=T
- Left_Outer=T
- Left_Post=""
- Left_Pre=""
- Nested_Outer=T
- Non_Equi_Joins=T
- On_Condition_Between_Predicate=T
- On_Condition_In_Predicate=T
- On_Condition_IsNull_Predicate=T
- On_Condition_Like_Predicate=T
- On_Condition_Not_Predicate=T
- On_Condition_Or_Predicate=T
- On_Condition_Set_Functions=F
- On_Condition_Subqueries=T
- One_Outer=F
- Optnl_Tbl_Filter=T
- Optnl_Tbl_Join_Filter=T
- Optnl_Tbl_Join_Restrict=F
- Outer_Tbl_List=F
- Optnl_Tbl_Restrict=F
- Outer_Syntax=T
- Right_Eql=" RIGHT OUTER JOIN "
- Right_Nested=T
- Right_Outer=T
- Right_Post=""
- Right_Pre=""
- [Exceptions Literals]
- Alt_Date_Literal_Assignment=F
- Alt_Date_Literal_Between=F
- Alt_Date_Literal_Comparison=F
- Alt_Date_Literal_In=F
- Alt_Date_Literal_Insert_Value=F
- Alt_Date_Literal_Str=
- Alt_Interval_Literal_Str=
- Alt_Time_Literal_Str=
- Alt_Timestamp_Literal_Str=
- Boolean_Literal=F
- Date_Add_Function_Str=
- Date_Format_Str="YYYY MM DD"
- Date_Literal=C
- Date_Literal_Str="DATE '%s-%s-%s'"
- Date_Sub_Function_Str=
- False_Literal_Str=
- Interval_Format_Str="DDDD HH MM SS FFFFFF"
- Interval_Literal=T
- Interval_Literal_Str=
- IntervalYM_Format_Str="YYYY MM"
- IntervalYM_Literal=T
- IntervalYM_Literal_Str=
- Interval_Sign_Before_Quote=T
- Time_Format_Str="HH MM SS FFFFFF"
- Time_Literal=C
- Time_Literal_Str="TIME '%s:%s:%s.%s'"
- TimeTZ_Format_Str=
- TimeTZ_Literal=F
- TimeTZ_Literal_Str=
- Timestamp_Format_Str="YYYY MM DD HH MM SS FFFFFF"
- Timestamp_Literal=C
- Timestamp_Literal_Str="TIMESTAMP '%s-%s-%s %s:%s:%s.%s'"
- TimestampTZ_Format_Str=
- TimestampTZ_Literal=F
- TimestampTZ_Literal_Str=
- True_Literal_Str=
- Unknown_Literal_Str=
- Zero_Date_Literal_Str=
- Zero_Timestamp_Literal_Str=
- NChar_Literal=T
- [Exceptions Misc]
- Case_Parentheses=T
- [Exceptions Operators]
- Add="+"
- And="and"
- Div="/"
- Eql="="
- Geq=">="
- Grt=">"
- Leq="<="
- Les="<"
- Mul="*"
- Neq="<>"
- Not="not"
- Or="or"
- Sub="-"
- [Exceptions Predicates]
- All="all"
- [Exceptions Separators]
- Catalog_Separator="."
- Schema_Separator="."
- Table_Separator="."
- [Exceptions Set Operators]
- Distinct="distinct"
- Except=" except "
- Except_All=T
- Intersect="intersect"
- Intersect_All=T
- Union="union"
- Union_All=T
- [Exceptions Tables]
- Joined=T
- Derived=T
- UniqueName_Prefix="coguda"
- [Exceptions Value Expressions]
- Case=T
- Cast=T
- Coalesce=T
- Extract=T
- Octet_Length=T
- Nullif=C
- Substring=T
- Upper=T
- StrCat=T
- Char_Length=T
- Position=C
- Current_Date=T
- Current_Time=F
- Current_Timestamp=F
- LocalTime=C
- LocalTimestamp=C
- Abs=T
- Exp=T
- Ln=T
- Mod=T
- Power=C
- Sqrt=T
- Ceiling=F
- Lower=T
- Floor=F
- Trim=T
- [Exceptions Blob Expressions]
- Blob_In_Substring=T
- Blob_In_Trim=T
- Blob_In_StrCat=T
- [Operator Addition]
- Date=
- Time=
- Timestamp=
- Interval=
- [Operator Subtraction]
- Date=
- Time=
- Timestamp=
- Interval=
- [Operator Comparison]
- NV=CH,OK:NC,OK:VC,OK
- NC=NV,OK:CH,OK:VC,OK
- VC=NV,OK:NC,OK
- CH=NV,OK:NC,OK
- [Misc]
- Processing Mode=Database Only
- Wild_Card_As_Tablename=
- [Directives Session]
- Query_Row_Limit_Pos=Append_Distinct
- Query_Row_Limit_Text=" TOP %d "
- [Operator Cast DATABASE:TERADATA]
- AD=AD,AD
- AD=TT,NA:TZ,NA
- TM=TM,NA
- TS=TM,NA
- TT=TM,NA
- TZ=TS,NA
- DB=IV,NA:IY,NA
- FL=IV,NA:IY,NA
- [DATABASE:TERADATA VERSION:16]
- [I18N Encoding Mapping DATABASE:TERADATA]
- 3=US-ASCII
- 4=iso-8859-1
- 5=iso-8859-2
- 6=iso-8859-3
- 7=iso-8859-4
- 8=iso-8859-5
- 9=iso-8859-6
- 10=iso-8859-7
- 11=iso-8859-8
- 12=iso-8859-9
- 106=utf-8
- 111=iso-8859-15
- 17=Shift_JIS
- 36=korean
- 2004=roman8
- 2025=GB2312
- 114=gb18030
- 2026=Big5
- 2030=CP273
- 2252=cp1252
- 2259=TIS-620
- [DATABASE:TERADATA]
- DBINFO_SUBSECTIONS="DBNAM,DBMIN"
- Interval Workaround="T"
- SupportUnicode="T"
- CHARACTER_SET_SQL="SELECT CurrentCollation, LogonSource FROM DBC.SessionInfoX WHERE SessionNo = SESSION AND UserName = '%s' ORDER BY LogonSequenceNo desc, LogonDate desc, LogonTime desc"
- CLOSE_HSTMT_AT_EOD="T"
- RELEASE_SUBCONNECTION="T"
- SQL_MAX_CONCURRENT_ACTIVITIES="1"
- disable_Help_Column = "F"
- Unsigned Positive Numbers="T"
- [DRIVER:TDATAODBC_SB32.DLL]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- [DRIVER:TDATAODBC_SB32.SO]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- [DRIVER:TDATAODBC_SB64.DLL]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- [DRIVER:TDATAODBC_SB64.SO]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- [DRIVER:TDATA32.DLL]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- [DRIVER:TDATA.SO]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
|