BTEQ 20.00.00.11 (64-bit) Sat Oct 24 00:10:29 2026 PID: 32032
 
+---------+---------+---------+---------+---------+---------+---------+----
-- Authenticate privately with your own lab account.

 *** Logon successfully completed.
 *** Teradata Database Release is 20.00.28.81                   
 *** Teradata Database Version is 20.00.28.81                     
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.
 
 *** Total elapsed time was 1 second.
 
+---------+---------+---------+---------+---------+---------+---------+----
-- DWHPro functional checks, 24 October 2026. Run each statement separately.
-- Metadata access depends on privileges. No logging rules or grants are changed.
.SET WIDTH 240
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.SET TITLEDASHES OFF
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT InfoKey,InfoData FROM DBC.DBCInfoV WHERE InfoKey IN ('VERSION','RELEASE');

 *** Query completed. 2 rows found. 2 columns returned. 
 *** Total elapsed time was 1 second.

InfoKey                        InfoData
VERSION                        20.00.28.81
RELEASE                        20.00.28.81

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT 'SUBSTRING' AS test_label;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

test_label
SUBSTRING

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT SUBSTRING('Teradata' FROM 1 FOR 4) AS ansi_text,
       SUBSTR('Teradata',2,3) AS middle_text,
       CHARACTER_LENGTH(SUBSTRING('ABC' FROM 8 FOR 2)) AS empty_length,
       SUBSTRING('ABC' FROM 2 FOR 10) AS remaining_text,
       CASE WHEN SUBSTRING(CAST(NULL AS VARCHAR(3)) FROM 1 FOR 1) IS NULL THEN 1 ELSE 0 END AS null_preserved;

 *** Query completed. One row found. 5 columns returned. 
 *** Total elapsed time was 1 second.

ansi_text  middle_text  empty_length  remaining_text  null_preserved
Tera       era                     0  BC                           1

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT CASE WHEN POSITION('-' IN 'AT0042')>0 THEN SUBSTRING('AT0042' FROM POSITION('-' IN 'AT0042')+1) ELSE NULL END AS missing_delimiter;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

missing_delimiter
?

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT 'NUMERIC' AS test_label;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

test_label
NUMERIC

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT TO_NUMBER('12.77') AS parsed_number,
       CASE WHEN TO_NUMBER('not-a-number') IS NULL THEN 1 ELSE 0 END AS invalid_is_null,
       CASE WHEN TO_NUMBER(CAST(NULL AS VARCHAR(12))) IS NULL THEN 1 ELSE 0 END AS source_null,
       TRUNC(CAST(-12.67 AS DECIMAL(8,2))) AS trunc_negative,
       FLOOR(CAST(-12.67 AS DECIMAL(8,2))) AS floor_negative,
       CEILING(CAST(-12.67 AS DECIMAL(8,2))) AS ceiling_negative,
       ROUND(CAST(12.1266 AS DECIMAL(10,4)),2) AS rounded;

 *** Query completed. One row found. 7 columns returned. 
 *** Total elapsed time was 1 second.

                           parsed_number  invalid_is_null  source_null  trunc_negative  floor_negative  ceiling_negative        rounded
                                   12.77                1            1          -12.00          -13.00            -12.00        12.1300

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT 'ACCESS RIGHTS: METADATA SHAPE ONLY' AS test_label;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

test_label
ACCESS RIGHTS: METADATA SHAPE ONLY

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT UserName,DatabaseName,TableName,AccessRight,GrantAuthority FROM DBC.AllRightsV WHERE 1=0;

 *** Query completed. No rows found. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT RoleName,Grantee FROM DBC.RoleMembersV WHERE 1=0;

 *** Query completed. No rows found. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT RoleName,DatabaseName,TableName,AccessRight FROM DBC.AllRoleRightsV WHERE 1=0;

 *** Query completed. No rows found. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT 'DBQL: METADATA SHAPE ONLY' AS test_label;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

test_label
DBQL: METADATA SHAPE ONLY

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT StartTime,QueryID,UserName,ErrorCode,AMPCPUTime,TotalIOCount FROM DBC.QryLogV WHERE 1=0;

 *** Query completed. No rows found. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT * FROM DBC.DBQLRulesV WHERE 1=0;

 *** Query completed. No rows found. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT 'CURRENT_DATE' AS test_label;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

test_label
CURRENT_DATE

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT TYPE(CURRENT_DATE) AS result_type,
       (CURRENT_DATE - (CURRENT_DATE - 7)) AS seven_days,
       TO_CHAR(CURRENT_DATE,'YYYY-MM-DD') AS explicit_text;

 *** Query completed. One row found. 3 columns returned. 
 *** Total elapsed time was 1 second.

result_type                               seven_days  explicit_text
DATE                                               7  2026-10-24

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
CREATE MULTISET VOLATILE TABLE dwhpro_dates_20261024 (event_date DATE) PRIMARY INDEX(event_date) ON COMMIT PRESERVE ROWS;

 *** Table has been created. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
INSERT INTO dwhpro_dates_20261024 VALUES(CURRENT_DATE-8);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
INSERT INTO dwhpro_dates_20261024 VALUES(CURRENT_DATE-7);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
INSERT INTO dwhpro_dates_20261024 VALUES(CURRENT_DATE-1);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
INSERT INTO dwhpro_dates_20261024 VALUES(CURRENT_DATE);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
INSERT INTO dwhpro_dates_20261024 VALUES(CURRENT_DATE+1);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT COUNT(*) AS previous_seven_days FROM dwhpro_dates_20261024 WHERE event_date>=CURRENT_DATE-7 AND event_date<CURRENT_DATE;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

previous_seven_days
                  2

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
SELECT COUNT(*) AS lower_bound_only FROM dwhpro_dates_20261024 WHERE event_date>=CURRENT_DATE-7;

 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

lower_bound_only
               4

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
DROP TABLE dwhpro_dates_20261024;

 *** Table has been dropped. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.LOGOFF
 *** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.QUIT
 *** Exiting BTEQ...
 *** RC (return code) = 0 


