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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to find CPU time used by user?
Hello, Account String Extension allows to do that ( user level ) the ASE variable could be : &I ( add hostid, session number and request number into the account string ) be careful ASE uses AMPUsage mechanism , the amount of data recorded can increase very quickly. and to see the CPU time...- GORYN
- Post #2
- Forum: NCR: Teradata
-
Kill session / User
Hi, if you work on a LAN : The Gateway Global utility allows you to monitor and control the sessions of Teradata Database LAN-connected users. KILL SESSION Terminates a specific session. Requires using the SELECT HOST command. KILL USER Terminates all sessions of a specific user...- GORYN
- Post #2
- Forum: NCR: Teradata
-
How do you send an BTEQ abort msg to your JCL
Have you tried to use such as example: ___________________________________________ insert database.table ( CustID, ... ) SELECT CustID ... FROM TEMP; .IF ERRORCODE > 0 THEN .QUIT 12 _____________________________________ and catch the errorcode in your JCL regards Francois- GORYN
- Post #2
- Forum: NCR: Teradata
-
Hi When I do fast export from a
Hi, Just an example : DDL : === CREATE SET TABLE dev_tampon.logtable ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL ( i INTEGER NOT NULL, dat DATE FORMAT 'yyyy-mm-dd' NOT NULL, j INTEGER, ch VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC) PRIMARY...- GORYN
- Post #2
- Forum: NCR: Teradata
-
Teradata Database Server Installation(demo version 4.0)
Hello, Have you tried to go to the WEB site( www.teradata.com search demo ) ? You can find some interesting recommendations. regards Francois- GORYN
- Post #2
- Forum: NCR: Teradata
