Command Execution Messages | Basic Teradata Query - Command Execution Messages - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

Executing the sample SQL stored procedure act, specified in the file example.spl, and containing one parameter, BTEQ produces the following command execution messages in the  SYSPRINT file:

.logon mydbs/tdsp01
Password:
*** Logon successfully completed.
 *** Transaction Semantics are BTET.
 *** Character Set Name is 'ASCII'.
*** Total elapsed time was 1 second.
   
BTEQ -- Enter your SQL request logon or BTEQ command:
.compile file example.spl
      
 *** Procedure has been created. .
 *** Total elapsed time was 5 seconds.
   
BTEQ -- Enter your SQL request logon or BTEQ command:
call samplesp1 (8888, pAmount);
   
 *** Procedure has been executed.
 *** Total elapsed time was 1 second.
   
pAmount
---------
10000.00
   
BTEQ -- Enter your SQL request logon or BTEQ command:
sel * from account1;
   
*** Query completed. One row found. 2 columns returned.
 *** Total elapsed time was 1 second.
   
accountno 	amount
--------  ---------
8888      10000.00
   
.LOGOFF
*** You are now logged off from the DBC.