Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Begin logging

Status
Not open for further replies.
Lysen

Lysen

Programmer
Apr 9, 2002
87
NL
Hi all,


why doens't teradata accept the next statement????????????

begin query logging limit summary on sysdba;

while

begin query logging limit on sysdba;

gets the response:
3706: Syntax error: Expected SQLTEXT, SUMMARY, THRESHOLD or combination.

please help, i'm getting VERY frustrated with all of this, and the manual doesn't clear things up at ALL!!
 
Sort by date Sort by votes
You have to specify the interval boundary values like
SUMMARY = 1,5,60

Did you check the right manual?
SQL Ref Vol. 4 Data Definition Statements, chapter 3

Dieter
 
Upvote 0 Downvote
Thanks, Dieter!

It seems I had an outdated manual... In my manual the "begin logging" statement was part of chapter 1...

I'll try to find the most recent manuals immediately..
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smitakale
  • Locked
  • Question
Logging on to Teradata RDBMS without password 1
Replies
4
Views
101
tdsmart
tdsmart
susheeltips
  • Locked
  • Question
Hi! I am a beginner to Tera
Replies
1
Views
21
BillDHS
BillDHS

Part and Inventory Search

Sponsor

Back
Top