#DateForumTypeThreadPost
48715 Jun 2016 @ 06:08 PDTViewpointReplyNegative Spool in ViewpointHi. Spool files left behind (not dropped) after request ended / aborted. Also, there can be DBC.DatabaseSpace inconsistencies. The updatespace utility resolves all of this. HTH. Cheers. Carlo...
48614 Jun 2016 @ 08:09 PDTDatabaseReplyIs it an ordering - How do I generate a column that gives me the seq no of the selectHi. SQL SELECT does NOT guarantee (even in Oracle) any order of the rows returned if no ORDER BY clause is used. The Oracle ROWID does not provide an order of insertion. It is related t...
48513 Jun 2016 @ 07:53 PDTDatabaseReplySubtracting Timestamps as decimals hoursHi. This is a 'signature error'. Try: SELECT Test_Sandbox.TimeStamp_Diff_Seconds(TIMESTAMP '2016-06-10 00:00:00', TIMESTAMP '2016-05-10 11:25:00'); Teradata changed this...
48413 Jun 2016 @ 12:26 PDTDatabaseReplyHow to Reduce Table Space Hi. Compression (in any of the options that Teradata allows) is your best chance. Cheers. Carlos.
48309 Jun 2016 @ 06:37 PDTDatabaseReplyGet database hierarchy to create similar directory structure on filesystemHi. WITH RECURSIVE JER (LEVEL, DATABASENAME, OWNERNAME, ROUTE) AS ( SELECT 1 LEVEL, DATABASENAME, OWNERNAME, CAST('/'||TRIM(DATABASENAME) AS VARCHAR(128)) ROUT...
48206 Jun 2016 @ 03:48 PDTToolsReplyNeed Help regarding TPT ODBC OperatorHi. The solution is spell correctly "tbuild" ;-) Cheers. Carlos.
48106 Jun 2016 @ 03:17 PDTDatabaseReplyHow to get first date of last month based on max date from another table?Hi. The classic solution: SELECT CAST(((ADD_MONTHS(DATE <your date> ,-1)/100)*100)+1 AS DATE); Cheers. Carlos.
48006 Jun 2016 @ 12:50 PDTDatabaseReplyCAST(1987-07-21T01:41:58.000Z) TO TIMESTAMP Hi.  BTEQ -- Enter your SQL request or BTEQ command: SELECT CAST('1987-07-21T01:41:58.000Z' AS TIMESTAMP(3) FORMAT 'YYYY-MM-DDbhh:mi:ss.s(3)b'); ...
47903 Jun 2016 @ 03:05 PDTDatabaseReplyLenght, Character_Length Function not working in view creationHi. You seem to be using the ODBC SQL extesions (scalar functions) instead of the teradata ones. Disable them in SQL Assistant and use the proper ones (SUBSTR(string,from,numcharacters) inst...
47803 Jun 2016 @ 01:52 PDTDatabaseReplyFast Load Error : FDL4822 DEFINE statement rejected.Hi. The script looks good. Check if it has rubbish characters in the script file or, even better, create a brand new script file from scratch (no copy / paste). HTH. Cheers. Carlos.
47702 Jun 2016 @ 06:02 PDTDatabaseReplyFast Load Error : FDL4822 DEFINE statement rejected.Hi. The word 'VALUES' is missing before the fields between parenthesis. BTW: the last quit is redundant after the logoff. Cheers. Carlos.  
47601 Jun 2016 @ 01:03 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorHi Steve. I'm afraid it's not about vi. Even if you manage to get the TAB character (0x09) into the tpt script for the OpenQuoteMark attribute, tpt will replace it with one space (0x20) in...
47531 May 2016 @ 12:49 PDTDatabaseReplyError MLOAD pmSetSchemaHi. This is not a multiload error, but a Linux one. Is your LD_LIBRARY_PATH variable set properly? What is the result of echo $LD_LIBRARY_PATH? What is the result of executing mload from the co...
47427 May 2016 @ 06:29 PDTGeneralReplyHow to run BTEQ in Windows machinHi. You say you're using bteq in a windows machine, but the screenshot shows you are on a linux one (and as root), accessed from a windows machine via ssh (putty). The error message that you ...
47323 May 2016 @ 11:59 PDTDatabaseReplyDET DEFINE OFF in SQL DeveloperHi. You must execute the script with an '@' preceding the .sql file or by using F5 (run script) if you are executing the commands in a SQL worksheet. SET DEFINE OFF works for me e...
47223 May 2016 @ 02:21 PDTDatabaseReplyDET DEFINE OFF in SQL DeveloperHi. Teradata DOES NOT ask you for the values. This (variable substitution) is a SQL Developer feature that happens BEFORE sending the request to Teradata. SET DEFINE OFF works in SQL Developer ju...
47120 May 2016 @ 09:43 PDTGeneralReplyRunning Sum counter restart when threshold value reachedHi. I think your logic is flawed, because you'll need an ordering column to guarantee consistent results. Anyhow, a logic like this may give you what you're after:   SELECT CUST,...
47020 May 2016 @ 12:21 PDTViewpointReplyNegative Spool in ViewpointHi. Phantom / Orphan spool perhaps. updatespace utility should fix it. HTH. Cheers. Carlos.
46919 May 2016 @ 12:37 PDTConnectivityReplyConnectivity error to TD using ODBC_64 on library libtdsso.soHi. The blank before libtdsso.co and after the slash is a typo in the post or it appears in the real message?  Cheers. Carlos.
46819 May 2016 @ 12:25 PDTToolsReplyFEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementHi. Are you selecting 16 columns into a 15 field schema? Cheers. Carlos.
46718 May 2016 @ 09:05 PDTToolsReplyFEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementHi. Error message is self-explanatory: The schema is different from the data selected from the EXPORT operator. If you want us to help you it would be nice if you show us the tpt script. We have ...
46612 May 2016 @ 06:13 PDTDatabaseReplyREPLACE VIEW Failed 3706: Syntax error: expected something between the word 'ROLLOUT_REGION_IDENTIFIER' and ','Hi. You are using the SUBSTR syntax with the SUBSTRING function. You must use : SUBSTRING(ROLLOUT_REGION_IDENTIFIER FROM 1 FOR 15) or SUBSTR(ROLLOUT_REGION_IDENTIFIER, 1, 15)   HTH. Ch...
46510 May 2016 @ 08:16 PDTGeneralReplyWe are getting a 3158 error when trying to run an insert through a stored ProcHi. TDWM related. It seems your request is affected by some TASM rule. HTH Cheers. Carlos.
46405 May 2016 @ 03:03 PDTDatabaseReplyTips to convert data on TPTHi: For example:   DEFINE SCHEMA your_schema ... your_timestamp VARDATE FORMATIN('DD/MM/YYYYbhh:mi') FORMATOUT('YYYY-MM-DDbhh:mi:ss') ...   HTH Cheers. C...
46305 May 2016 @ 12:40 PDTDatabaseReplyTips to convert data on TPTHi You can do it easily using FORMATIN clause for VARDATE type in the schema definition. FORMATIN ('DD/MM/YYYYbhh:mi') will accept the one digit hours. HTH. Cheers. Carlos.

Pages