#DateForumTypeThreadPost
4602 Mar 2016 @ 07:55 PSTDatabaseReplyConverting string to date using REGEXP - Getting error 3798Carlos, 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  
4502 Mar 2016 @ 07:47 PSTDatabaseReplyConverting string to date using REGEXP - Getting error 3798Yes, 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...
4402 Mar 2016 @ 07:17 PSTDatabaseReplyConverting string to date using REGEXP - Getting error 3798Thanks 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...
4302 Mar 2016 @ 05:01 PSTDatabaseReplyConverting 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...
4202 Mar 2016 @ 03:51 PSTDatabaseTopicConverting string to date using REGEXP - Getting error 3798Hello, 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...
4112 May 2015 @ 03:56 PDTToolsReplyTPT API - Errors when building getbuffer sampleHi 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...
4011 May 2015 @ 12:25 PDTToolsTopicTPT API - Errors when building getbuffer sampleHi 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&...
3911 Jun 2013 @ 08:57 PDTThird Party SoftwareTopicCan anyone recommend software products to export/import dataHello 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 ...
3806 Jun 2013 @ 06:27 PDTTeradata StudioReplyWith Teradata Studio why does a timestamp(0) export with trailing .0Hello 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...
3703 Jun 2013 @ 07:20 PDTTeradata StudioTopicWith Teradata Studio why does a timestamp(0) export with trailing .0Hello, 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  ...
3608 Feb 2013 @ 09:17 PSTToolsReplyTPT - Getting unhandled win32 exception in executor.exeBTW, Our Teradata version is 13.10 and I have 13.10 client tools.  
3508 Feb 2013 @ 08:52 PSTToolsTopicTPT - Getting unhandled win32 exception in executor.exeHello, 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...
3415 Jan 2013 @ 11:37 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportThanks alot.  I will try to see if we can purchase the 14.0 client tools.  
3315 Jan 2013 @ 06:51 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportThanks 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...
3214 Jan 2013 @ 01:58 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportThanks.  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...
3110 Dec 2012 @ 09:40 PSTToolsTopicHow to get Character String Delimiter with TPT or FastExportHello.  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...
3013 Nov 2012 @ 12:42 PSTGeneralTopicHow 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...
2913 Sep 2012 @ 01:45 PDTToolsTopicUsing 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...
2820 Jul 2012 @ 04:18 PDTDatabaseReplyError 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...
2719 Jul 2012 @ 02:08 PDTDatabaseReplyError 3523 - An owner referenced by user does not have EXECUTE PROCEDURE access Hi Dieter, We are on 13.10 -Greg  
2619 Jul 2012 @ 11:49 PDTDatabaseTopicError 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...
2512 May 2012 @ 12:41 PDTToolsReplyTPT 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  
2410 May 2012 @ 11:13 PDTToolsReplyTPT 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.   ...
2308 May 2012 @ 07:21 PDTToolsReplyTPT 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...
2205 May 2012 @ 03:12 PDTToolsTopicTPT 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...

Pages