46 | 02 Mar 2016 @ 07:55 PST | Database | Reply | Converting string to date using REGEXP - Getting error 3798 | Carlos,
Many thanks to you as well ! I am not familiar with lookaheads, but that sounds pretty interesting. Will check that out when I get out of my current time crunch.
-Greg
|
45 | 02 Mar 2016 @ 07:47 PST | Database | Reply | Converting string to date using REGEXP - Getting error 3798 | Yes, we are on 14. Now it is working perfectly. I should have thought to use the all-occurrences arg. Thanks for your quick response Dieter, as I am under the gun to fi... |
44 | 02 Mar 2016 @ 07:17 PST | Database | Reply | Converting string to date using REGEXP - Getting error 3798 | Thanks Dieter. But when I run your example, I get 1925-07-9, the replacement only works on the first digit. Need to also get the second digit so that t... |
43 | 02 Mar 2016 @ 05:01 PST | Database | Reply | Converting string to date using REGEXP - Getting error 3798 |
SELECT regexp_replace('1925-7-9', '\b([0-9])\b-\b([0-9])\b', '0\1-0\2');
Hey Dieter,
Thanks! Casting worked! Your other example is interesting, looks l... |
42 | 02 Mar 2016 @ 03:51 PST | Database | Topic | Converting string to date using REGEXP - Getting error 3798 | Hello,
TD gives errors when trying to cast a date that has a single-digit day or month (ie. 1925-7-9). So, I wrote the code below using REGEXP functions to add a leading zero to the day... |
41 | 12 May 2015 @ 03:56 PDT | Tools | Reply | TPT API - Errors when building getbuffer sample | Hi Folks, I got past that error. I had to specify both telapi.dll and telapi.lib in Linker->Input->Additional Dependencies. But, now I have a different linker error, regarding tel... |
40 | 11 May 2015 @ 12:25 PDT | Tools | Topic | TPT API - Errors when building getbuffer sample | Hi Folks,
The Teradata TPT API could be very useful in our department to tailor the operation of TPT. I tried building the getbuffer 64-bit sample program with Visual Studio 2010 and I&... |
39 | 11 Jun 2013 @ 08:57 PDT | Third Party Software | Topic | Can anyone recommend software products to export/import data | Hello Folks,
I would like to ask the forum for any suggestions they have regarding data archiving solutions and products (for non-DBA's). Our department creates a large volume ... |
38 | 06 Jun 2013 @ 06:27 PDT | Teradata Studio | Reply | With Teradata Studio why does a timestamp(0) export with trailing .0 | Hello Francine,
Thank you for your response, and looking into this. I tried to import via Studio, and yes, that worked - thanks. But, our goal is to export and import h... |
37 | 03 Jun 2013 @ 07:20 PDT | Teradata Studio | Topic | With Teradata Studio why does a timestamp(0) export with trailing .0 | Hello,
Our organization has a need to export data internally and for customer deliverables. When using Teradata Studio Version 14.02.0.201302060329 to export columns with type of ... |
36 | 08 Feb 2013 @ 09:17 PST | Tools | Reply | TPT - Getting unhandled win32 exception in executor.exe | BTW, Our Teradata version is 13.10 and I have 13.10 client tools.
|
35 | 08 Feb 2013 @ 08:52 PST | Tools | Topic | TPT - Getting unhandled win32 exception in executor.exe | Hello,
For months, I've successfully been using TPT/tbuild, executed via a DOS batch script. Now IT gave me a fresh, newly-installed PC, and now toward the end of the tbuild I am getting... |
34 | 15 Jan 2013 @ 11:37 PST | Tools | Reply | How to get Character String Delimiter with TPT or FastExport | Thanks alot. I will try to see if we can purchase the 14.0 client tools.
|
33 | 15 Jan 2013 @ 06:51 PST | Tools | Reply | How to get Character String Delimiter with TPT or FastExport | Thanks for the info on 14.0. Currently our TD engine is 13.10 and all of the client tools are 13.10. Is it possible to run 14.0 client tools (ie. TPT) on a 13.10 engine? If so, ma... |
32 | 14 Jan 2013 @ 01:58 PST | Tools | Reply | How to get Character String Delimiter with TPT or FastExport | Thanks. But what I need is a secondary delimiter, just to put double-quotes around data that are strings. Since I want to produce a CSV file as my output, the TextDelimit... |
31 | 10 Dec 2012 @ 09:40 PST | Tools | Topic | How to get Character String Delimiter with TPT or FastExport | Hello. I need to export large numbers of tables to CSV files for customer deliverables. I am working under Teradata 13.10. For VARCHAR fields, I need to include a Character String... |
30 | 13 Nov 2012 @ 12:42 PST | General | Topic | How do I pass a DYNAMIC RESULT SET back to Visual Basic ? | Hello,
I see that a stored procedure can pass a cursor back to a calling application by using a DYNAMIC RESULT SET. My calling app is Visual Basic, and I can not find any info on how to... |
29 | 13 Sep 2012 @ 01:45 PDT | Tools | Topic | Using MACROCHARSET in TPT |
Hello,
Is it possible to set the character set when doing DEFINE SCHEMA in a TPT script? (as below)
DEFINE SCHEMA Stage_Schema
(
MY_ID VARCH... |
28 | 20 Jul 2012 @ 04:18 PDT | Database | Reply | Error 3523 - An owner referenced by user does not have EXECUTE PROCEDURE access |
Hi Dieter,
Thanks for your reply. I did
SHOW PROCEDURE MM110829_WRITE_LOG_PRC
but it only displayed the code (below), no security info. (so I guess it is default rig... |
27 | 19 Jul 2012 @ 02:08 PDT | Database | Reply | Error 3523 - An owner referenced by user does not have EXECUTE PROCEDURE access |
Hi Dieter,
We are on 13.10
-Greg
|
26 | 19 Jul 2012 @ 11:49 PDT | Database | Topic | Error 3523 - An owner referenced by user does not have EXECUTE PROCEDURE access |
Hi,
I have several utility stored procedures that are called from other stored procedures, all within the SAME database. But on trying to have one stored procedure call another I am ge... |
25 | 12 May 2012 @ 12:41 PDT | Tools | Reply | TPT return code 12 during INSERT |
Hi Steven,
Hey, that worked ! Thanks alot. Guess I should have tried qualifying that, but I thought the WorkingDatabase covered it.
-Greg
|
24 | 10 May 2012 @ 11:13 PDT | Tools | Reply | TPT return code 12 during INSERT |
Hi Steven,
Thanks for your response. To start fresh, I dropped all the error log tables in both DB's and deleted all files in the checkpoint directory. ... |
23 | 08 May 2012 @ 07:21 PDT | Tools | Reply | TPT return code 12 during INSERT |
Can anyone lend a hand on this? Where can I find more information about this error? The public log says "terminated status 12". I could not find any... |
22 | 05 May 2012 @ 03:12 PDT | Tools | Topic | TPT return code 12 during INSERT |
Hello,
I had a TPT script that was working great, pulling data from an Oracle DB via ODBC, and inserting into Teradata. Then I changed the target Teradata DB to a different DB, and now... |