22 | 01 Aug 2006 @ 12:39 PDT | Analytics | Reply | Replace( ) & Ascii Characters:CHR( ) in Teradata | Hi TD_USERAbout the Ascii characters included in string operations in Teradata:as in Oracle CHR(10), you can use in teradata the hexa equivalent(i.e. '0A'XC)or for CHR(09) '09'XC or for CHR(13) '1C... |
21 | 17 Jul 2006 @ 09:07 PDT | Connectivity | Reply | Efficiency UDF scalar function vs.conventional SQL | Thanks A lot for the response.I had already altered the UDF in unprotected mode befor calling and benchmark it.But it is running under Teradata V2R5.1.I guess that the Teradata V2R6.1 come out with... |
20 | 12 Jul 2006 @ 12:05 PDT | Analytics | Reply | IS-NUMERIC functions | Hi flaska,I use an UDF from Mr. Dennis Calkins named is_integer.This function returns 0 if field not numeric and 1 if numericU can use it like this: select * from mydatabase.emp_table where mydatab... |
19 | 17 Jun 2006 @ 01:39 PDT | Database | Reply | Collecting Statistics on multiple Columns | Hi PhanyThanks for the reply.Does exist a place in the teradata documentation, where it is mentioned?greetings stami |
18 | 13 Jun 2006 @ 06:30 PDT | Connectivity | Topic | Efficiency UDF scalar function vs.conventional SQL | To test an attribute in numeric I can use the function is_integer from Mr. Dennis Calkins (Thanks here for Mr. Calkins) athttp://www.teradataforum.com/is_integer.htmThat is a very smart and concis... |
17 | 08 Jun 2006 @ 07:34 PDT | Database | Reply | UDF | Hi the above from me was for unix.In TD the User Rights create alter and exec functions are nessesary.Here is the description for W2K found in UDF-Orange book:Full path specified to W2K server sour... |
16 | 08 Jun 2006 @ 05:16 PDT | Database | Reply | UDF | Hi, about the syntax above of the EXTERNAL: here is a exampel for header file and src file for an installation on the server: EXTERNAL NAME 'SI!to_number!/my/home/udf/to_number.h!SS!to_number!/my/... |
15 | 08 Jun 2006 @ 04:10 PDT | Database | Reply | UDF | Hi,In http://www.teradataforum.com/is huge amount of Tips and examples.eg.http://www.teradataforum.com/is_integer.htmgreetingsstami |
14 | 06 Jun 2006 @ 09:40 PDT | Database | Topic | Collecting Statistics on multiple Columns | Hi all,Is the orde of columns in the collect statistics statemen important or no?e.g. COLLECT STATISTICS ON table_1 COLUMN (column_2, column_1); orCOLLECT STATISTICS ON table_1 COLUMN (column_1, co... |
13 | 01 Jun 2006 @ 06:42 PDT | Tools | Reply | Encountering error while using .EXPORT REPORT FILE command in BTEQ | Hi,the only think to suggest is that some subdirectory from /werr1/we1s/ws/ABX_logdoes not exist.The Code is Ok except, you must have received some Warnings such:"*** Warning: Expected a '.' before... |
12 | 26 May 2006 @ 03:36 PDT | Database | Reply | can we run bteq script/stored procedure from mload? | Hi Jaguar,in the official documentation of Database V2R6.1Book SQL Reference: Data Manipulation Statements side 193 ff.,Chapter 3: SQL Data Manipulation Language Statement Syntax,is ABORT described... |
11 | 26 May 2006 @ 08:49 PDT | Database | Reply | Can I catch an OUT variable(s) from a stored procedure? | Thanks for these suggetion AKIRAgreetingsstami27 |
10 | 26 May 2006 @ 08:44 PDT | Database | Reply | can we run bteq script/stored procedure from mload? | Hi Jaguar, I think u can manage it with the ACTIVITYCOUNT if u want:Here is a suggetion:select count(*) from dbc.tables where tablename='ET_MY_TABLE' and databasename='MY_DB';.if ERRORCODE 0 then ... |
9 | 23 May 2006 @ 10:23 PDT | Database | Topic | Can I catch an OUT variable(s) from a stored procedure? | Hi stored procedure experts,know someone if I can catch an OUT variable(s) from a stored procedure after calling it from a bteq on Unix Teradata V2R.05.01 or exist somthing like.IF ERRORCODE 0 THE... |
8 | 23 May 2006 @ 10:10 PDT | Database | Topic | Can I catch an OUT variable(s) from a stored procedure? | Hi stored procedure experts,know someone if I can catch an OUT variable(s) from a stored procedure after calling it from a bteq on Unix Teradata V2R.05.01 or exist somthing like.IF ERRORCODE 0 THE... |
7 | 20 Apr 2006 @ 11:36 PDT | Database | Reply | Write/Read external file from within Stored Procedure? | Hi Craig, sorry for the html mistake above.The rihgt notation of the unix Command for the bteq above (say its name is select_test.bteq) were:bteq < select_test.bteq > select_test.outthanks stami27 |
6 | 20 Apr 2006 @ 09:48 PDT | Database | Reply | Write/Read external file from within Stored Procedure? | Hi,had a similar problem.My stored procedure write in a table and then whith a simple bteq (on Unix) exported the table to a file.Example of bteq:---------------------------------------------------... |
5 | 28 Feb 2006 @ 08:41 PST | Database | Reply | Trial Teradata-DWH-CD | I've found it!http://www.teradata.com/t/page/44749/index.html |
4 | 28 Feb 2006 @ 08:22 PST | Database | Topic | Trial Teradata-DWH-CD | Hi,does anyone knows if or where can I get a trial Teradata-DWH-CD for Windows/XP? Best Regardsstami27 |
3 | 28 Feb 2006 @ 08:00 PST | Database | Reply | doesn't have access to create a stored procedure | Hi varun,ask your DBA to give you the create/update/execute rights or if you are the sysdba make that yourself with the Teradata Administrator.Best regardsstami27 |
2 | 20 Feb 2006 @ 12:37 PST | Database | Reply | Stored Procedures | Thanks Barry,I have found a Solution with the Dynamic SQL using the INSERT..SELECT statement.This is my Solution: SET hselt1='INSERT INTO sgia2708.AccLogTbl SELECT * FROM dbc.AccLogTbl where D... |
1 | 17 Feb 2006 @ 04:03 PST | Database | Topic | Stored Procedures | Hi,I'm 'newbie' to Teradata but with some experience in Oracle PL/SQL.I would like to do samthing like this:(Read a User-Table with Table names and get some Information from DBC.AccessLog-Table)CRE... |