#DateForumTypeThreadPost
1709 Jun 2015 @ 01:48 PDTDatabaseTopicVolatile table for EXTUSERIs it possible for a user logging in through EXTUSER (using LDAP) to create a volatile table? If not, is there any reasonable substitution or workaround where a user could create a temp table that ...
1624 Apr 2015 @ 09:08 PDTDatabaseTopicGet record count from cursorIs it possible, upon opening a cursor, to get a record count from the cursor? I have an SP where I open 8 cursors to be returned to the caller. I collect some stats about the time it takes to run, ...
1521 Apr 2015 @ 10:54 PDTDatabaseReplyEXPLAIN - Tag Sort by way of the sort key in spool field1 Just means that it's sorting on field 1 in whatever Spool it's referring to. The query being explained probably has "ORDER BY 1" in it.&n...
1421 Apr 2015 @ 10:40 PDTDatabaseReplyCase statement or Where statemetIt looks to me like your parantheses are all funkied up in that WHERE statement. Your WHERE statement boils down to:   WHERE E.HLTH_SRVC_CD IN ( ((<list>) END AS ASM) ...
1321 Apr 2015 @ 10:22 PDTDatabaseReplyCheck for Dummy data (String comparison)You could use the following to return records that contain ONLY alpha characters:   SELECT * FROM RAW_AML_ACCOUNT_JUN WHERE REGEXP_INSTR(RAW_AML_ACCOUNT_JUN.ACCT_FIRST_NAME, '^[a-zA-Z...
1222 Aug 2014 @ 06:32 PDTToolsReplyBTEQ Output: Unicode Column wider as defined in DDL or FORMATThis thread is stale, but I've found no reasonable solution to the issue where BTEQ outputs 3x the number of characters necessary when the session's charset is set to 'UTF8'. I unde...
1118 Jul 2014 @ 10:52 PDTConnectivityReplyADO, ODBC, and UnicodeFound the answer. Sticking it here for the next poor sap that spends 4 hours tearing their hair out. Unicode is fun. In most of the documentation for the ODBC drivers for Teradata the property...
1018 Jul 2014 @ 10:23 PDTConnectivityTopicADO, ODBC, and UnicodeI'm using VBA and the Microsoft ActiveX Data Objects 2.6 Library to access our Teradata 14.00.05.03 server using Teradata ODBC Driver 15.00.00.01 I have a table that contains unicode character...
920 Mar 2014 @ 10:16 PDTDatabaseReplyCreating a Cross Tab Something like this would do the trick: SELECT TEAM, TYPE, SUM(CASE WHEN AGE_BUCKET = '1. 0 -30 DAYS' THEN 1 ELSE 0 END) AS "1. 0 -30 DAYS", SUM(CASE WHEN AGE_BUCKET = ...
820 Mar 2014 @ 08:56 PDTDatabaseReplyNeed help with Unicode in DDL issuesk186013: Is your step 1 something to be done on the server itself? I'd like to push this up to the folks with the access to implement. Is there any reason why this isn't already set to TRU...
706 Dec 2013 @ 01:10 PSTToolsReplyTPT job fails, Log refers to a completely seperate unrelated jobFantastic! I greatly appreciate the help!
605 Dec 2013 @ 02:36 PSTToolsReplyTPT job fails, Log refers to a completely seperate unrelated jobThe anomoly in the console output is the fact that Job2 shows up in Job1's output at all. It is a completely unrelated job. When this happens, both jobs fail. The only thing related between the...
502 Dec 2013 @ 10:19 PSTToolsTopicTPT job fails, Log refers to a completely seperate unrelated jobLately, when running TPT jobs, we've experienced job failures. When looking at the logs for the TPT jobs, sometimes (sporadically) the log will start off normally referencing the correct job, b...
401 Nov 2013 @ 09:26 PDTDatabaseReplyregexp_replace woesNice.  I tried to add the 5th option parameter to have it continue searching, but the database yelled at me. Seems that you have to include the 6th parameter or it errors :/  Thanks for t...
301 Nov 2013 @ 08:21 PDTDatabaseTopicregexp_replace woesI want to replace all of the whitespace and non alphanumeric characters in a string. It seems like some form of the following should work: SELECT REGEXP_REPLACE('00 - L* 123-4383', '...
207 Oct 2013 @ 12:48 PDTToolsReplyConvert date format m/d/yyyy to mm/dd/yyyy in TPTFigured this one out after posting. I'm using the following: CASE WHEN (POSITION(''/'' IN :birthdate) = 3) AND (POSITION(''/'' IN SUBSTRING(:birthdate FRO...
107 Oct 2013 @ 09:56 PDTToolsTopicConvert date format m/d/yyyy to mm/dd/yyyy in TPTI have a file I am loading to a table in my database via TPT. Everything is working properly, however I am dropping records where the date format is m/d/yyyy (as opposed to mm/dd/yyyy). Is there a ...