Bteq cmds Index
1) Log On
2) LOGON
With TDPID
3) ByPassing
Logon Prompts
4) Logoff
5) Exit
or Quit
6) Change
Your Password
7) Changing
the TDPID
8) How
to submit a Bteq script in Batch mode
9) Default
DATE Setting in BTEQ
10) Checking Teradata Version
11) QUIET
12) To Skip first Record while Importing
13) Specify Multiple Sessions
14) Single statement processing
15) ErrorCode- Checking for Errors
16) GOTO-Redirecting the Control
17) Hang- Put a Pause
18) SUPPRESS – Deleting Duplicated Data
19) Inserting Blank Lines
20) Inserting a line of underline characters
21) Entering a DOS Commands
22) Changing the Screen Width
23) Representing Null Values
24) ECHOREQ – Echo Required Function
25) PageLength
26) FULLYEAR-Setting Year in YYYY Format
27) Compile
28) Default
29) REMARK Command
30) Break a line to have Sections
31) TIMEMSG Command
32) Continuing BTEQ Commands
33) ERROROUT
34) INDICDATA
35) FOLDLINE
36) Specifying SideTitles
37) Exporting Under VM
38) Giving Comments
39) Identifying Input and Outpt file Undes MS-DOS
40) FORMCHAR
41) OMIT
42) OS
43) RETRY
44) Session Transaction
45) Skip Line and Skip Double
46) Show Controls
47) SYSIN & SYSOUT
48) MACRO
49) IF ELSE Command
50) Why BTEQ Scripts- What is the Special in it?
51) OS Under MS-DOS
52) RETCANCEL
53) Multiple Statements Processing
54) Giving Comments In ANSI mode
55) Execute the given SQL stmt Repeatedly
56) REPEAT in ANSI mode
57) REPEAT Command
58) REPEAT With =(Equivalent)
59) REPEAT Command With Multiple Sessions
60) REPEATSTOP
61) How to Break a line
62) Exporting Under MS-DOS,UNIX
63) Listing Example on Various Platforms
64) RETLIMIT
6)Return Codes
63)An Example for Script Structure
15)Exporting Result to a file
16) Run File(Batch Mode)
17) Creating and Calling Macro
18)Excuting Stored Procedure
7)Script Structure
25)Creating a run file
0 Comments