#DateForumTypeThreadPost
2201 Aug 2006 @ 12:39 PDTAnalyticsReplyReplace( ) & Ascii Characters:CHR( ) in TeradataHi 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...
2117 Jul 2006 @ 09:07 PDTConnectivityReplyEfficiency UDF scalar function vs.conventional SQLThanks 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...
2012 Jul 2006 @ 12:05 PDTAnalyticsReplyIS-NUMERIC functionsHi 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...
1917 Jun 2006 @ 01:39 PDTDatabaseReplyCollecting Statistics on multiple ColumnsHi PhanyThanks for the reply.Does exist a place in the teradata documentation, where it is mentioned?greetings stami
1813 Jun 2006 @ 06:30 PDTConnectivityTopicEfficiency UDF scalar function vs.conventional SQLTo 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...
1708 Jun 2006 @ 07:34 PDTDatabaseReplyUDFHi 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...
1608 Jun 2006 @ 05:16 PDTDatabaseReplyUDFHi, 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/...
1508 Jun 2006 @ 04:10 PDTDatabaseReplyUDFHi,In http://www.teradataforum.com/is huge amount of Tips and examples.eg.http://www.teradataforum.com/is_integer.htmgreetingsstami
1406 Jun 2006 @ 09:40 PDTDatabaseTopicCollecting Statistics on multiple ColumnsHi 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...
1301 Jun 2006 @ 06:42 PDTToolsReplyEncountering error while using .EXPORT REPORT FILE command in BTEQHi,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...
1226 May 2006 @ 03:36 PDTDatabaseReplycan 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...
1126 May 2006 @ 08:49 PDTDatabaseReplyCan I catch an OUT variable(s) from a stored procedure?Thanks for these suggetion AKIRAgreetingsstami27
1026 May 2006 @ 08:44 PDTDatabaseReplycan 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 ...
923 May 2006 @ 10:23 PDTDatabaseTopicCan 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...
823 May 2006 @ 10:10 PDTDatabaseTopicCan 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...
720 Apr 2006 @ 11:36 PDTDatabaseReplyWrite/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
620 Apr 2006 @ 09:48 PDTDatabaseReplyWrite/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:---------------------------------------------------...
528 Feb 2006 @ 08:41 PSTDatabaseReplyTrial Teradata-DWH-CDI've found it!http://www.teradata.com/t/page/44749/index.html
428 Feb 2006 @ 08:22 PSTDatabaseTopicTrial Teradata-DWH-CDHi,does anyone knows if or where can I get a trial Teradata-DWH-CD for Windows/XP? Best Regardsstami27
328 Feb 2006 @ 08:00 PSTDatabaseReplydoesn't have access to create a stored procedureHi 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
220 Feb 2006 @ 12:37 PSTDatabaseReplyStored ProceduresThanks 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...
117 Feb 2006 @ 04:03 PSTDatabaseTopicStored ProceduresHi,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...