#DateForumTypeThreadPost
36225 Mar 2015 @ 03:58 PDTTeradata ApplicationsReplyFast export errorHi. Filesystem error. You are generating almost 3GB. If you are on a 32bit Linux you may be hitting 2GB limit, run out of space on filesystem or filesystem quota... HTH. Cheers. Carlos.
36125 Mar 2015 @ 01:51 PDTConnectivityReplyRHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loadedHi: Try adding: LD_LIBRARY_PATH=/opt/teradata/client/15.00/odbc_64/lib export LD_LIBRARY_PATH HTH Cheers. Carlos.
36012 Mar 2015 @ 02:26 PDTTeradata StudioReplyTeradata Studio 15 (Linux) crashes when opening Query Developement PerspectiveHi Francine. After renaming the workspace-studio the crash persists. I looked in the new workspace-studio/.metadata/.log file and it says: "A handler conflict occurred." and "C...
35911 Mar 2015 @ 08:14 PDTTeradata StudioTopicTeradata Studio 15 (Linux) crashes when opening Query Developement PerspectiveFrancine (or whoever in charge): My Teradata Studio crashes each time I try to open Query Developement Perspective. It's a TD Studio 15.00.02 on SLES11 (64bit) and uses java jre 6.0_43-b01. ...
35804 Dec 2014 @ 04:46 PSTDatabaseReplybad query You may try:   select a.SpoolUsage,          b.SQLTextInfo   from (select QueryID, SpoolUsage         ...
35727 Oct 2014 @ 08:34 PDTDatabaseReplySubquery in Case StatementHi. This could be an option: SELECT TOP 5 Fld1, Fld2 FROM ( SELECT Fld1, Fld2 FROM TABLE1 WHERE ((DATE - date '1900-01-01') mod 7) + 1 2 UNION AL...
35622 Oct 2014 @ 12:53 PDTDatabaseReplyOut of spool space on diskForgot to mention: If the system activity is high when you execute your process, other processes very spool- demanding could be using the free space for their own spools, thus leaving too few spac...
35522 Oct 2014 @ 12:37 PDTDatabaseReplyOut of spool space on diskVickye: There is no disk space to provide spool space for the process. The spool space available is provided by the free cylinders in the filesystem. This usually means that you are running out of...
35421 Oct 2014 @ 03:10 PDTDatabaseReplyIssue : All virtual circuits are in useTom: Diving into old documentation I found the same (wrong) reference in Teradata Factory Student Book (V14.10.4) page 3-10. Thanks. Cheers. Carlos.
35320 Oct 2014 @ 12:48 PDTDatabaseReplyIssue : All virtual circuits are in useHi Tom. Thanks for the clarification.  Then I think the documentation is misleading: "In a workstation environment, CliV2 builds the request parcel and, via MTDP and MOSI sends it over...
35217 Oct 2014 @ 06:52 PDTDatabaseReplyIssue : All virtual circuits are in useHi. The gateway distributes the requests from workstations to the PEs on the same node where the gateway is running. Cheers. Carlos.
35117 Oct 2014 @ 03:43 PDTDatabaseReplyIssue : All virtual circuits are in useHi I overlooked this: "Would it be good to connect with different IP for this system as we all are using one IP to connect this system? If yes please explain." If the connections are m...
35017 Oct 2014 @ 03:10 PDTDatabaseReplyIssue : All virtual circuits are in useHi Check the value of the sessions allowed in the gateway configuration with gtwcontrol utility. Cheers. Carlos
34917 Oct 2014 @ 12:35 PDTDatabaseReplyIssue : All virtual circuits are in useHi. Speaking from memory: Gateway can handle up to 1200 connections, 600 is the default though. Cheers. Carlos.
34814 Oct 2014 @ 12:26 PDTDatabaseReplyFailure: 3738 error while inserting String in a VARCHAR field. Need alternative wayIt seems you are trying to insert an explicit string using quotes (''). The quoted strings cannot exceed 31000 chars. Your option is using an IMPORT file with the strings that you need...
34709 Oct 2014 @ 12:43 PDTGeneralReplyTimestamp format issueI cannot think of setting a date at 45:35:25 (HH:MM:SS)  BTEQ -- Enter your SQL request or BTEQ command: select cast('09-19-2004-45:35:25' as timestamp(0) format 'MM-DD-YYYY-HH:...
34603 Oct 2014 @ 06:26 PDTGeneralReplySubstracting two TIME(6) datatype values BTEQ -- Enter your SQL request or BTEQ command: SELECT CAST('22:22:00' AS TIME(0)) - CAST('22:00:00' AS TIME(0)) HOUR(2) TO SECOND(0) ; *** Query completed. One row found. O...
34502 Oct 2014 @ 06:05 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousThere is a comma missing after "NetSal DEC(8,2) FORMAT '$b$$,$$9.99'" Cheers. Carlos.
34402 Oct 2014 @ 05:57 PDTGeneralReplychecking for invalid or junk or special characters on numeric fieldIf the column DBC.ABC is actually BIGINT what you are trying to do is nonsense. BIGINT columns cannot contain such 'junk' characters. You cannot use LIKE operand on numeric columns. Chee...
34324 Sep 2014 @ 04:25 PDTDatabaseReplyTemporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key)Hi. This is the expected behaviour. When you implement a constraint at the table creation there is no errortables '*_0'. The error tables are created when 'ALTER TABLE... ADD CONSTRAI...
34223 Sep 2014 @ 08:26 PDTDatabaseReplyTemporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key)Hi. There is no ALTER TABLE MODIFY CONSTRAINT DISABLE functionality in Teradata. Oracle is Oracle, Teradata is Teradata. Cheers. Carlos.
34123 Sep 2014 @ 08:26 PDTDatabaseReplyTriggers on ViewsHi. There is no INSTEAD OF TRIGGER functionality in Teradata. Oracle is Oracle, Teradata is Teradata. Cheers. Carlos.
34012 Sep 2014 @ 07:59 PDTDatabaseReplySQL to get first day of month and last day of month but for 2 months ago  BTEQ -- Enter your SQL request or BTEQ command: SELECT CAST(((ADD_MONTHS(DATE, -2)/100)*100+1) AS DATE) FDo2MAGO,        CAST(((ADD_MONTHS(DATE, -1)/100)...
33912 Sep 2014 @ 02:02 PDTGeneralReplyOracle Data used as Input for BTEQIt seems you are a bit confused: You cannot use bteq with ODBC connection (only Cli) And most important: You cannot acces Oracle DB with bteq. You must use Oracle sql*plus or another compaible to...
33817 Aug 2014 @ 11:58 PDTDatabaseReplyInvalid TimestampThe 'issue' is that the user is providing a bad timestamp, wrong format or whatever. There is nothing wrong in the SQL (apart from the fact that there is a discrepance between th...

Pages