#DateForumTypeThreadPost
20520 Jul 2007 @ 12:49 PDTDatabaseReplyProblem with Teradata Service ControlDon't recall correctly, I wonder if it was that Bynet was not installed ?You can also try starting the Teradata Gateway Service from the windows services panel. might get some better error message ...
20418 Jul 2007 @ 01:21 PDTConnectivityReplyJDBC and calling a macroHere's a sample code I could get to work ....-- Macro definitionREPLACE MACRO SEL_EMP_MAC(EMPID INTEGER)AS( SELECT EMPNAME FROM EMPLOYEE WHERE EMPID = :EMPID;);// java program ....import java.sql....
20317 Jul 2007 @ 12:17 PDTToolsReplyUpdating Teradata Compiler and Linker Paths (cufconfig -f ) - HELP REQUIREDOops I thought you had that info already I am not sure if all those registry entries are required ... in our Demo systems [on Win XP], we normally use only these two ... and we have everything from...
20217 Jul 2007 @ 12:01 PDTConnectivityReplyJDBC and calling a macroI haven't tried, but I think this can be accomplished via[Statement/PreparedStatement].[execute() / executeQuery()] ;
20116 Jul 2007 @ 12:11 PDTToolsReplyUpdating Teradata Compiler and Linker Paths (cufconfig -f ) - HELP REQUIREDI think you need to include the executable names as well ...try something like this .....CompilerPath: D:\Program Files\Microsoft Visual Studio 8\VC\bin\CL.EXELinkerPath: D:\Program Files\Microsoft...
20011 Jul 2007 @ 11:06 PDTTrainingReplyError 3802I cannot recall correctly, but I think you need to enter DemoTDAT where it says Database Name.
19911 Jul 2007 @ 07:28 PDTAnalyticsReplyConcatenate Vertically?Umm.... May be this is a job for someone smarter ;-) I can only think of a volatile table based solution.given the limitations of recursion. (did I say crashed TD and now we have a bug to open ? :...
19811 Jul 2007 @ 06:45 PDTAnalyticsReplyConcatenate Number, How to remove dot (.) in the result?Z, when used with integer types implies a place holder for a digit, which if there are no digits, could be supplemented with a space. 9, on the other hand will supplement a missing digit with 0so i...
19711 Jul 2007 @ 04:43 PDTAnalyticsReplyConcatenate Number, How to remove dot (.) in the result?Try playing with format and trim ...... like this ..SELECT TRIM(60122011506 (FORMAT 'Z(17)9') ) || ','
19611 Jul 2007 @ 02:10 PDTToolsReplyQuery ProblemTo begin with, you cant give a select query on the RHS of the set clause, that's why you got the syntax error.you will have to use the join syntax of update.There's no where clause for your update,...
19511 Jul 2007 @ 01:29 PDTDatabaseReplySample without duplicatesSimple explanation is this.for rank() function, if two records belong to the same partitioning expression value and also have same values for the order by columns, they get the same rank.for row_nu...
19411 Jul 2007 @ 01:16 PDTAnalyticsReplyConcatenate Vertically?This is what I tried ...CREATE TABLE CNTRYRECUR(NUMBER INTEGER, COUNTRY VARCHAR(30));INSERT INTO CNTRYRECUR VALUES(1, 'USA')INSERT INTO CNTRYRECUR VALUES(2, 'NYK')INSERT INTO CNTRYRECUR VALUES(3, '...
19310 Jul 2007 @ 01:08 PDTDatabaseReplySample without duplicatesif your partitioning and ordering expressions are the same, then your rank output will always be 1.you can use row_number() instead of rank as mentioned in the above posts.
19210 Jul 2007 @ 12:47 PDTAnalyticsReplyConcatenate Vertically?Pure SQL solution would require a recursive query AFAIK.Assuming the "NUMBER" column is contiguous without any gaps, and is unique, this is one possible solution.WITH RECURSIVE CNTRINFO(NUMBER, COU...
19109 Jul 2007 @ 08:17 PDTAnalyticsReplyRound Up and Round to Nearest?There's probably a better way, but this is all I can think of on a sleepy brain ;-) SELECT 15.4632 X, X(DECIMAL(18,2)), (X+0.005) (DECIMAL(18,2)); 15.4632 15.46 15.47
19007 Jul 2007 @ 07:16 PDTUDAReplyCreate Recursive ViewThat's probably your TTU version, not DBC .....And did you use the syntax for creating recursive views ?REPLACE RECURSIVE VIEWMay be if you can post your SQL, it could help.
18906 Jul 2007 @ 01:09 PDTDatabaseReplyHelp!I don't think you can specify a SEL query in the SET claue.You might want to try something like this.UPDATE TABLE_2FROM(select b._acct_num, min(b.data_dt) from table_test b, table_2 tWHERE t._acct_...
18806 Jul 2007 @ 01:02 PDTToolsReplyDeclaring variables in TERADATA BTEQsNormally in unix client platforms, a combination of shell variables and HERE documents are used to accomplish this.I am not sure if other platforms have something similar.
18706 Jul 2007 @ 12:51 PDTUDAReplyFast/Multi Load & Control CharactersYes, it would be more of a data quality issue, that needs to be fixed at the source system. I am personally against any translation done at the receiving system, as it might have the wrong results ...
18603 Jul 2007 @ 11:11 PDTAnalyticsReplyHow to Concatenate Include Comma(,)?SEL City || ',' || CountryFrom Demografic;
18503 Jul 2007 @ 11:02 PDTUDAReplyDynamic WHERE clause in CursorAFAIK, The prepare statement syntax is used for embedded SQL applications..ok this is what I had in mind ...., I haven't tested the syntaxREPLACE PROCEDURE SP_TEST( IN vMetric VARCHAR(30))BEGIN-- ...
18403 Jul 2007 @ 03:04 PDTDatabaseReplySelecting ODD numbered rows from a Table!A record is first distributed to an AMP based on the rowhash of the primary index column values. And with in an AMP it's sorted logically in the order of Partition (if it has PPI) and then by the r...
18303 Jul 2007 @ 12:14 PDTDatabaseReplySelecting ODD numbered rows from a Table!looks like you are trying to get a sample... in which case, you might want to try the sample clauseSELECT * FROM MYTABLESAMPLE 10;gives you 10 randomly selected recordsSELECT * FROM MYTABLESAMPLE ....
18203 Jul 2007 @ 12:10 PDTUDAReplyDynamic WHERE clause in Cursoryou can't do it that way.what you need is an SP, that will generate a dynamic SQL statement and execute it.the dynamic SQL will have to insert/select the result sets into a temporary table (use a v...
18102 Jul 2007 @ 11:53 PDTUDAReplyFast/Multi Load & Control Charactersfixed width format is when you specify what is the maximum length of each field, and pad the rest with zero/spaces.for exampleif this is a variable text format, with pipe delimiters.123|shannera@gr...

Pages