| 57791 | 15 Jun 2016 @ 01:10 PDT | Private Forum |
| 57790 | 15 Jun 2016 @ 01:05 PDT | dnoeth | Database | Reply | How 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-... |
| 57789 | 15 Jun 2016 @ 11:55 PDT | tomnolan | Database | Reply | Database 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... |
| 57788 | 15 Jun 2016 @ 11:52 PDT | kspongix | Database | Reply | Copying trillions of data to new table | Raj, 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 ... |
| 57787 | 15 Jun 2016 @ 11:35 PDT | tomnolan | Database | Reply | Getting junk values for Latin column when using JDBC | If 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 ... |
| 57786 | 15 Jun 2016 @ 11:11 PDT | amoyyang | Database | Reply | create mutiple tables from an existing table with while loop | I 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... |
| 57785 | 15 Jun 2016 @ 10:36 PDT | spockihana | Database | Topic | Stored Procedure as source in SSIS | I'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... |
| 57784 | 15 Jun 2016 @ 09:53 PDT | fgrimmer | Teradata Studio | Reply | Installing 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... |
| 57783 | 15 Jun 2016 @ 09:38 PDT | sk8s3i | Database | Reply | How 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... |
| 57782 | 15 Jun 2016 @ 09:11 PDT | AtardecerR0j0 | Database | Reply | create mutiple tables from an existing table with while loop | I tried the process before sending and It works
|
| 57781 | 15 Jun 2016 @ 08:58 PDT | amoyyang | Database | Reply | create mutiple tables from an existing table with while loop | Thanks 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 '=&... |
| 57780 | 15 Jun 2016 @ 08:55 PDT | shiboo18 | Cloud Computing | Reply | Install XML tools on Teradata Express Studio | As 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... |
| 57779 | 15 Jun 2016 @ 08:02 PDT | yarekshy85 | Database | Reply | passing parameter to mload script and loading into target table | Has anyone tried or done this before?
|
| 57778 | 15 Jun 2016 @ 07:37 PDT | rododendron | Tools | Reply | Problems with multibyte tdload / TPT19134 !ERROR! | I'm sorry, I don't know how to edit my previous post.
Teradata is v. 15.10
|
| 57777 | 15 Jun 2016 @ 07:25 PDT | shiboo18 | Cloud Computing | Reply | Install XML tools on Teradata Express Studio | As 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 ... |
| 57776 | 15 Jun 2016 @ 06:52 PDT | myosko1 | Tools | Topic | Downloading Previous versions of Teradata Studio | Is 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.
|
| 57775 | 15 Jun 2016 @ 06:45 PDT | Blamey4 | Database | Topic | Time Difference from previous row |
SELECT
SYS_EVB
,PRIN_EVB
,SUPPLIER_CDE_EVB
,D.DESCR_CTD
,EVENT_CHANNEL_EVB
,CASE
... |
| 57774 | 15 Jun 2016 @ 06:44 PDT | gloxton | Teradata Studio | Topic | Code Assist functionality questions | I 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... |
| 57773 | 15 Jun 2016 @ 06:38 PDT | Private Forum |
| 57772 | 15 Jun 2016 @ 06:22 PDT | Private Forum |
| 57771 | 15 Jun 2016 @ 06:08 PDT | CarlosAL | Viewpoint | Reply | Negative Spool in Viewpoint | Hi.
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... |
| 57770 | 15 Jun 2016 @ 04:49 PDT | rododendron | Tools | Topic | Problems 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... |
| 57769 | 15 Jun 2016 @ 04:36 PDT | Sram | Database | Topic | Fastload not picking decimal value | Hi ,
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... |
| 57768 | 15 Jun 2016 @ 04:25 PDT | eric_td | Database | Reply | TERADATA on Windows 10 | Thanks Dieter!
|
| 57767 | 15 Jun 2016 @ 02:59 PDT | AtardecerR0j0 | Database | Reply | create mutiple tables from an existing table with while loop | You 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||&#... |
