All forum activity

#DateUserForumTypeThreadPost
5779115 Jun 2016 @ 01:10 PDTPrivate Forum
5779015 Jun 2016 @ 01:05 PDTdnoethDatabaseReplyHow to parametrize WHERE IN clause in stored procedure?You're not using Dynamic SQL, :varListTmp is always treated as a single value. Try STRTOK_SPLIT_TO_TABLE: http://forums.teradata.com/forum/analytics/passing-a-string-into-a-macro-for-...
5778915 Jun 2016 @ 11:55 PDTtomnolanDatabaseReplyDatabase per object type -- Best practice or over engineered?"DB names follow no pattern" is not a Teradata best practice.   Please work with your DBAs to design a naming convention for databases that makes sense for your application, and th...
5778815 Jun 2016 @ 11:52 PDTkspongixDatabaseReplyCopying trillions of data to new tableRaj, Do you really need to partition the date for everyday ? If possible, try to increase the partition to a month or quarters, then try running the delete SQLs. Also look at the period of dates ...
5778715 Jun 2016 @ 11:35 PDTtomnolanDatabaseReplyGetting junk values for Latin column when using JDBCIf you are storing characters in a LATIN column that are actually supported by the Teradata Database for the server-side LATIN character set, then you will be able to retrieve those ...
5778615 Jun 2016 @ 11:11 PDTamoyyangDatabaseReplycreate mutiple tables from an existing table with while loopI copied your entire code here: select 'create table tab'||(day_of_calendar (format '999')(CHAR(3)))||' as (select * from mydata where seq='||day_of_calendar||') with d...
5778515 Jun 2016 @ 10:36 PDTspockihanaDatabaseTopicStored Procedure as source in SSISI'd like to use a stored procedure as a data source in SSIS (to eventually export to a text file) but the SP doesn't return column information. Is there any way to use an SP as a data sourc...
5778415 Jun 2016 @ 09:53 PDTfgrimmerTeradata StudioReplyInstalling Teradata Eclipse Plugin Breaks running DTD againsdt other platforms?We found a class changed from the previous version of Eclipse so we thought rebuilding with the latest Eclipse Mars version would resolve this. We will look further into this. What version of Eclip...
5778315 Jun 2016 @ 09:38 PDTsk8s3iDatabaseReplyHow to parametrize WHERE IN clause in stored procedure?Hi Dieter, I too am facing a similar situation where I need to pass a couple of Strings as parameter in WHERE clause in a SP. I am not able to get the desired result with the SP I have. REPLAC...
5778215 Jun 2016 @ 09:11 PDTAtardecerR0j0DatabaseReplycreate mutiple tables from an existing table with while loopI tried the process before sending and It works
5778115 Jun 2016 @ 08:58 PDTamoyyangDatabaseReplycreate mutiple tables from an existing table with while loopThanks for advice on dynamic SQL! I tested but tab001...was not created (or existed). I have noticed that "... seq=      1 ..." where multiple blanks appear between '=&...
5778015 Jun 2016 @ 08:55 PDTshiboo18Cloud ComputingReplyInstall XML tools on Teradata Express StudioAs an update, bteq did not come install with the TD Express . Had to install it separately from https://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-ins...
5777915 Jun 2016 @ 08:02 PDTyarekshy85DatabaseReplypassing parameter to mload script and loading into target tableHas anyone tried or done this before?  
5777815 Jun 2016 @ 07:37 PDTrododendronToolsReplyProblems with multibyte tdload / TPT19134 !ERROR!I'm sorry, I don't know how to edit my previous post. Teradata is v. 15.10
5777715 Jun 2016 @ 07:25 PDTshiboo18Cloud ComputingReplyInstall XML tools on Teradata Express StudioAs an update, getting the following error while running the installudfs.pl script : 'bteq' is not recognized as an internal or external command, operable program or batch ...
5777615 Jun 2016 @ 06:52 PDTmyosko1ToolsTopicDownloading Previous versions of Teradata StudioIs there a place where previous versions of Teradata Studio can be downloaded? I am looking for a version 14.?? instead of the current version 15.
5777515 Jun 2016 @ 06:45 PDTBlamey4DatabaseTopicTime Difference from previous row SELECT     SYS_EVB ,PRIN_EVB    ,SUPPLIER_CDE_EVB ,D.DESCR_CTD ,EVENT_CHANNEL_EVB ,CASE           ...
5777415 Jun 2016 @ 06:44 PDTgloxtonTeradata StudioTopicCode Assist functionality questionsI have been asked a number of questions about Code Assist, and wanted to know if anyone knows of any additional insight into its functionality before I respond with the results of my testing: 1. D...
5777315 Jun 2016 @ 06:38 PDTPrivate Forum
5777215 Jun 2016 @ 06:22 PDTPrivate Forum
5777115 Jun 2016 @ 06:08 PDTCarlosALViewpointReplyNegative 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...
5777015 Jun 2016 @ 04:49 PDTrododendronToolsTopicProblems with multibyte tdload / TPT19134 !ERROR! [1] $FILE_READER[1]: TPT19134 !ERROR! Fatal data error processing file 'input_import.csv'. Delimited Data Parsing error: Invalid multi-byte character in row 221, col 1. [2] freetext VA...
5776915 Jun 2016 @ 04:36 PDTSramDatabaseTopicFastload not picking decimal valueHi , i have txt file with decimal values. iam trying to load file to table(staging table with varchar datatype) i have used format as vartext in fastload script, in table its not populating deci...
5776815 Jun 2016 @ 04:25 PDTeric_tdDatabaseReplyTERADATA on Windows 10Thanks Dieter!
5776715 Jun 2016 @ 02:59 PDTAtardecerR0j0DatabaseReplycreate mutiple tables from an existing table with while loopYou can use a dynamic SQL like this one: select 'create table tab'||(day_of_calendar (format '999')(CHAR(3)))||' as (select * from mydata where seq='||day_of_calendar||&#...

Pages