380 | 15 Mar 2008 @ 10:49 PDT | Database | Reply | Column_Type Description | There's sort of a round about waySELECT TYPE(MYTABLE.COL1);Type(COL1)-----------INTEGER |
379 | 14 Mar 2008 @ 12:11 PDT | Analytics | Reply | Can 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 |
378 | 13 Mar 2008 @ 11:45 PDT | Tools | Reply | Dictionary Views | The 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... |
377 | 13 Mar 2008 @ 11:44 PDT | Database | Reply | How 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... ??? |
376 | 13 Mar 2008 @ 11:38 PDT | Database | Reply | user defined exception | The 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 ... |
375 | 13 Mar 2008 @ 01:01 PDT | Analytics | Reply | Can a stored procedure be called thru a view ? | No, but you can call a UDF |
374 | 12 Mar 2008 @ 12:02 PDT | Database | Reply | How 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 ... |
373 | 11 Mar 2008 @ 11:30 PDT | Database | Reply | How 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) |
372 | 10 Mar 2008 @ 10:25 PDT | Database | Reply | Date Difference | WHERE ADD_MONTHS(DT1, 36) < DT2; |
371 | 09 Mar 2008 @ 06:16 PDT | Database | Reply | Collect 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... |
370 | 07 Mar 2008 @ 08:26 PST | Database | Reply | Delete duplicates | I 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 ... |
369 | 07 Mar 2008 @ 08:24 PST | Database | Reply | teradata stored procedures | Do an F2 in sqlassistant/queryman |
368 | 07 Mar 2008 @ 01:04 PST | Database | Reply | Finding Continuos Span | To 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... |
367 | 06 Mar 2008 @ 11:08 PST | Analytics | Reply | Convert Text to Proper Case is huge problme | One 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... |
366 | 05 Mar 2008 @ 09:13 PST | Tools | Reply | Optimal 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... |
365 | 05 Mar 2008 @ 01:53 PST | Database | Reply | Macro | you can't specify the table name or column name as variables in macros ... |
364 | 03 Mar 2008 @ 08:54 PST | Database | Reply | dropping indexes | Press 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; |
363 | 01 Mar 2008 @ 01:35 PST | Tools | Reply | Records in UV table | Perhaps 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 ... |
362 | 01 Mar 2008 @ 01:28 PST | Tools | Reply | Problem in importing data from text file to teradata database using bteq | can you share your scripts, table structure, sample data etc...May be it's just a data conversion issue. |
361 | 29 Feb 2008 @ 10:08 PST | Database | Reply | still error 10065 WSA | what does pdestate -a say ?Also check your windows event logs .. may throw some clue... |
360 | 28 Feb 2008 @ 09:58 PST | Database | Reply | Global Tables and COLLECT STATISTICS ON TEMPORARY | I 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... |
359 | 28 Feb 2008 @ 10:14 PST | Tools | Reply | SELECT INTO Class in BTEQ | you 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 ? |
358 | 26 Feb 2008 @ 10:23 PST | Database | Reply | Masking commas within a macro parameter | There 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... |
357 | 22 Feb 2008 @ 08:18 PST | Database | Reply | Can't Login into server database after creating system DSN | Bteq 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... |
356 | 20 Feb 2008 @ 09:31 PST | Connectivity | Reply | JDBC Primary Index | INDEX_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 ... |