All forum activity

#DateUserForumTypeThreadPost
144220 Jul 2006 @ 01:49 PDTFredUDAReplyCould I stop an abort session?CANCEL ROLLBACK ON TABLE is not available prior to V2R5.1.
144120 Jul 2006 @ 01:19 PDTFredConnectivityReplyTrying to set up ODBC connectionThe driver download file is actually a self-extracting "bundle" that includes the appropriate TeraGSS and TDICU as well as the driver itself.
144020 Jul 2006 @ 10:28 PDTj355gaDatabaseReply"Select Into" can't be used in teradata?SELECT INTO is supported in Teradata stored procedures. V2R5 and above.
143920 Jul 2006 @ 04:34 PDTUwe PosseltConnectivityReplyTrying to set up ODBC connectionHi,I have the same problem. The newest ODBC driver (6/28/2006 11:25:48 AM) can be downloaded at "http://www.teradata.com/t/go.aspx/index.html?id=152251"But where I can download the "Teradata Generi...
143820 Jul 2006 @ 01:27 PDTJohn MacUDAReplyCould I stop an abort session?oops..Alfredo,Do you have a friendly DBA around with access to the database window ?That's where you'll need to start the recovery manager.In the Supervisor screen of the database window, type 'sta...
143720 Jul 2006 @ 01:25 PDTJohn MacUDAReplyCould I stop an abort session?Alfredo,Do you have a friendly DBA around with access to the database window ?That's where you'll need to start the recovery manager.In the Supervisor screen of the database window, type (you'll n...
143620 Jul 2006 @ 12:10 PDTAlfredoUDAReplyCould I stop an abort session?Yes I want to do that.I have a backup.Could you tell me how to do it?My version of teradata is VERSION 05.00.02.31RELEASE V2R.05.00.02.28Thank you
143519 Jul 2006 @ 11:20 PDTJohn MacUDAReplyCould I stop an abort session?Alfredo,If you mean that you have an aborting session and you'd like to kill the abort process, then yes, you can by using the CANCEL ROLLBACK option in Recovery Manager.Bear in mind though, you'll...
143419 Jul 2006 @ 07:38 PDTj355gaDatabaseTopicrisk associated with dynamic sqlCan anyone relate any risks they have encountered using dynamic sql in Teradata stored procedures?Rumors that I have head (but have not seen any documentation on):a) it is policy to not grant perm ...
143319 Jul 2006 @ 04:34 PDTAlfredoUDATopicCould I stop an abort session?I have an abort session of a delete job.Are there some way to stop the abort session?
143219 Jul 2006 @ 04:32 PDTAlfredoUDATopicProblem with delte in an abort sesionHiI hope that somebody could help me!!!I execute a delete sentence in a table with a lot of information, this table has 4 secondary indexes. My process had 2 hours running but we decide to abort th...
143119 Jul 2006 @ 01:43 PDTFredToolsReplyMLOAD VARTEXT FORMATTEXT or UNFORMAT don't recognize field delimiters, they are fixed format. If there are delimiters in exactly the same column position in every record, you could ignore them - either using explicit ...
143019 Jul 2006 @ 01:32 PDTFredUDAReplyNULLIf you don't COMPRESS, a NULL will occupy the same space on disk as blank or zero - e.g. for CHAR(10) that's 10 or 20 bytes (depends on the Character Set) plus an indicator bit in the rowheader.
142919 Jul 2006 @ 12:53 PDTilyasUDATopicNULLIf I declare a NULL coulmn and don't COMPRESS that column then how much space that NULL value will take.e.g Address char(10) and I insert null for address field then how much space this null will o...
142819 Jul 2006 @ 07:34 PDTBarry-1604DatabaseReply"Select Into" can't be used in teradata?You can also create the result table "on the fly" with:create table Temp_Persons as(select name,gender,age from persons where age>18) with dataprimary index(name);
142719 Jul 2006 @ 06:23 PDTtintin_rkToolsTopicLoading data using TPUMPHow to eliminate/exclude the very first row while loading data using TPUMP utility?
142619 Jul 2006 @ 02:37 PDTdeeps_v_37DatabaseReply"Select Into" can't be used in teradata?If u r intending to select the name gender and age fields of Persons and trying to insert them into temp_persons, U can use Insert-into clause.Insert into Temp_Persons(name,gender,age)select name,g...
142519 Jul 2006 @ 01:35 PDTvinod_sugurDatabaseReplyDate format - FMDD?The query helps in getting the desired output but the string format not able to convert back to date.select CASEWHEN SUBSTRING(CAST(DATE -11 AS FORMAT 'DD') FROM 1 FOR 1 ) = 0 THEN SUBSTRING(CA...
142419 Jul 2006 @ 12:06 PDTgiriToolsReplyteradata architectureHiTry this SELECT hashamp (hashbucket (hashrow (Primary index)))as "AMP"FROM tablenamehashrow gives the row hash valuehashbucket gives the bucket value that maps the AMPhashamp gives the AMP in wh...
142318 Jul 2006 @ 11:52 PDTgiriToolsReplyMLOAD VARTEXT FORMATHi,Thank u for the Suggestions . Now if I use FORMAT (TEXT or UNFORMAT)in multiload how will I specify the Delimiters and EOF condition.Thank U.Giri
142218 Jul 2006 @ 11:50 PDTn4247558DatabaseTopic"Select Into" can't be used in teradata?I found that "select into" function can't be used in teradata.e.g. SELECT * INTO Temp_PersonsSELECT name, gender, ageFROM PersonsWHERE age > 18;Any method in teradata can be used instead?
142118 Jul 2006 @ 11:14 PDTn4247558DatabaseTopicDate format - FMDD?In oracle, if date format is set to be "dd-mm-yyyy" -> 01-12-2006if it's set to be "fmdd-mm-yyyy" -> 1-12-2006.But how about in teradata......i wanna to use the function like 'fmdd', how to make it?
142018 Jul 2006 @ 07:20 PDTjkleeToolsTopicLooking for BTEQ TemplatesI'm looking for a template to use for generating BTEQ scripts.Something that already has the standard audit info at the top (name, author, date, purpose, etc) and some standard options that need to...
141918 Jul 2006 @ 05:45 PDTTeradataStaffingSpecialistJobsTopicTeradata Professionals-All Positions!!!Hello We are an Ohio based IT Consulting firm specializing in Teradata. We have several openings for Teradata professionals right from Developer to an architect If you have Teradata experience th...
141818 Jul 2006 @ 02:00 PDTAquent | Marketing IT | NYCJobsTopicBusiness Intelligence Manager opportunity in NYCOur client's Business Intelligence team seeks a Manager.The position has primary responsibility for developing user requirements and functional specifications specific to business initiatives for t...

Pages