#DateForumTypeThreadPost
38015 Mar 2008 @ 10:49 PDTDatabaseReplyColumn_Type DescriptionThere's sort of a round about waySELECT TYPE(MYTABLE.COL1);Type(COL1)-----------INTEGER
37914 Mar 2008 @ 12:11 PDTAnalyticsReplyCan a stored procedure be called thru a view ?macros can call stored procedures as well as execute other macros ...however you cannot execute a macro from a stored proc as of v2r6
37813 Mar 2008 @ 11:45 PDTToolsReplyDictionary ViewsThe only two reasons I can think of is(1) You are logging into two different teradata servers(2) You are using two different login ids in both cases (dbc.users would display data dependent on the u...
37713 Mar 2008 @ 11:44 PDTDatabaseReplyHow to avoid line feed?It worked on my test data.... so not sure what could be the reason it didn't work for you ...did it throw an error ? misplaced wrong characters... ???
37613 Mar 2008 @ 11:38 PDTDatabaseReplyuser defined exceptionThe stored procedures orange book describes a way in which you can make use of an external stored procedure to generate exceptions. You might want to take a stab on that example ...
37513 Mar 2008 @ 01:01 PDTAnalyticsReplyCan a stored procedure be called thru a view ?No, but you can call a UDF
37412 Mar 2008 @ 12:02 PDTDatabaseReplyHow to avoid line feed?You can probably try making use of a recursive query like this .....I am not sure if you can run an update directly using it, but should be able to insert into an intermediate table which can then ...
37311 Mar 2008 @ 11:30 PDTDatabaseReplyHow to avoid line feed?If you have line feeds only at the end of the string value, then probably this is what you need in the update statement.TRIM( TRAILING x'0A' FROM col1)
37210 Mar 2008 @ 10:25 PDTDatabaseReplyDate DifferenceWHERE ADD_MONTHS(DT1, 36) < DT2;
37109 Mar 2008 @ 06:16 PDTDatabaseReplyCollect statistics in 1 scan?It's not "solved" because it's not considered a "problem"... (works as designed ;) )As far as I know, there was a feasibility study done on doing it in parallel but was later abandoned due to high...
37007 Mar 2008 @ 08:26 PSTDatabaseReplyDelete duplicatesI think you can do it using rowid, if it's enabled in the dbscontrol...but there's no straightforward way if I remember correctly other than using an intermediate table ...
36907 Mar 2008 @ 08:24 PSTDatabaseReplyteradata stored proceduresDo an F2 in sqlassistant/queryman
36807 Mar 2008 @ 01:04 PSTDatabaseReplyFinding Continuos SpanTo be honest I am little confused with requirements (may be because these are the moth hours for me...)In the second sample shouldn't you be picking the range01/01/1998 12/31/2001 which is 4 yrs co...
36706 Mar 2008 @ 11:08 PSTAnalyticsReplyConvert Text to Proper Case is huge problmeOne sample dirty tick is this one ....CREATE TABLE DATA004(CITYNAME VARCHAR(30));INSERT INTO DATA004 VALUES('WEST MINISTER');INSERT INTO DATA004 VALUES('COSTA MESA CITY');INSERT INTO DATA004 VALUES...
36605 Mar 2008 @ 09:13 PSTToolsReplyOptimal Fastload/Multiload sessions.volume of data, number of amps, other concurrent load jobs etc needs to be kept in mind... keep monitoring the logs, check if increasing/decreasing the number of sessions have an impact (remember t...
36505 Mar 2008 @ 01:53 PSTDatabaseReplyMacroyou can't specify the table name or column name as variables in macros ...
36403 Mar 2008 @ 08:54 PSTDatabaseReplydropping indexesPress F2 on your queryman/sql assistant to get all the basic syntax you would need...Quoting example From queryman help,DROP INDEX (DeptNo) ON employee;
36301 Mar 2008 @ 01:35 PSTToolsReplyRecords in UV tablePerhaps you mixed up the ordering of the error tables in the load job ? the ET tables comes first and then the UT... remember that names as such has little importance to the load utility, it's the ...
36201 Mar 2008 @ 01:28 PSTToolsReplyProblem in importing data from text file to teradata database using bteqcan you share your scripts, table structure, sample data etc...May be it's just a data conversion issue.
36129 Feb 2008 @ 10:08 PSTDatabaseReplystill error 10065 WSAwhat does pdestate -a say ?Also check your windows event logs .. may throw some clue...
36028 Feb 2008 @ 09:58 PSTDatabaseReplyGlobal Tables and COLLECT STATISTICS ON TEMPORARYI have a feeling that you are using the wrong kind of tables for this process...Global temporary tables are used when you want different sessions to use table with same name and structure but SHOUL...
35928 Feb 2008 @ 10:14 PSTToolsReplySELECT INTO Class in BTEQyou mentioned you want to store the results into a command file...in that case perhaps the .export file command of bteq would be of help to you ?
35826 Feb 2008 @ 10:23 PSTDatabaseReplyMasking commas within a macro parameterThere are always a bit of "dirty code" that can be written... (atleast for academic purposes)CREATE MACRO RECMAC(VALS VARCHAR(100))AS(WITH RECURSIVE EXPRN (VALU, RMSTRING )AS( SELECT (TRIM(CASE POS...
35722 Feb 2008 @ 08:18 PSTDatabaseReplyCan't Login into server database after creating system DSNBteq and other CLI based applications like mload, fastload, fexp etc ... don't use DSN to connect to a teradata system... you need to use the tdpid of the system to login ...(optionally hostname/ip...
35620 Feb 2008 @ 09:31 PSTConnectivityReplyJDBC Primary IndexINDEX_NAME would be NULL if the index wasn't given a name during the time of creation (which is purely optional in TD) ... (you can check the table DDL via the show table tablename) command to see ...

Pages