| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454 |
- [Database Functions]
- [Database Functions DATABASE:IBM COGNOS REAL-TIME MONITORING]
- n:ceiling(%1n)=CEIL(%1)
- c:trim_both_spaces(%1c)=LTRIM(RTRIM(%1))
- c:trim_leading_spaces(%1c)=LTRIM(%1)
- c:trim_trailing_spaces(%1c)=RTRIM(%1)
- [Database Functions DRIVER:DBODBC6.DLL]
- c:substring(%1c, %2n, %3n)=CAST(SUBSTR(%1, %2, %3) as varchar(2000))
- n:cast_decimal(%1n)=CAST(%1 AS DECIMAL)
- [Builtin Functions DATABASE:NETEZZASQL]
- t:localtime()=CAST(CURRENT_TIME AS TIME)
- s:localtimestamp({%1n})=CAST(CURRENT_TIMESTAMP AS TIMESTAMP)
- n:_months_between(%1ds,%2ds)= CAST(MONTHS_BETWEEN (%1, %2) AS INTEGER)
- n:_days_between(%1s,%2s)=(cast(%1 as DATE) - cast(%2 as DATE))
- n:_days_between(%1s,%2d)=(cast(%1 as DATE) - (%2))
- n:_days_between(%1d,%2s)=((%1) - cast(%2 as DATE))
- n:_days_between(%1d,%2d)=((%1) - (%2))
- n:_years_between(%1ds,%2ds)=EXTRACT (YEAR FROM AGE ( %1, %2))
- d:_add_months(%1d,%2n)=cast(((%1) + INTERVAL '1 MONTH' * (%2)) as DATE)
- s:_add_months(%1s,%2n)=((%1) + INTERVAL '1 MONTH' * (%2))
- d:_add_years(%1d,%2n)=cast(((%1) + INTERVAL '1 YEAR' * (%2)) as DATE)
- s:_add_years(%1s,%2n)=((%1) + INTERVAL '1 YEAR' * (%2))
- d:_add_days(%1d,%2n)=cast(((%1) + ((%2) * INTERVAL '1 DAY')) as DATE)
- s:_add_days(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 DAY'))
- s:_add_hours(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 HOUR'))
- t:_add_hours(%1t,%2n)=((%1) + ((%2) * INTERVAL '1 HOUR'))
- s:_add_minutes(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 MINUTE'))
- t:_add_minutes(%1t,%2n)=((%1) + ((%2) * INTERVAL '1 MINUTE'))
- s:_add_seconds(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 SECOND'))
- t:_add_seconds(%1t,%2n)=((%1) + ((%2) * INTERVAL '1 SECOND'))
- n:_day_of_year(%1ds)=EXTRACT (doy from %1)
- n:_week_of_year(%1ds)=CAST( to_char(cast ( %1 as timestamp ),'IW') as integer)
- n:_day_of_week(%1ds, %2n)= (MOD( CAST( TO_CHAR( %1, 'D' ) AS INTEGER ) + 6 - %2, 7 ) + 1)
- d:_first_of_month(%1d)=(%1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY')
- s:_first_of_month(%1s)=(%1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY')
- d:_last_of_month(%1d)=(ADD_MONTHS( ( %1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY' ), 1 ) - INTERVAL '1 DAY')
- s:_last_of_month(%1s)=(ADD_MONTHS( ( %1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY' ), 1 ) - INTERVAL '1 DAY')
- n:_days_to_end_of_month(%1ds)=(EXTRACT( DAY FROM (ADD_MONTHS(%1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY') + INTERVAL '1 DAY', 1) - INTERVAL '1 DAY')) - EXTRACT(DAY FROM %1))
- n:_round(%1n, %2n)=ROUND(%1,%2)
- n:round(%1n, %2n)=ROUND(%1,%2)
- [Builtin Functions DRIVER:NSQLODBC.DLL VERSION:03.00]
- n:_round(%1n, %2n)=
- n:round(%1n, %2n)=
- [Builtin Functions DRIVER:NSQLODBC.DLL VERSION:03.01.0000]
- n:_round(%1n, %2n)=
- n:round(%1n, %2n)=
- [Builtin Functions DRIVER:NSQLODBC.DLL VERSION:03.01.0002]
- n:_round(%1n, %2n)=
- n:round(%1n, %2n)=
- [Builtin Functions DATABASE:HP NEOVIEW DATABASE]
- n:_months_between(%1ds,%2ds)=DATEDIFF(MONTH,%2,%1)
- n:_days_between(%1sd,%2sd)=DATEDIFF(DAY,%2,%1)
- n:_years_between(%1ds,%2ds)=DATEDIFF(YEAR,%2,%1)
- d:_add_months(%1ds,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL MONTH) )
- d:_add_years(%1ds,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL YEAR) )
- s:_add_days(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL DAY) )
- d:_add_days(%1d,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL DAY) )
- s:_add_hours(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL HOUR) )
- t:_add_hours(%1t,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL HOUR) )
- s:_add_minutes(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL MINUTE) )
- t:_add_minutes(%1t,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL MINUTE) )
- s:_add_seconds(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL SECOND) )
- t:_add_seconds(%1t,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL SECOND) )
- n:_day_of_year(%1ds)=DAYOFYEAR (%1)
- n:day_of_week( %1ds, %2n )=(MOD(DAYOFWEEK(%1)+7-%2,7)+1)
- s:_first_of_month(%1s)=DATE_TRUNC('MONTH',%1)
- d:_first_of_month(%1d)=CAST( DATE_TRUNC('MONTH',%1) AS DATE)
- s:_last_of_month(%1s)=DATE_TRUNC('MONTH',DATE_ADD(%1,INTERVAL '1' MONTH))-INTERVAL '1' DAY
- d:_last_of_month(%1d)=CAST( DATE_TRUNC('MONTH',DATE_ADD(%1,INTERVAL '1' MONTH))-INTERVAL '1' DAY as DATE)
- n:_days_to_end_of_month(%1sd)=DATEDIFF(DAY,%1,DATE_TRUNC('MONTH',DATE_ADD( %1, INTERVAL '1' MONTH)))-1
- [Database Functions DATABASE:NETEZZASQL]
- n:ascii(%1c)=ascii(%1)
- n:power(%1n,%2n)=POW(%1,%2)
- [Database Functions DRIVER:ODBCJT32.DLL]
- n:cast_decimal(%1bcdints {,%2n, %3n})=((%1 {+ 0 * %2 * %3}) * 1.0)
- n:cast_float(%1bcdn)=(%1 * 1e0)
- c:curdate()= \{fn CURDATE() \}
- c:curtime()=\{fn CURTIME() \}
- [Exceptions Value Expressions DRIVER:ODBCJT32.DLL]
- Current_Date=F
- [Database Functions DRIVER:WOD50T.DLL]
- c:substring(%1c, %2n, %3n)=CAST(SUBSTR(%1, %2, %3) as varchar(2000))
- n:cast_decimal(%1n)=CAST(%1 AS DECIMAL)
- [Database Functions DRIVER:WOD50T.DLL VERSION:05.00]
- n:position(%1c, %2c {, %3n})=\{fn LOCATE(%2, %1 {, %3})\}
- [Database Functions DRIVER:WOD50W.DLL VERSION:05.00]
- n:position(%1c, %2c {, %3n})=\{fn LOCATE(%2, %1 {, %3})\}
- [Database Functions DRIVER:SYIQNT.DLL]
- c:cast_numberToString(%1bcdinst)=CAST(%1 AS CHAR(254))
- [Database Functions DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- s:localtimestamp({%1n})=CURRENT_TIMESTAMP
- [Exceptions Aggregates]
- Avg="avg"
- Count="count"
- Count_star="count(*)"
- Max="max"
- Min="min"
- Sum="sum"
- [Exceptions Aggregate DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Avg=
- Count=
- Count_star=
- Max=
- Min=
- Sum=
- Between=
- In=
- Like=
- Is_Null=
- Any=
- All=
- Exists=
- Unique=
- Match=
- Overlaps=
- NotLike=
- [Exceptions Aggregates DRIVER:DTLODBC.DLL]
- Avg=
- Count=
- Count_star=
- Max=
- Min=
- Sum=
- [Exceptions Clauses]
- From="from"
- Group_By="group by"
- Having="having"
- Where="where"
- [Exceptions Clauses DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Group_By=
- Having=
- Where=
- [Exceptions Clauses DRIVER:DTLODBC.DLL]
- Group_By=
- Having=
- Where=
- [Exceptions Clauses DATABASE:NETEZZASQL]
- With="with "
- [Exceptions Clauses DATABASE:NETEZZASQL VERSION:05]
- With=
- [Exceptions Clauses DATABASE:NETEZZASQL VERSION:04]
- With=
- [Exceptions Clauses DATABASE:NETEZZASQL VERSION:03]
- With=
- [Exceptions Commands]
- Call="call "
- Delete="delete "
- Insert="insert "
- Select="select "
- Update="update "
- [Exceptions Commands DRIVER:DTLODBC.DLL]
- Call=
- Select_Star="F"
- [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=F
- Cross_Product=T
- Distinct_Aggregates=T
- Group_By_Expr=F
- Like_Value_Expr=F
- Multiple_Distinct=T
- Nulls_Sort_Last=F
- Order_By_Alias=F
- Substring_On_Expr=T
- Subqueries=T
- Subquery_Column_Alias=F
- [Exceptions General DATABASE:ADAPTIVE SERVER ANYWHERE]
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- [Exceptions General DATABASE:COMPOSITE]
- Count_Value_Expr=T
- Count_Literal=T
- Distinct_Aggregates=F
- Group_By_Expr=T
- [Exceptions General DRIVER:DTLODBC.DLL]
- Aggregate_In_Expr=F
- Aggregate_Value_Expr=F
- Correlated_Subqueries=F
- Count_Non_Distinct=F
- Cross_Product=F
- Distinct_Aggregates=F
- Multiple_Distinct=F
- Order_By_Name=F
- Substring_On_Expr=F
- Subqueries=F
- Aggregate_Literal=F
- Group_By_In_Exists=F
- Group_By_Sorted=F
- Nested_Case=F
- Null=
- Subquery_In_Group_By=F
- Not_In_Subquery=F
- Subquery_In_Case=F
- Subquery_In_Having=F
- Group_By_Strict=F
- [Exceptions General DRIVER:EHNODBC3.DLL]
- Correlated_Subqueries=F
- [Exceptions General DATABASE:NETEZZASQL]
- Olap_Null_Order=T
- Localtime=C
- Localtimestamp=C
- Count_Value_Expr=T
- Count_Literal=T
- Distinct_Aggregates=T
- Group_By_Expr=T
- Correlated_Subqueries=T
- Is_Null_Value_Expr=T
- Order_By_In_Derived_Table=T
- Is_Null_Value_Parm=T
- [Exceptions General DATABASE:NETEZZASQL VERSION:04.00]
- Olap_Null_Order=F
- [Exceptions General DATABASE:NETEZZASQL VERSION:04.05]
- Olap_Null_Order=F
- [Exceptions General DATABASE:NETEZZASQL VERSION:03]
- Olap_Null_Order=F
- [Exceptions General DRIVER:ODBCJT16.DLL]
- Distinct_Aggregates=F
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- Order_By_Alias=F
- [Exceptions General DRIVER:ODBCJT32.DLL]
- Count_Literal=T
- Distinct_Aggregates=F
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- Order_By_Alias=F
- Like_With_Escape=F
- Group_By_Expr=T
- Jet_Aliases=T
- [Exceptions General DRIVER:ACEODBC.DLL]
- Distinct_Aggregates=F
- [Exceptions General DRIVER:ODNAV32.DLL]
- Like_Value_Expr=T
- Group_By_Expr=T
- [Exceptions General DRIVER:CACHEODBC.DLL]
- Group_By_Expr=T
- Remove_Parameter_Cast=T
- [Exceptions General DRIVER:QEDBF06.DLL]
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:QEDBF07.DLL]
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:QESYB07.DLL]
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:SCLIW16.DLL]
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:SQRDB.DLL]
- Count_Non_Distinct=F
- Like_Value_Expr=T
- [Exceptions General DRIVER:WOD40T.DLL]
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:WOD40W.DLL]
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:WOD50T.DLL]
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:WOD50W.DLL]
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- [Exceptions General DRIVER:WSQLODBC.DLL]
- Like_Value_Expr=T
- Nulls_Sort_Last=F
- [Exceptions General DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- Parameter_Markers=F
- [Exceptions Joins DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Inner=F
- Left_Outer=F
- Right_Outer=F
- Full_Outer=F
- Cross=F
- Product_Join=F
- Optnl_Tbl_Filter=F
- Prsrv_Tbl_Filter=F
- On_Condition_Set_Functions=F
- On_Condition_Between_Predicate=F
- Non_Join_Expr=F
- Non_Join_Non_Equi_Expr=F
- [Exceptions Joins DRIVER:PGPRO1019.DLL]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Outer=F
- Full_Post=""
- Full_Pre=""
- Full_Syntax=""
- Inner=T
- Inner_Col_Post="(+)"
- Left_Eql=" = "
- Left_Nested=T
- Left_Post=""
- Left_Pre=""
- Natural=T
- Natural_Syntax=" NATURAL JOIN "
- Nested_Inner=F
- Nested_Outer=T
- Non_Equi_Joins=T
- On_Condition_Between_Predicate=T
- On_Condition_In_Predicate=T
- On_Condition_Like_Predicate=T
- One_Outer=F
- Optnl_Tbl_Filter=T
- Optnl_Tbl_Join_Filter=T
- Optnl_Tbl_Restrict=F
- Outer_Syntax=F
- Right_Eql=" = "
- Right_Post=""
- Right_Pre=""
- [Exceptions Joins]
- Cross=F
- Cross_Syntax=""
- Full_Non_Equi_Join=F
- Full_Outer=T
- Full_Post=" } "
- Full_Pre=" {oj "
- Full_Syntax=" FULL OUTER JOIN "
- Inner=F
- Inner_Col_Post=""
- Inner_Col_Pre=""
- Inner_Syntax=" INNER JOIN "
- Inner_Tbl_Restrict=F
- Left_Eql=" LEFT OUTER JOIN "
- Left_Nested=F
- Left_Outer=T
- Left_Post=" } "
- Left_Pre=" {oj "
- Natural=F
- Natural_Syntax=""
- Nested_Outer=F
- Non_Equi_Joins=F
- One_Outer=F
- On_Condition_Between_Predicate=F
- On_Condition_In_Predicate=F
- On_Condition_IsNull_Predicate=T
- On_Condition_Like_Predicate=F
- On_Condition_Not_Predicate=T
- On_Condition_Set_Functions=F
- On_Condition_Subqueries=T
- Optnl_Tbl_Filter=F
- Optnl_Tbl_Join_Filter=F
- Optnl_Tbl_Join_Restrict=F
- Outer_Tbl_List=F
- Optnl_Tbl_Restrict=T
- Outer_Syntax=T
- Right_Eql=" RIGHT OUTER JOIN "
- Right_Nested=T
- Right_Outer=T
- Right_Post=" } "
- Right_Pre=" {oj "
- Two_Sided_Join_Restrict=F
- Union_Syntax=""
- [Exceptions Joins DATABASE:ADAPTIVE SERVER ANYWHERE]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Outer=F
- Full_Post=""
- Full_Pre=""
- Full_Syntax=""
- Inner=T
- Inner_Syntax=" INNER JOIN "
- Left_Eql=" LEFT OUTER JOIN "
- Left_Nested=T
- Left_Outer=T
- Left_Post=""
- Left_Pre=""
- Natural=T
- Natural_Syntax=" NATURAL JOIN "
- 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_Set_Functions=F
- On_Condition_Subqueries=T
- One_Outer=F
- Optnl_Tbl_Filter=T
- Optnl_Tbl_Join_Filter=T
- 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=""
- Two_Sided_Join_Restrict=F
- Union_Syntax=""
- [Exceptions Joins DRIVER:CACHEODBC.DLL]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Outer=F
- Full_Post=""
- Full_Pre=""
- Full_Syntax=""
- Inner=T
- Inner_Syntax=" INNER JOIN "
- Left_Eql=" LEFT OUTER JOIN "
- Left_Nested=T
- Left_Outer=T
- Left_Post=""
- Left_Pre=""
- On_Condition_Not_Predicate=F
- Optnl_Tbl_Restrict=F
- Right_Eql=" RIGHT OUTER JOIN "
- Right_Nested=T
- Right_Post=""
- Right_Pre=""
- Inner_Tbl_Restrict=T
- Optnl_Tbl_Restrict=T
- Nested_Inner=F
- Right_Outer=F
- Optnl_Tbl_Filter=T
- [Exceptions Joins DRIVER:DTLODBC.DLL]
- Full_Outer=F
- Full_Post=
- Full_Pre=
- Full_Syntax=
- Left_Eql=
- Left_Outer=F
- Left_Post=
- Left_Pre=
- On_Condition_IsNull_Predicate=F
- On_Condition_Not_Predicate=F
- On_Condition_Subqueries=F
- Outer_Syntax=F
- Right_Nested=F
- Right_Outer=F
- Inner_Tbl_Restrict=F
- Nested_Inner=F
- Non_Join_Expr=F
- Non_Join_Non_Equi_Expr=F
- On_Condition_Functions=F
- Optnl_Tbl_Restrict=F
- Prsrv_Tbl_Filter=F
- Prsrv_Tbl_Join_Filter=F
- Right_Eql=
- [Exceptions Joins DATABASE:NETEZZASQL]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Non_Equi_Join=F
- Full_Outer=T
- Full_Post=""
- Full_Pre=""
- Full_Syntax=" FULL OUTER JOIN "
- Inner=T
- Inner_Syntax=" INNER JOIN "
- Left_Eql=" LEFT OUTER JOIN "
- Left_Nested=T
- Left_Outer=T
- Left_Post=""
- Left_Pre=""
- Optnl_Tbl_Restrict=F
- Inner_Tbl_Restrict=F
- Right_Eql=" RIGHT OUTER JOIN "
- Right_Nested=T
- Right_Outer=T
- Right_Post=""
- Right_Pre=
- 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=T
- [Exceptions Joins DATABASE:SYBASE SQL ANYWHERE]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Outer=F
- Full_Post=""
- Full_Pre=""
- Full_Syntax=""
- Inner=T
- Inner_Syntax=" INNER JOIN "
- Left_Eql=" LEFT OUTER JOIN "
- Left_Nested=T
- Left_Outer=T
- Left_Post=""
- Left_Pre=""
- Natural=T
- Natural_Syntax=" NATURAL JOIN "
- 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_Set_Functions=F
- On_Condition_Subqueries=T
- One_Outer=F
- Optnl_Tbl_Filter=T
- Optnl_Tbl_Join_Filter=T
- 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=""
- Two_Sided_Join_Restrict=F
- Union_Syntax=""
- [Exceptions Joins DATABASE:COMPOSITE]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Inner=T
- Inner_Syntax=" INNER JOIN "
- On_Condition_In_Predicate=T
- On_Condition_Like_Predicate=T
- On_Condition_Or_Predicate=T
- Full_Post=""
- Full_Pre=""
- Left_Post=""
- Left_Pre=""
- Right_Post=""
- Right_Pre=""
- [Exceptions Joins DRIVER:ODBCJT32.DLL]
- Full_Outer=F
- Left_Outer=T
- Left_Post=""
- Left_Pre=""
- On_Condition_IsNull_Predicate=F
- On_Condition_Subqueries=F
- One_Outer=T
- Prsrv_Tbl_Join_Filter=F
- Right_Outer=T
- Right_Post=""
- Right_Pre=""
- [Exceptions Joins DRIVER:OPENA.DLL]
- Nested_Outer=T
- [Exceptions Joins DRIVER:SWODBC32.DLL]
- Left_Nested=T
- [Exceptions Joins DRIVER:TDMSRVR.DLL]
- Left_Nested=F
- Nested_Outer=F
- Right_Nested=T
- [Exceptions Joins DRIVER:TDMSRVR32.DLL]
- Left_Nested=F
- Nested_Outer=F
- Right_Nested=T
- [Exceptions Joins DRIVER:ODNAV32.DLL]
- Cross=T
- Cross_Syntax=" , "
- Inner=T
- Nested_Outer=T
- Non_Equi_Joins=T
- One_Outer=T
- Full_Outer=F
- On_Condition_Between_Predicate=T
- On_Condition_In_Predicate=T
- On_Condition_Like_Predicate=T
- On_Condition_Not_Predicate=T
- [Exceptions Joins DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- On_Condition_Or_Predicate=F
- Full_Post=""
- Full_Pre=""
- Left_Post=""
- Left_Pre=""
- Right_Post=""
- Right_Pre=""
- Full_Outer=F
- Full_Syntax=
- [Exceptions Joins DATABASE:HP NEOVIEW DATABASE]
- On_Condition_Between_Predicate=T
- On_Condition_In_Predicate=T
- On_Condition_Like_Predicate=T
- On_Condition_Or_Predicate=T
- On_Condition_Set_Functions=T
- On_Condition_Not_Predicate=T
- On_Condition_Isnull_Predicate=T
- [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="{d '%s-%s-%s'}"
- Date_Sub_Function_Str=
- False_Literal_Str=
- Interval_Format_Str=
- Interval_Literal=F
- Interval_Literal_Str=
- IntervalYM_Format_Str=
- IntervalYM_Literal=F
- IntervalYM_Literal_Str=
- Time_Format_Str="HH MM SS"
- Time_Literal=C
- Time_Literal_Str="{t '%s:%s:%s'}"
- TimeTZ_Format_Str=
- TimeTZ_Literal=F
- TimeTZ_Literal_Str=
- Timestamp_Format_Str="YYYY MM DD HH MM SS"
- Timestamp_Literal=C
- Timestamp_Literal_Str="{ts '%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=
- [Exceptions Literals DATABASE:IBM COGNOS REAL-TIME MONITORING]
- NChar_Literal=F
- [Exceptions Literals DATABASE:NETEZZASQL]
- Date_Literal_Str="DATE '%s-%s-%s'"
- Time_Literal_Str="TIME '%s:%s:%s.%s'"
- Timestamp_Literal_Str="TIMESTAMP '%s-%s-%s %s:%s:%s.%s'"
- Time_Format_Str="HH MM SS FFFFFF"
- NChar_Literal=T
- [Exceptions Literals DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- Date_Literal_Str="DATE '%s-%s-%s'"
- Timestamp_Literal_Str="TIMESTAMP '%s-%s-%s %s:%s:%s'"
- [Exceptions Operators]
- Add="+"
- And="and"
- Div="/"
- Eql="="
- Geq=">="
- Grt=">"
- Leq="<="
- Les="<"
- Mul="*"
- Neq="<>"
- Not="not"
- Or="or"
- Sub="-"
- [Exceptions Operators DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Add=
- Sub=
- Mul=
- Div=
- Eql=
- Neq=
- Grt=
- Geq=
- Les=
- Leq=
- Neg=
- And=
- Or=
- Not=
- [Exceptions Operators DRIVER:DTLODBC.DLL]
- Add=
- And=
- Div=
- Eql=
- Geq=
- Grt=
- Leq=
- Les=
- Mul=
- Neg=
- Neq=
- Not=
- Or=
- Sub=
- [Exceptions Predicates]
- All=
- Exists="exists "
- [Exceptions Predicates DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Between=
- In=
- Like=
- Is_Null=
- Any=
- All=
- Exists=
- Unique=
- Match=
- Overlaps=
- NotLike=
- [Exceptions Predicates DATABASE:SYBASE SQL ANYWHERE]
- All="all"
- [Exceptions Predicates DRIVER:DTLODBC.DLL]
- Any=
- Exists=
- Between=
- In=
- Is_Null=
- Like=
- Match=
- NotLike=
- Unique=
- [Exceptions Predicates DATABASE:NETEZZASQL]
- All="all"
- [Exceptions Predicates DRIVER:ODBCJT32.DLL]
- All="all"
- [Exceptions Predicates DATABASE:COMPOSITE]
- Any=
- Between=
- Exists=
- [Exceptions Separators]
- Catalog_Separator="."
- Schema_Separator="."
- Table_Separator="."
- [Exceptions Set Operators]
- Distinct=
- Except=
- Except_All=F
- Intersect=
- Intersect_All=F
- Union=
- Union_All=F
- [Exceptions Set Operators DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Order_By=
- Order_By_Limit="0"
- [Exceptions Set Operators DRIVER:DTLODBC.DLL]
- Distinct=
- Order_By=
- Order_By_Limit="0"
- [Exceptions Set Operators DRIVER:ODBCJT32.DLL]
- Distinct="distinct"
- [Exceptions Set Operators DRIVER:ACEODBC.DLL]
- Distinct="distinct"
- [Exceptions Set Operators DRIVER:ODNAV32.DLL]
- Distinct="distinct"
- [Exceptions Set Operators DRIVER:CACHEODBC.DLL]
- Distinct="distinct"
- Union="union"
- Union_All=T
- [Exceptions Set Operators DATABASE:COMPOSITE]
- Distinct="distinct"
- [Exceptions Set Operators DATABASE:NETEZZASQL]
- Distinct="distinct"
- Except=" except "
- Except_All=T
- Intersect="intersect"
- Intersect_All=T
- Union="union"
- Union_All=T
- [Exceptions Tables]
- Derived=F
- Joined=F
- Simple=T
- UniqueName_Prefix="coguda"
- [Exceptions Tables DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Derived=F
- Joined=F
- Simple_And_Joined=F
- UniqueName_Prefix="coguda"
- [Exceptions Tables DATABASE:ADAPTIVE SERVER ANYWHERE]
- Derived=T
- [Exceptions Tables DATABASE:RDB]
- Derived=T
- [Exceptions Tables DRIVER:DTLODBC.DLL]
- Simple_And_Joined=F
- [Exceptions Tables DATABASE:NETEZZASQL]
- Derived=T
- Joined=T
- [Exceptions Tables DRIVER:ODBCJT32.DLL]
- Derived=T
- Simple_And_Joined=F
- [Exceptions Tables DRIVER:ODNAV32.DLL]
- Joined=T
- Derived=T
- [Exceptions Tables DRIVER:CACHEODBC.DLL]
- Derived=T
- [Exceptions Tables DATABASE:COMPOSITE]
- Derived=T
- Joined=T
- [Exceptions Tables DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- Joined=T
- [Exceptions Value Expressions]
- Bit_Length=F
- Case=F
- Cast=F
- Char_Length=F
- Coalesce=F
- Extract=F
- Lower=F
- Nullif=F
- Octet_Length=F
- Position=F
- StrCat=F
- Substring=F
- Upper=F
- [Exceptions Value Expressions DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Case=T
- Case_Simple=T
- Case_Searched=F
- Trim=F
- Cast=C
- Char_Length=F
- Lower=T
- Position=T
- Substring=T
- Upper=T
- Current_Date=F
- Current_Time=F
- Current_Timestamp=F
- Localtime=F
- Localtimestamp=F
- Abs=T
- Ceiling=C
- Exp=T
- Floor=T
- ln=F
- Mod=T
- Sqrt=T
- Trim_Both_Spaces=C
- Trim_Leading_Spaces=C
- Trim_Trailing_Spaces=C
- Power=T
- [Exceptions Value Expressions DATABASE:ADAPTIVE SERVER ANYWHERE]
- Case=T
- Case_Simple=T
- Case_Searched=T
- [Exceptions Value Expressions DRIVER:DTLODBC.DLL]
- NullConst=F
- [Exceptions Value Expressions DRIVER:ODNAV32.DLL]
- Case=T
- Case_Simple=T
- Case_Searched=T
- [Exceptions Value Expressions DRIVER:CACHEODBC.DLL]
- Case=T
- Case_Simple=T
- Case_Searched=T
- Coalesce=T
- Cast=T
- StrCat=T
- [Exceptions Value Expressions DATABASE:COMPOSITE]
- case=T
- Case_Simple=T
- Case_Searched=T
- Cast=T
- Char_Length=F
- Coalesce=F
- Extract=F
- Lower=T
- Nullif=F
- StrCat=T
- Substring=T
- Upper=T
- [Exceptions Value Expressions DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- Case_Simple=T
- Trim=T
- Mod=F
- Strcat=T
- Current_Date=T
- Current_Timestamp=F
- Localtimestamp=C
- [Exceptions Value Expressions DATABASE:NETEZZASQL]
- Bit_Length=F
- abs=T
- Case=T
- Cast=T
- Ceiling=T
- Char_Length=T
- Coalesce=T
- Exp=T
- Extract=T
- Current_Date=T
- Current_Time=F
- Current_Timestamp=F
- floor=T
- Lower=T
- Ln=T
- Nullif=T
- mod=T
- position=T
- power=T
- sqrt=T
- StrCat=T
- Substring=T
- trim=T
- Upper=T
- [Exceptions OLAP Functions]
- [Exceptions OLAP Functions DATABASE:NETEZZASQL]
- Olap_Distinct=T
- Olap_First_Value="first_value"
- Olap_Last_Value="last_value"
- Olap_Last_Value_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING"
- Olap_Variance="variance"
- Olap_Max="max"
- Olap_Min="min"
- Olap_Sum="sum"
- Olap_Avg="avg"
- Olap_Count="count"
- Olap_Count_Star="count(*)"
- Olap_Stddev_Pop="stddev_pop"
- Olap_Var_Pop="var_pop"
- Olap_Stddev_Samp="stddev_samp"
- Olap_Var_Samp="var_samp"
- Olap_Rank="rank"
- Olap_Dense_Rank="dense_rank"
- Olap_Row_Number="row_number"
- Olap_Percent_Rank="percent_rank"
- Olap_Cume_Dist="cume_dist"
- Olap_Ntile="ntile"
- [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:05.00]
- Olap_Percent_Rank=
- Olap_Cume_Dist=
- Olap_Ntile=
- [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:04.00]
- Olap_Distinct=F
- Olap_Percent_Rank=
- Olap_Cume_Dist=
- Olap_Ntile=
- [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:04.06]
- Olap_Percent_Rank=
- Olap_Cume_Dist=
- Olap_Ntile=
- [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:04.05]
- Olap_Distinct=F
- Olap_Percent_Rank=
- Olap_Cume_Dist=
- Olap_Ntile=
- [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:03]
- Olap_Distinct=F
- Olap_Percent_Rank=
- Olap_Cume_Dist=
- Olap_Ntile=
- [Operator Addition]
- Date=
- Time=
- Timestamp=
- Interval=
- [Operator Addition DATABASE:COMPOSITE]
- Date=DT,DT:TS,TS
- Timestamp=DT,TS:TS,TS
- [Operator Subtraction]
- Date=
- Time=
- Timestamp=
- Interval=
- [Operator Comparison DATABASE:COMPOSITE]
- Date=DT,OK
- Time=TM,OK
- Timestamp=TS,OK
- Interval=
- [Operator Comparison DATABASE:ADAPTIVE SERVER ANYWHERE]
- Date=DT,OK:TS,OK
- Timestamp=DT,OK:TS,OK
- Time=TM,OK:TS,OK
- [Operator Comparison DATABASE:NETEZZASQL]
- Date=DT,OK:TS,OK
- Time=TM,OK:TS,OK
- Timestamp=DT,OK:TS,OK
- Interval=
- [Operator Comparison DATABASE:SYBASE SQL ANYWHERE]
- Date=DT,OK:TS,OK
- Timestamp=DT,OK:TS,OK
- Time=TM,OK:TS,OK
- [Operator Comparison DRIVER:ODBCJT32.DLL]
- Date=DT,OK:TS,OK
- Timestamp=DT,OK:TS,OK
- Time=TM,OK:TS,OK
- [Operator Comparison DATABASE:ADAPTER FOR BAANERP DB DRIVER]
- Date=DT,OK
- Timestamp=TS,OK
- Interval=
- Time=
- [DATABASE:COMPOSITE]
- Function Esc Prefix=" "
- Function Esc Suffix=" "
- [DATABASE:ADAPTIVE SERVER ANYWHERE]
- DBINFO_TYPE="OD_IQ"
- [DATABASE:ADAPTIVE SERVER IQ]
- DBINFO_TYPE="OD_IQ"
- [DATABASE:SYBASE IQ]
- DBINFO_TYPE="OD_IQ"
- [DATABASE:INFORMIX]
- DBINFO_TYPE="IF"
- [DATABASE:INGRES]
- DBINFO_TYPE="OD_IG"
- DBINFO_SUBSECTIONS="DBNAM"
- [DATABASE:INTERBASE]
- DBINFO_TYPE="OD_IB"
- [DATABASE:INTERBASE VERSION:05.05]
- DBINFO_SUBTYPE="Version:5.5"
- [DATABASE:INTERBASE VERSION:05.06]
- DBINFO_SUBTYPE="Version:5.6"
- [DATABASE:MICROSOFT SQL SERVER]
- DBINFO_TYPE="MS"
- DBINFO_SUBSECTIONS="DBNAM"
- Exec_JoinOrder_NoJoinOrder="SET FORCEPLAN OFF"
- Exec_JoinOrder_OrderedJoin="SET FORCEPLAN ON"
- Procedure Cursors="T"
- Unicode Literals="F"
- Function Name Suffix="
- SetSubqueryParamInfo="T"
- Disable_Subquery_With_Parameters="T"
- [DATABASE:MICROSOFT SQL SERVER VERSION:06.00]
- DBINFO_SUBTYPE="Version:6.0"
- Unicode Literals="F"
- [DATABASE:MICROSOFT SQL SERVER VERSION:06.50]
- DBINFO_SUBTYPE="Version:6.5"
- Unicode Literals="F"
- [DATABASE:MICROSOFT SQL SERVER VERSION:07.00]
- DBINFO_SUBTYPE="Version:7.0"
- [DATABASE:MICROSOFT SQL SERVER VERSION:08.00]
- DBINFO_SUBTYPE="Version:8.0"
- SQL_API_SQLPROCEDURES="TRUE:SELECT CATALOG, SCHEMAA, NAME, 0, 0, 0, '', TYPE FROM (SELECT SPECIFIC_CATALOG AS CATALOG, SPECIFIC_SCHEMA AS SCHEMAA, SPECIFIC_NAME AS NAME, ( CASE ROUTINE_TYPE WHEN 'PROCEDURE' THEN 1 WHEN 'FUNCTION' THEN 2 ELSE 0 END ) AS TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE IN ('FUNCTION', 'PROCEDURE') AND ( DATA_TYPE != 'TABLE' OR DATA_TYPE IS NULL ) UNION SELECT SPECIFIC_CATALOG AS CATALOG, SPECIFIC_SCHEMA AS SCHEMAA, SPECIFIC_NAME AS NAME, 3 AS TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE IN ('FUNCTION') AND DATA_TYPE = 'TABLE' ) AS T WHERE CATALOG ?1 AND SCHEMAA ?2 AND NAME ?3"
- [DATABASE:NETEZZASQL]
- User Tables="'TABLE','EXTERNAL TABLE'"
- Functions Are Procedures="T"
- CLOSE_HSTMT_AT_EOD="T"
- Bulk Insert Supported="T"
- RELEASE_SUBCONNECTION="T"
- [DATABASE:ORACLE]
- DBINFO_TYPE="OR"
- DBINFO_SUBSECTIONS="DBNAM"
- Exec_OptimizerGoal_FirstRow="ALTER SESSION SET OPTIMIZER_GOAL = FIRST_ROWS"
- Exec_OptimizerGoal_AllRows="ALTER SESSION SET OPTIMIZER_GOAL = ALL_ROWS"
- Set User As Default Schema="T"
- [DATABASE:ORACLE VERSION:07.03]
- DBINFO_SUBTYPE="ORACLE7.3"
- [DATABASE:ORACLE VERSION:08.00]
- DBINFO_SUBTYPE="ORACLE8.0"
- [DATABASE:ORACLE VERSION:08.01]
- DBINFO_SUBTYPE="ORACLE8.1"
- [DATABASE:NETEZZASQL]
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- [DATABASE:RED BRICK WAREHOUSE]
- DBINFO_TYPE="OD_RB"
- DBINFO_SUBSECTIONS="DBNAM"
- State Overwrite 0="CCLMSG_UDA_SQL_GENERAL SQL_API_SQLCANCEL WS000 01S05"
- Exec_DegreeOfParallelism="SET QUERYPROCS %d"
- Exec_RowLimit_Set="SET ROWCOUNT %d"
- Exec_RowLimit_Reset="SET ROWCOUNT 0"
- System View Supported="F"
- System Alias Supported="F"
- System Synonym Supported="F"
- [DATABASE:RED BRICK WAREHOUSE VERSION:06.00]
- DBINFO_SUBTYPE="Version:6.0"
- [DATABASE:RED BRICK WAREHOUSE VERSION:06.10]
- DBINFO_SUBTYPE="Version:6.1"
- [DATABASE:RED BRICK WAREHOUSE VERSION:06.11]
- DBINFO_SUBTYPE="Version:6.11"
- [DATABASE:RED BRICK WAREHOUSE VERSION:06.20]
- DBINFO_SUBTYPE="Version:6.20"
- [DATABASE:RED BRICK WAREHOUSE VERSION:06.30]
- DBINFO_SUBTYPE="Version:6.30"
- [DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Keyword Alias=" as %s "
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- Parameter_In_Select_List="F"
- Subquery_With_Parameters="F"
- Like_With_Parameters="F"
- Disable_Subquery_With_Parameters="F"
- [DATABASE:SQLBase]
- DBINFO_TYPE="SB"
- Keyword Alias=" as %s "
- [DRIVER:SYODASE.DLL DATABASE:SQL SERVER]
- DBINFO_TYPE="CT"
- [DATABASE:SQL SERVER VERSION:12.50]
- DBINFO_SUBTYPE="Version:12.50"
- [DRIVER:Adaptive Server Enterprise Version:15]
- DBINFO_TYPE="CT"
- [DATABASE:SYBASE]
- DBINFO_TYPE="CT"
- Exec_JoinOrder_NoJoinOrder="SET FORCEPLAN OFF"
- Exec_JoinOrder_OrderedJoin="SET FORCEPLAN ON"
- Exec_DegreeOfParallelism="SET PARALLEL_DEGREE %d"
- [DATABASE:SYBASE VERSION:11.00]
- DBINFO_SUBTYPE="Version:11.0"
- [DATABASE:SYBASE VERSION:11.05.0000]
- DBINFO_SUBTYPE="Version:11.5.0"
- [DATABASE:SYBASE VERSION:11.05.0001]
- DBINFO_SUBTYPE="Version:11.5.1"
- [DATABASE:SYBASE VERSION:11.09.0001]
- DBINFO_SUBTYPE="Version:11.9.1"
- [DATABASE:SYBASE VERSION:11.09.0002]
- DBINFO_SUBTYPE="Version:11.9.2"
- [DATABASE:SYBASE VERSION:11.09.0003]
- DBINFO_SUBTYPE="Version:11.9.3"
- [DATABASE:SYBASE SQL ANYWHERE]
- SQL_OUTER_JOINS=""
- SQL_OJ_CAPABILITIES=""
- SQL_CONVERT_FUNCTIONS="3"
- [DATABASE:TERADATA]
- DBINFO_TYPE="OD_TD"
- [DATABASE:TERADATA VERSION:06.00]
- DBINFO_SUBTYPE="VERSION:06.00"
-
- [DATABASE:TERADATA VERSION:05.01]
- DBINFO_SUBTYPE="VERSION:05.01"
- [DATABASE:TERADATA VERSION:05.00.0102]
- DBINFO_SUBTYPE="VERSION:05.00.01"
- [DATABASE:TERADATA VERSION:05.00]
- DBINFO_SUBTYPE="VERSION:05.00"
- [DATABASE:TERADATA VERSION:04.00]
- DBINFO_SUBTYPE="VERSION:04.00"
- [DATABASE:TERADATA VERSION:04.01]
- DBINFO_SUBTYPE="VERSION:04.01"
- [DATABASE:TERADATA VERSION:03.00]
- DBINFO_SUBTYPE="VERSION:03.00"
- [DATABASE:TERADATA VERSION:02.00]
- DBINFO_SUBTYPE="VERSION:02.00"
- [DATABASE:TERADATA VERSION:02.01]
- DBINFO_SUBTYPE="VERSION:02.01"
- [DATABASE:DSN]
- DBINFO_TYPE="D2"
- [DATABASE:QSQ]
- DBINFO_TYPE="D2"
- [DATABASE:SQL]
- DBINFO_TYPE="D2"
- [DATABASE:VERTICA DATABASE]
- DBINFO_TYPE="OD_VE"
- [DATABASE:INFOSPHERE CLASSIC FEDERATION]
- DBINFO_TYPE="OD_CF"
- [DATABASE:WEBSPHERE CLASSIC FEDERATION]
- DBINFO_TYPE="OD_CF"
- [DATABASE:POSTGRESQL]
- DBINFO_TYPE="OD_POSTG"
- [DATABASE:PARACCEL]
- DBINFO_TYPE="OD_PA"
- [DATABASE:GREENPLUM]
- DBINFO_TYPE="OD_GP"
- [DATABASE:NCLUSTER]
- DBINFO_TYPE="OD_AST"
- [DATABASE:INGRES_VECTORWISE]
- DBINFO_TYPE="OD_IVW"
- [DRIVER:ADBC32.DLL]
- SQL_DRIVER_VER="12.78"
- SQL_MAX_TABLE_NAME_LEN="128"
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- [DRIVER:ALLBASE.DLL]
- SQL_OUTER_JOINS="N"
- [DRIVER:ARODBC40.DLL]
- Convert To Blob Limit="255"
- [DRIVER:C2GUP14.DLL]
- SQL_API_SQLDESCRIBECOL="FALSE"
- SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_LENGTH,SQL_COLUMN_UNSIGNED,SQL_COLUMN_UPDATABLE,SQL_COLUMN_NAME,SQL_COLUMN_PRECISION,SQL_COLUMN_SCALE,SQL_COLUMN_TYPE"
- [DRIVER:CACHEODBC.DLL]
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- SQL_QUALIFIER_TERM=""
- SQL_API_SQLFETCHSCROLL="FALSE"
- [DRIVER:EDAODBC.DLL]
- SQL_API_SQLPREPARE="FALSE"
- [DRIVER:EHNODBC3.DLL]
- Select For Fetch Only="T"
- [DRIVER:FASTPATH.DLL]
- SQL_NON_NULLABLE_COLUMNS="0"
- [DRIVER:HSOPT32.DLL]
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- [DRIVER:IBINT13.DLL]
- SQL_DBMS_NAME="INTERBASE"
- SQL_DBMS_VER="Format String:WI-V%3s"
- SQL_CONVERT_FUNCTIONS="0"
- [DRIVER:IVDBF12.DLL]
- SQL_DBMS_NAME="DBASE"
- SQL_QUALIFIER_TERM=""
- [DRIVER:IVDBF14.DLL]
- SQL_DBMS_NAME="DBASE"
- SQL_QUALIFIER_TERM=""
- [DRIVER:IVGUP14.DLL]
- SQL_API_SQLDESCRIBECOL="FALSE"
- SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_LENGTH,SQL_COLUMN_UNSIGNED,SQL_COLUMN_UPDATABLE,SQL_COLUMN_NAME,SQL_COLUMN_PRECISION,SQL_COLUMN_SCALE,SQL_COLUMN_TYPE"
- [DRIVER:IVINF709.DLL]
- SQL_DBMS_NAME="INFORMIX"
- [DRIVER:IVINF914.DLL]
- SQL_DBMS_NAME="INFORMIX"
- SQL_COLUMN_ALIAS="Y"
- [DRIVER:IVMSSS18.SO]
- Threaded Open="T"
- [DRIVER:IVMSSS18.SL]
- Threaded Open="T"
- [DRIVER:IVMSSS19.SO]
- Threaded Open="T"
- [DRIVER:IVMSSS19.SL]
- Threaded Open="T"
- [DRIVER:IVMSSS20.SO]
- Threaded Open="T"
- [DRIVER:IVMSSS20.SL]
- Threaded Open="T"
- [DRIVER:IVOR708.DLL]
- SQL_DBMS_NAME="ORACLE"
- SQL_DBMS_VER="07.03"
- [DRIVER:IVOR712.DLL]
- SQL_DBMS_NAME="ORACLE"
- SQL_DBMS_VER="07.03"
- [DRIVER:IVOR713.DLL]
- SQL_DBMS_NAME="ORACLE"
- SQL_DBMS_VER="07.03"
- [DRIVER:IVOR813.DLL]
- SQL_DBMS_NAME="ORACLE"
- SQL_DBMS_VER="08.00"
- [DRIVER:IVOR814.DLL]
- SQL_DBMS_NAME="ORACLE"
- SQL_DBMS_VER="08.00"
- SQL_MAX_TABLE_NAME_LEN="128"
- [DRIVER:IVOR815.DLL]
- SQL_DBMS_NAME="ORACLE"
- SQL_DBMS_VER="08.01"
- [DRIVER:IVSS612.DLL]
- SQL_DBMS_NAME="MICROSOFT SQL SERVER"
- SQL_DBMS_VER="Format String:Microsoft SQL Server %4s"
- [DRIVER:IVSYB12.DLL]
- SQL_DBMS_NAME="SYBASE"
- [DRIVER:MSORCL32.DLL]
- SQL_DRIVER_VER="Format String:%5s"
- [DRIVER:NODBC.DLL]
- SQL_DBMS_NAME="Microsoft Business Solutions-Navision"
- SQL_DBMS_VER="05.00"
- [DRIVER:NSQLV32.DLL]
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- SQL_API_SQLFETCHSCROLL="FALSE"
- Unsigned Positive Numbers="T"
- [DRIVER:ODBCJT32.DLL]
- Keyword Ascending=""
- Convert To Blob Limit="255"
- Disable Transaction Support="T"
- Select For Update Disabled="T"
- Keyword Alias=" as [%s] "
- SQL_COLUMN_ALIAS="Y"
- SQL_QUALIFIER_TERM=""
- [DRIVER:ACEODBC.DLL]
- Disable Transaction Support="T"
- Keyword Alias=" as [%s] "
- [DRIVER:PSQODB32.DLL]
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- SQL_IDENTIFIER_QUOTE_CHAR=""
- SQL_MAX_TABLE_NAME_LEN="128"
- SQL_API_SQLNATIVESQL="FALSE"
- [DRIVER:QEDB207.DLL]
- Select For Fetch Only="T"
- [DRIVER:RB32ODBC.DLL]
- SQL_DBMS_NAME="RED BRICK WAREHOUSE"
- SQL_IDENTIFIER_QUOTE_CHAR="""
- ;The database doesn't properly support ltrim/rtrim
- ;functions because of lacking varchar support
- SQL_STRING_FUNCTIONS="6213"
- SQL_MAX_SCHEMA_NAME_LEN="30"
- [DRIVER:RB32ODBC.DLL VERSION:05.02]
- SQL_API_SQLNATIVESQL="FALSE"
- [DRIVER:RBODBC32.DLL]
- ; This driver only supports Red Brick Warehouse
- SQL_DBMS_NAME="RED BRICK WAREHOUSE"
- ;Some of the Redbrick drivers do not report this
- SQL_IDENTIFIER_QUOTE_CHAR="""
- SQL_STRING_FUNCTIONS="6213"
- [DRIVER:LIBRBODBC.SO]
- SQL_MAX_SCHEMA_NAME_LEN="30"
- [DRIVER:LIBRBODBC.SL]
- SQL_MAX_SCHEMA_NAME_LEN="30"
- [DRIVER:LIBRBODBC.A]
- SQL_MAX_SCHEMA_NAME_LEN="30"
- [DRIVER:SCLIW16.DLL]
- SQL_NON_NULLABLE_COLUMNS="0"
- [DRIVER:SIMBASYBASE.DLL]
- SQL_DBMS_NAME="SYBASE"
- [DRIVER:SQLSRV.DLL]
- SQL_DBMS_NAME="MICROSOFT SQL SERVER"
- Cursor Type For Metadata="STATIC"
- Connection Access Mode Is Changeable="F"
- [DRIVER:SQLSRV32.DLL]
- SQL_DBMS_NAME="MICROSOFT SQL SERVER"
- Cursor Type For Metadata="STATIC"
- Connection Access Mode Is Changeable="F"
- SQL_TIMEDATE_FUNCTIONS="2096637"
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- SupportUnicode="T"
- [DRIVER:SQLNCLI.DLL]
- SQL_DBMS_NAME="MICROSOFT SQL SERVER"
- Cursor Type For Metadata="STATIC"
- Connection Access Mode Is Changeable="F"
- SQL_TIMEDATE_FUNCTIONS="2096637"
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- Threaded Open="T"
- SupportUnicode="T"
- [DRIVER:SQO32_73.DLL]
- SQL_DBMS_NAME="ORACLE"
- State Overwrite 0="CCLMSG_UDA_SQL_ATTACH SQL_API_SQLDRIVERCONNECT 08003 01000"
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- [DRIVER:SQORA32.DLL]
- SQL_DBMS_NAME="ORACLE"
- [DRIVER:SQRDB32.DLL]
- Select For Update Disabled="T"
- Keyword Alias=" as %s "
- [DRIVER:SWODBC32.DLL]
- SQL_OJ_CAPABILITIES="127"
- [DRIVER:SYIQ95.DLL]
- SQL_DBMS_NAME="SYBASE IQ"
- SQL_DBMS_VER="Format String:SQL Server/%4s"
- SQL_OJ_CAPABILITIES="75"
- [DRIVER:SYIQNT.DLL]
- SQL_DBMS_NAME="SYBASE IQ"
- SQL_DBMS_VER="Format String:SQL Server/%4s"
- SQL_OJ_CAPABILITIES="75"
- [DRIVER:SYIQW3.DLL]
- SQL_DBMS_NAME="SYBASE IQ"
- SQL_OJ_CAPABILITIES="75"
- [DRIVER:SYSYBNT.DLL]
- SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_UPDATABLE"
- [DRIVER:TDATA.SL]
- DBINFO_SUBSECTIONS="DBNAM,DBMIN"
- ODBC3 DATE="T"
- [DRIVER:TDATA.SO]
- DBINFO_SUBSECTIONS="DBNAM,DBMIN"
- ODBC3 DATE="T"
- [DRIVER:TDATA32.DLL]
- DBINFO_SUBSECTIONS="DBNAM,DBMIN"
- ODBC3 DATE="T"
- [DRIVER:UDTODBC.DLL]
- Disable Transaction Support="T"
- [DRIVER:VFPODBC.DLL]
- SQL_QUALIFIER_TERM=""
- [DRIVER:VWODBC32.DLL]
- SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_UPDATABLE"
- [DRIVER:W32BTINT.DLL]
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- [DRIVER:SQRDB3.DLL]
- SQL_OWNER_TERM=""
- SQL_QUALIFIER_TERM=""
- [DRIVER:CWBODBC.DLL DATABASE:DB2/400 SQL]
- SQL_DBMS_NAME="QSQ"
- [DRIVER:LIBCWBODBC.SO DATABASE:DB2/400 SQL]
- SQL_DBMS_NAME="QSQ"
- [DRIVER:DB2CLI.DLL DATABASE:DB2/NT]
- SQL_DBMS_NAME="SQL"
- [DRIVER:DB2CLI.DLL DATABASE:AS]
- SQL_DBMS_NAME="QSQ"
- [DRIVER:DB2CLI.DLL DATABASE:DB2]
- SQL_DBMS_NAME="DSN"
- [DRIVER:DCSYB30.DLL DATABASE:DB2/400]
- SQL_DBMS_NAME="QSQ"
- [DRIVER:DCSYB30.DLL DATABASE:DB2/MVS]
- SQL_DBMS_NAME="DSN"
- [DRIVER:ACUODBC.DLL]
- SQL_API_SQLEXTENDEDFETCH="FALSE"
- [DRIVER:DTLODBC.DLL]
- SQL_API_SQLNATIVESQL="FALSE"
- SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_LENGTH,SQL_COLUMN_NULLABLE,SQL_COLUMN_NAME,SQL_COLUMN_PRECISION,SQL_COLUMN_SCALE,SQL_COLUMN_TYPE"
- SQL_DRIVER_VER="Format String:%10s"
- [DRIVER:P4ODBC.DLL]
- Disable Transaction Support="T"
- SQL_OWNER_TERM=""
- [DRIVER:BBJODBC.DLL]
- SQL_TIMEDATE_ADD_INTERVALS="F"
- SQL_TIMEDATE_DIFF_INTERVALS="F"
- [DRIVER:FMODBC.DLL]
- SQL_OWNER_TERM=""
- [DRIVER:RELDBM32.DLL]
- SQL_API_SQLFOREIGNKEYS="FALSE"
- [DRIVER:libtdsodbc.so]
- SQL_DBMS_NAME="MICROSOFT SQL SERVER"
- DBINFO_TYPE="MS"
- SQL_CONVERT_BIGINT="F"
- SQL_CONVERT_DATE="F"
- SQL_CONVERT_DOUBLE="F"
- SQL_CONVERT_TIME="F"
- Cursor Type For Metadata="STATIC"
- Connection Access Mode Is Changeable="F"
- [I18N Encoding Mapping DATABASE:IBM COGNOS REAL-TIME MONITORING]
- UTF8=utf-8
- [I18N Encoding Mapping DATABASE:TERADATA]
- UTF8=utf-8
- KANJISJIS_0S=Shift_JIS
- KANJIEUC_0U=EUC_JP
- [I18N Encoding Mapping DATABASE:RED BRICK]
- JapanEUC=EUC-JP
- MS1250=cp1250
- MS1251=cp1251
- MS1252=cp1252
- MS1253=cp1253
- MS1254=cp1254
- MS1255=cp1255
- MS1256=cp1256
- MS1257=cp1257
- MS1258=cp1258
- MS932=sjis
- MS874=cp874
- [Builtin Functions DATABASE:OPENEDGE]
- d:_add_years(%1d,%2n)=ADD_MONTHS( %1, (%2 * 12) )
- s:_add_years(%1s,%2n)=CAST(CONCAT(CAST(ADD_MONTHS( CAST(%1 AS DATE), (%2 * 12) ) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP)
- d:_add_months(%1d,%2n)=ADD_MONTHS( %1, %2 )
- s:_add_months(%1s,%2n)=CAST(CONCAT(CAST(ADD_MONTHS( CAST(%1 AS DATE), %2 ) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP)
- d:_add_days(%1d,%2n)=( %1 + %2)
- n:_days_between(%1ds,%2ds)= ( %1 - %2 )
- s:_add_days(%1s,%2n)=( %1 + (%2 * 86400000))
- t:_add_hours(%1t,%2n)=( %1 + (%2 * 3600000 ))
- s:_add_hours(%1s,%2n)=( %1 + (%2 * 3600000 ))
- t:_add_minutes(%1t,%2n)=( %1 + (%2 * 60000 ))
- s:_add_minutes(%1s,%2n)=( %1 + (%2 * 60000 ))
- t:_add_seconds(%1t,%2n)=( %1 + (%2 * 1000 ))
- s:_add_seconds(%1s,%2n)=( %1 + (%2 * 1000 ))
- n:_day_of_year(%1ds)=DAYOFYEAR(%1)
- n:_day_of_week(%1ds, %2n)= (MOD(DAYOFWEEK(%1)+7-%2,7)+1)
- d:_last_of_month(%1d)=LAST_DAY(%1)
- s:_last_of_month(%1s)=CAST(CONCAT(CAST(LAST_DAY(CAST(%1 AS DATE)) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP)
- n:_days_to_end_of_month(%1d)=(LAST_DAY (%1) - %1)
- n:_days_to_end_of_month(%1s)=(LAST_DAY (CAST(%1 AS DATE)) - CAST(%1 AS DATE))
- d:_first_of_month(%1d)=(%1 - (DAYOFMONTH (%1) -1))
- s:_first_of_month(%1s)=CAST(CONCAT(CAST(CAST(%1 AS DATE) - (DAYOFMONTH (%1) - 1) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP)
- n:_round(%1n, %2n)=ROUND(%1,%2)
- n:coguda
- n:coguda
- n:coguda
- n:coguda
- n:coguda
- n:coguda
- t:localtime()=systime()
- s:localtimestamp()=systimestamp()
- c:substring(%1c, %2n {,%3n})=SUBSTR(%1, %2 {,%3})
- [Builtin Functions DATABASE:OPENEDGE VERSION:10.27]
- d:_add_years(%1d,%2n)=
- s:_add_years(%1s,%2n)=
- d:_add_months(%1d,%2n)=
- s:_add_months(%1s,%2n)=
- d:_add_days(%1d,%2n)=
- n:_days_between(%1ds,%2ds)=
- s:_add_days(%1s,%2n)=
- t:_add_hours(%1t,%2n)=
- s:_add_hours(%1s,%2n)=
- t:_add_minutes(%1t,%2n)=
- s:_add_minutes(%1s,%2n)=
- t:_add_seconds(%1t,%2n)=
- s:_add_seconds(%1s,%2n)=
- n:_day_of_year(%1ds)=
- n:_day_of_week(%1ds, %2n)=
- d:_last_of_month(%1d)=
- s:_last_of_month(%1s)=
- n:_days_to_end_of_month(%1d)=
- n:_days_to_end_of_month(%1s)=
- d:_first_of_month(%1d)=
- s:_first_of_month(%1s)=
- c:trim_both_spaces(%1c)=
- n:_round(%1n, %2n)=
- t:localtime()=
- s:localtimestamp()=
- c:substring(%1c, %2n {,%3n})=SUBSTR(%1, %2 {,%3})
- [Exceptions Tables DATABASE:OPENEDGE]
- Joined=T
- Derived=T
- [Exceptions Tables DATABASE:OPENEDGE VERSION:10.27]
- Derived=F
- [Exceptions General DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Group_By_Alias=F
- Group_By_Expr=F
- Group_By_In_Exists=F
- Group_By_Sorted=F
- Subquery_Column_Alias=F
- Order_By_Alias=F
- Order_By_Name=F
- Count_Literal=F
- Count_Non_Distinct=F
- Subqueries=F
- Aggregate_In_Expr=F
- Aggregate_Value_Expr=F
- Cross_Product=F
- Substring_On_Expr=F
- Multiple_Distinct=F
- Subquery_In_Group_By=F
- Boolean_Comparison=F
- Null_Order=F
- Parameter_Markers=F
- [Exceptions General DATABASE:OPENEDGE]
- Group_By_Expr=T
- Count_Literal=T
- Count_Blob=T
- Count_Value_Expr=T
- Parameter_In_Select_List=F
- Like_Pattern_Literal_Only=T
- Multiple_Distinct=F
- Distinct_Aggregate_Value_Expr=F
- Integer_Division_Truncation=F
- Subquery_In_Case=F
- [Exceptions General DATABASE:OPENEDGE VERSION:10.28]
- Remove_Parameter_Cast=T
- [Exceptions General DATABASE:OPENEDGE VERSION:10.27]
- Group_By_Expr=F
- Count_Literal=F
- Count_Blob=F
- Count_Value_Expr=F
- Parameter_In_Select_List=F
- [Exceptions Blob Expressions DATABASE:OPENEDGE]
- Blob_In_Substring=F
- Blob_In_Trim=F
- Blob_In_Substring_Return_Blob=F
- Blob_In_IsNull=T
- [Exceptions Blob Expressions DATABASE:OPENEDGE VERSION:10.27]
- Blob_In_IsNull=F
- [Exceptions Set Operators DATABASE:OPENEDGE]
- Distinct="distinct"
- Intersect=
- Except=
- [Exceptions Set Operators DATABASE:OPENEDGE VERSION:10.27]
- Distinct=
- Intersect=
- Except=
- [Exceptions Value Expressions DATABASE:OPENEDGE]
- case=T
- Coalesce=T
- Nullif=T
- Cast=T
- Trim_Both_Spaces=C
- Localtime=C
- Localtimestamp=C
- Substring=C
- Extract=C
- Extract_Year=coguda
- Extract_Month=coguda
- Extract_Day=coguda
- Extract_Hours=coguda
- Extract_Minutes=coguda
- Extract_Seconds=coguda
- Comments=T
- [Exceptions Value Expressions DATABASE:OPENEDGE VERSION:10.29.0000]
- case=F
- [Exceptions Value Expressions DATABASE:OPENEDGE VERSION:10.28]
- case=F
- [Exceptions Value Expressions DATABASE:OPENEDGE VERSION:10.27]
- case=F
- Coalesce=F
- Nullif=F
- Cast=F
- Trim_Both_Spaces=F
- Localtime=F
- Localtimestamp=F
- Substring=C
- Extract=F
- Comments=F
- [Exceptions Joins DATABASE:OPENEDGE]
- Cross=T
- Cross_Syntax=" CROSS JOIN "
- Full_Outer=F
- Nested_Inner=F
- Nested_Outer=T
- Left_Nested=T
- Right_Outer=F
- Right_Nested=F
- On_Condition_Between_Predicate=T
- On_Condition_In_Predicate=T
- On_Condition_Like_Predicate=T
- On_Condition_Or_Predicate=T
- On_Condition_Set_Functions=F
- [Exceptions Joins DATABASE:OPENEDGE VERSION:10.27]
- On_Condition_Between_Predicate=F
- On_Condition_In_Predicate=F
- On_Condition_Like_Predicate=F
- On_Condition_Or_Predicate=F
- On_Condition_Set_Functions=F
- [Exceptions Delimiters]
- Comment_Begin="/* "
- Comment_End=" */ "
- [Operator Comparison DATABASE:OPENEDGE]
- Date=DT,OK:TS,OK
- Time=TM,OK:TS,OK
- Timestamp=DT,OK:TS,OK
- Interval=
- [Exceptions Predicates DATABASE:OPENEDGE]
- All="all"
- [Exceptions Predicates DATABASE:OPENEDGE VERSION:10.27]
- All=
- [Operator Cast DATABASE:NETEZZASQL]
- TM=TS,NA
- SM=IV,NA:IY,NA
- IT=IV,NA:IY,NA
- QD=IV,NA:IY,NA
- DM=IV,NA:IY,NA
- NU=IV,NA:IY,NA
- FL=IV,NA:IY,NA
- DB=IV,NA:IY,NA
- [Operator Cast DATABASE:OPENEDGE]
- AD=LC,NA:NC,NA:BN,NA:NV,NA:VB,NA:BO,NA:IV,NA:TT,NA:TZ,NA:IY,NA:TX,NA:BL,NA
- BN=AD,NA
- LC=AD,NA
- VB=AD,NA
- TX=AD,NA
- BL=AD,NA
- DT=CH,NA:VC,NA:NC,NA:NV,NA
- [Operator Cast DATABASE:IBM COGNOS REAL-TIME MONITORING]
- AD=AD,NA
- VC=TS,TS:DB,DB:DM,DM:IT,IT
- DB=DM,DM:IT,IT
- DM=DB,DB:IT,IT
- IT=DB,DB:DM,DM
- [Database Functions DATABASE:HP NEOVIEW DATABASE]
- cdinst:nullif(%1cdinst, %2cdinst)=NULLIF( %1, %2)
- n:length(%1c)=\{fn CHAR_LENGTH(%1)\}
- s:localtimestamp({%1n})=CAST(CURRENT_TIMESTAMP AS TIMESTAMP)
- [Database Functions DATABASE:HP NEOVIEW DATABASE VERSION:1]
- cdinst:nullif(%1cdinst, %2cdinst)=(case when %1=%2 then null else %1 end)
- [Database Functions DATABASE:ACCESS]
- cdinst:nullif(%1cdinst, %2cdinst)=IIF(%1=%2, null, %1)
- [Exceptions General DATABASE:HP NEOVIEW DATABASE]
- Count_Value_Expr=T
- Group_By_Ordinal=T
- Nulls_Sort_Last=T
- Is_Null_Value_Expr=T
- Distinct_Aggregates=T
- Correlated_Subqueries=T
- [Exceptions Set Operators DATABASE:HP NEOVIEW DATABASE]
- Distinct="distinct"
- Union="union"
- Union_All=T
- [Exceptions Tables DATABASE:HP NEOVIEW DATABASE]
- Derived=T
- [Exceptions Value Expressions DATABASE:HP NEOVIEW DATABASE]
- case=T
- Case_Simple=T
- Case_Searched=T
- Char_Length=T
- Octet_Length=T
- Extract=T
- Lower=T
- StrCat=T
- Substring=T
- Upper=T
- Current_Date=T
- Current_Time=T
- Current_Timestamp=T
- Abs=T
- Exp=T
- Mod=T
- Power=T
- Sqrt=T
- Ceiling=T
- Floor=T
- Trim=T
- Position=T
- Coalesce=T
- Nullif=C
-
- [Operator Addition DATABASE:HP NEOVIEW DATABASE]
- Date=
- Time=
- Timestamp=IV,TS
- Interval=TS,TS:IV,IV:DT,TS
- [Operator Subtraction DATABASE:HP NEOVIEW DATABASE]
- Date=
- Time=
- Timestamp=TS,TS
- Interval=IV,IV
- [Operator Comparison DATABASE:HP NEOVIEW DATABASE]
- Date=DT,OK
- Timestamp=TS,OK
- Time=TM,OK:TS,OK
- Interval=IV,OK
- [DRIVER:HP_ODBC0100.DLL]
- SQL_OJ_CAPABILITIES="27"
- [DATABASE:OPENEDGE]
- SQL_DBMS_VER_STR_FORMAT="m.nnr."
- [Misc DATABASE:IBM COGNOS REAL-TIME MONITORING]
- Processing Mode=Limited Local
- [DATABASE:MYSQL]
- Disable_Subquery_With_Parameters=T
- Keyword Alias=" as \"%s\" "
- SQL_API_SQLDESCRIBEPARAM="FALSE"
- SQL_QUALIFIER_TERM=""
- [DATABASE:MY]
- SQL_DBMS_NAME="MYSQL"
-
- [Exceptions Commands DATABASE:MYSQL]
- Select="select"
- Insert=
- Update=
- Delete=
- Call=
- Select_Star="T"
- Max_Stmt_Len=""
- [Exceptions Clauses DATABASE:MYSQL]
- From="from"
- Where="where"
- Group_By="Group By"
- Having="having"
- Window=
- With=
- With_Recursive=
- [Exceptions Tables DATABASE:MYSQL]
- Derived=T
- Joined=T
- Simple_And_Joined=T
- Tbl_Ref_Limit=""
- SubSelect_Limit=""
- Table_Constructor=F
- UniqueName_Prefix="coguda"
- [Exceptions Joins DATABASE:MYSQL]
- Inner=T
- Left_Outer=T
- Right_Outer=T
- Full_Outer=F
- Cross=T
- On_Condition_Or_Predicate=T
- Nested_Outer=T
- Inner_Tbl_Restrict=F
- Optnl_Tbl_Restrict=F
- Non_Equi_Joins=T
- One_Outer=F
- Natural=T
- Left_Nested=T
- Right_Nested=T
- Two_Sided_Join_Restrict=F
- Optnl_Tbl_Join_Restrict=F
- Optnl_Tbl_Join_Filter=T
- Optnl_Tbl_Filter=T
- Prsrv_Tbl_Join_Filter=T
- Prsrv_Tbl_Filter=T
- On_Condition_Set_Functions=F
- On_Condition_Subqueries=T
- Full_Non_Equi_Join=F
- On_Condition_In_Predicate=T
- On_Condition_Not_Predicate=T
- On_Condition_Like_Predicate=T
- On_Condition_Between_Predicate=T
- On_Condition_IsNull_Predicate=T
- Non_Join_Expr=T
- Non_Join_Non_Equi_Expr=T
- Only_Eql_With_And=T
- On_Condition_Functions=T
- Two_Sided_Join_Restrict_Filter=T
- Nested_Inner=T
- Product_Join=T
- Outer_Non_Equi_Join=T
- On_Condition_No_Expr=T
- Outer_Syntax=T
- Left_Pre=
- Left_Post=
- Right_Pre=
- Right_Post=
- Full_Pre=
- Full_Post=
- Inner_Col_Pre=
- Inner_Col_Post=
- [Exceptions Predicates DATABASE:MYSQL]
- Between="between"
- In="in"
- Like="like"
- Is_Null="is null"
- Any="any"
- All="all"
- Exists="exists"
- NotLike="not like"
- [Exceptions Aggregates DATABASE:MYSQL]
- Max="max"
- Min="min"
- Sum="sum"
- Avg="avg"
- Count="count"
- Count_Star="count(*)"
- Stddev="stddev_samp"
- Stddev_Pop="stddev_pop"
- Stddev_Samp="stddev_samp"
- Variance="var_samp"
- Var_Pop="var_pop"
- Var_Samp="var_samp"
- Grouping=
- Rank=
- Dense_Rank=
- Percent_Rank=
- Cume_Dist=
- Percentile_Cont=
- Percentile_Disc=
- First_Value=
- Last_Value=
- Percentile=F
- [Exceptions OLAP Functions DATABASE:MYSQL]
- Olap_Min=
- Olap_Max=
- Olap_Sum=
- Olap_Avg=
- Olap_Count=
- Olap_Count_Star=
- Olap_Stddev=
- Olap_Stddev_Pop=
- Olap_Stddev_Samp=
- Olap_Variance=
- Olap_Var_Pop=
- Olap_Var_Samp=
- Olap_Rank=
- Olap_Dense_Rank=
- Olap_Percent_Rank=
- Olap_Cume_Dist=
- Olap_Percentile_Cont=
- Olap_Percentile_Disc=
- Olap_First_Value=
- Olap_Last_Value=
- Olap_Row_Number=
- Olap_Ratio_To_Report=
- Olap_Ntile=
- [Exceptions Set Operators DATABASE:MYSQL]
- Union="union"
- Union_All=T
- Intersect=
- Intersect_All=F
- Except=
- Except_All=F
- Distinct="distinct"
- Order_By="order by"
- [Exceptions Operators DATABASE:MYSQL]
- Add="+"
- Sub="-"
- Mul="*"
- Div="/"
- Eql="="
- Neq="<>"
- Grt=">"
- Geq=">="
- Les="<"
- Leq="<="
- Neg="-"
- And="and"
- Or="or"
- Not="not"
- Assign="="
- [Exceptions Value Expressions DATABASE:MYSQL]
- Case_Simple=T
- Case_Searched=T
- Coalesce=T
- Nullif=T
- Grouping_Sets=F
- Rollup=F
- Cube=F
- Position=T
- Char_Length=F
- Octet_Length=F
- Substring=T
- Upper=T
- Lower=T
- Strcat=C
- Cast=C
- Abs=T
- Floor=T
- Ceiling=C
- ln=T
- Exp=T
- Mod=T
- Sqrt=T
- Power=T
- Current_Date=T
- Current_Time=F
- Current_TimeStamp=F
- LocalTime=T
- LocalTimestamp=T
- Extract=C
- Extract_Year=coguda
- Extract_Month=coguda
- Extract_Day=coguda
- Extract_Hours=coguda
- Extract_Minutes=coguda
- Trim=T
- Row_Value_Constructors=T
- Olap_Window_Order_By=F
-
- [Exceptions General DATABASE:MYSQL]
- Aggregate_In_Expr=T
- Aggregate_Value_Expr=T
- Correlated_Subqueries=T
- Cross_Product=T
- Distinct_Aggregates=T
- Distinct_Aggr_In_Case=T
- Group_By_Expr=T
- Group_By_Ordinal=T
- Group_By_Alias=F
- Multiple_Distinct=T
- Count_Non_Distinct=T
- Count_Value_Expr=T
- Count_Literal=T
- Is_Null_Value_Expr=T
- Is_Null_Value_Parm=T
- Like_Value_Expr=T
- Subquery_In_Having=T
- Subquery_In_Group_By=T
- Subquery_In_Case=T
- Count_Blob=T
- Expression_In_In=T
- Null_Order=F
- Olap_Null_Order=F
- Olap_Distinct=F
- Nested_Olap_Functions=F
- Empty_String_Is_Null=F
- Order_By_In_Derived_Table=T
- Interval_As_VarChar=F
- Boolean_Comparison=T
- Derived_Column_List=F
- With_Column_List=F
- Aggr_With_Interval=T
- Nested_Case=T
- Not_In_Subquery=T
- Nulls_Sort_Last=F
- Order_By_Alias=T
- Order_By_Name=T
- Substring_On_Expr=T
- Subqueries=T
- Subquery_Column_Alias=T
- Parameter_In_Select_List=T
- Remove_Parameter_Cast=F
- Subquery_With_Parameters=T
- Like_With_Parameters=T
- Like_With_Escape=T
- Comments=T
- Integer_Division_Truncation=F
- Parameter_Markers=F
-
- [Exceptions Literals DATABASE:MYSQL]
- Date_Literal=C
- Date_Literal_Str="cast('%s-%s-%s' as date)"
- Timestamp_Literal=C
- Timestamp_Literal_Str="cast('%s-%s-%s %s:%s:%s' as datetime)"
- Time_Literal=C
- Time_Literal_Str="cast('%s:%s:%s' as time)"
- Interval_Literal=F
- IntervalYM_Literal=F
- TimeTZ_Literal=F
- TimestampTZ_Literal=F
- NChar_Literal=T
-
- [Exceptions Misc DATABASE:MYSQL]
- [Exceptions Delimiters DATABASE:MYSQL]
- Comment_Begin="/* "
- Comment_End=" */ "
-
- [Exceptions Separators DATABASE:MYSQL]
- Catalog_Separator="."
- Schema_Separator="."
- Table_Separator="."
-
- [Exceptions Blob Expressions DATABASE:MYSQL]
- Blob_In_Substring=T
- Blob_In_Trim=T
- Blob_In_StrCat=F
- Blob_In_IsNull=T
- Blob_In_Substring_Return_Blob=F
-
-
- [Database Functions DATABASE:MYSQL]
- cx:concat(%1cx,%2cx)=concat(%1,%2)
- n:ceiling(%1n)=CEIL(%1)
-
- [Builtin Functions DATABASE:MYSQL]
- d:_add_days(%1d,%2n)=(%1 + interval floor(%2) day)
- d:_add_months(%1d,%2n)=(%1 + interval floor(%2) month)
- d:_add_years(%1d,%2n)=(%1 + interval floor(%2) year)
- d:_first_of_month(%1d)=( %1 - interval(dayofmonth(%1) -1) day)
- d:_last_of_month(%1d)=(last_day(%1))
- s:_add_days(%1s,%2n)=(%1 + interval floor(%2) day)
- s:_add_months(%1s,%2n)=(%1 + interval floor(%2) month)
- s:_add_years(%1s,%2n)=(%1 + interval floor(%2) year)
- s:_first_of_month(%1s)=( %1 - interval(dayofmonth(%1) -1) day)
- s:_last_of_month(%1s)=(last_day(%1))
- n:_years_between(%1ds,%2ds)=((year(%1) - year(%2)))
- n:_days_to_end_of_month(%1ds)=(cast(last_day(%1) as date) - cast(%1 as date))
- n:_day_of_year(%1ds)=(dayofyear(%1))
- n:_day_of_week(%1ds, %2n)=(mod(dayofweek(%1)+7-%2,7))
- n:coguda
- n:coguda
- n:coguda
- n:coguda
- n:coguda
- [Operator Addition DATABASE:MYSQL]
-
- [Operator Subtraction DATABASE:MYSQL]
-
- [Operator Multiplication DATABASE:MYSQL]
-
- [Operator Division DATABASE:MYSQL]
-
- [Operator Comparison DATABASE:MYSQL]
- [Operator Cast DATABASE:MYSQL]
- AD=AD,NA
- BL=AD,NA
- CH=CH,CH:DT,DT:NC,NC:TM,TM
- DB=AD,NA
- DT=CH,CH:DT,DT:NC,NC
- FL=AD,NA
- IT=CH,CH:NC,NC
- IV=AD,NA
- IY=AD,NA
- NC=CH,CH:DT,DT:NC,NC
- QD=CH,CH:NC,NC
- SM=CH,CH:NC,NC
- TM=TM,TM
- TS=DT,DT:TM,TM
- TT=AD,NA
- TZ=AD,NA
- VC=CH,CH:DT,DT:NC,NC:TM,TM
- [Exceptions Operators DATABASE:IBM RATIONAL]
- Add="+"
- And="and"
- Div="/"
- Eql="="
- Eql=
- Geq=">="
- Geq=
- Grt=">"
- Grt=
- Leq="<="
- Leq=
- Les="<"
- Les=
- Mul="*"
- Neq="<>"
- Neq=
- Not="not"
- Or="or"
- Sub="-"
- [Exceptions Predicates DATABASE:IBM RATIONAL]
- Any=
- Exists=
- Between=
- In=
- Is_Null=
- Like=
- Match=
- NotLike=
- Unique=
- [Exceptions Clauses DATABASE:IBM RATIONAL]
- From="from"
- Group_By=
- Order_By=
- Having=
- Where=
- [Exceptions Set Operators DATABASE:IBM RATIONAL]
- Distinct=
- Except=
- Except_All=F
- Intersect=
- Intersect_All=F
- Order_By=
- Order_By_Limit="0"
- Union=
- Union_All=F
- [Exceptions AggregateS DATABASE:IBM RATIONAL]
- Avg=
- Count=
- Count_star=
- Max=
- Min=
- Sum=
- [Exceptions Literals DATABASE:IBM RATIONAL]
- Boolean_Literal=F
- Date_Literal=F
- Timestamp_Literal=F
- Time_Literal=F
- Interval_Literal=F
- IntervalYM_Literal=F
- TimeTZ_Literal=F
- TimestampTZ_Literal=F
- [Exceptions Value Expressions DATABASE:SQLDS/VM]
- Current_Date=C
- [Database Functions DATABASE:SQLDS/VM]
- d:current_date()=\{fn CURDATE() \}
- [DRIVER:RATLXML.DLL]
- DBINFO_SUBSECTIONS="DBNAM"
- SQL_DBMS_NAME="IBM RATIONAL"
- [DRIVER:LIBRATLXML.SO]
- DBINFO_SUBSECTIONS="DBNAM"
- SQL_DBMS_NAME="IBM RATIONAL"
- [Source Data Type Name Mapping DATABASE:NETEZZASQL]
- Interval=Interval_Day_To_Second
- [DATABASE:IBM COGNOS NOW!]
- SQL_DBMS_NAME="IBM COGNOS REAL-TIME MONITORING"
|
