Public Sub hideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub
Public Sub showRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub
2011-09-13
Teradata - String concatenation
select
T1.*
from
TABLE_NAME_HERE
as T1
WHERE
T1.FIELD1
like '%' || 'SEARCH_TERM_HERE' || '%'
;
Teradata - Select TD database table from within SQL server
-- 0. Install Teradata OleDB
drivers for Windows, where the SQL Server instance is running.
-- 1. Openquery, much faster
for my current setup.
SELECT *
FROM
OPENQUERY(
LINKED_SERVER_NAME_HERE
,
'SELECT
field1 FROM CFDW2_BA_VWS.SOR_PARTY'
)
;
-- 2. Four-part naming string
with second element skipped.
SELECT
*
FROM
LINKED_SERVER_NAME_HERE..TERDATA_DATABASE_NAME_HERE.TABLE_NAME_HERE
WHERE
Field1
= '1001'
;
Teradata - Temporary and volatile tables
-- 1. Global temporary.
create
set global temporary
table temp1
,
no fallback
,
no log
(
deptno
smallint
,avgsal
dec(9,2)
,maxsal
dec(9,2)
,minsal
dec(9,2)
,sumsal
dec(9,2)
,empcnt
smallint
)
;
-- 2. Volatile.
CREATE
VOLATILE TABLE
table_name_here
AS
(
SELECT
'1001' as Field1
,
'2010/04/08' AS Field2
)
WITH DATA PRIMARY INDEX ( Field1,
Field2 )
ON COMMIT PRESERVE ROWS
;
Teradata - Session information
-- 1. All sessions, for all
users.
select
*
from
DBC.SESSIONINFO
where
UserName
like any ( 'SQL17%', '213061%' )
order by
UserName
asc
;
-- 2. Current session
information.
SELECT
HostNo
,UserName
,SessionNo
,LogonDate
,LogonTime
,LogonSequenceNo
,LogonSource
FROM
dbc.SessionInfoVX
WHERE
SessionNo
= ( select session )
;
Subscribe to:
Posts (Atom)