All forum activity

#DateUserForumTypeThreadPost
56921 Mar 2006 @ 01:11 PSTMNagatToolsReplyMonitoring rollback / abort progressThanks Fred.Although I'd like to have more detailed info on what happenned to the query, the recovery console does it for us now since we have an estimate of how long it will take to finish.
56821 Mar 2006 @ 10:44 PSTwilliamdieterConnectivityTopicConnection Pooling with Visual Basic .NETHey everyone, I have run into some issues while connecting to Teradata through .NETIt's my understanding that .NET doesn't maintain a single connection to Teradata, it might open several connection...
56721 Mar 2006 @ 08:57 PSTsuvomoyAnalyticsReplyTeradata function equivalent to 'LIKE %..%' in TeradataHi all,Can we try same kind of pattern matching involving "LIKE" operator when i am looking for a special character like '_'.As the 'instr' function does not work with Teradata (Upto my knowledge) ...
56621 Mar 2006 @ 02:58 PSTMATIZToolsReplyBTEQ logon problemYOU CAN NOT USE .LOGON TDPID/USERNAME,PASSWORDIN INTERACTIVE MODETHIS WAY USE IN BATCH MODEIN INTERACTIVE MODE use this.LOGON TDPID/USERNAME 'PRESS ENTER'.LOGON TDPID/USERNAME PASSWOR...
56520 Mar 2006 @ 10:29 PSTFredToolsReplyMonitoring rollback / abort progressIn V2R5.1 and later, the Recovery Manager (rcvmanager) utility LIST ROLLBACK TABLES command gives progress information related to long rollbacks.RcvManager can be accessed via the Teradata Manager ...
56420 Mar 2006 @ 07:00 PSTshaik.feroz@aaa-calif.comDatabaseReplymacroscreate macro samplemacro(variable1 int, variable2 char(3))as(Update table1 set col1 = col1 * :variable1where col2 = :variable2;);in the shell scriptexec samplemacro(2,'ABC')orexec samplemacro(varia...
56320 Mar 2006 @ 06:47 PSTshaik.feroz@aaa-calif.comDatabaseReplyselect first N recordsAre you trying to get just 10 records?if this is the case use sample (BUT THIS WILL GIVE ANY 10 records)select emp_name from employeesample 10;Are you trying to get the first 10 or last 10 based on...
56220 Mar 2006 @ 04:14 PSTbarni07DatabaseTopicselect first N recordsIn Informix, I could do SELECT FIRST 10 * FROM T1 , to get the top 10 records.In Sql Server or Access I could write SELECT TOP 10 * FROM T1.Any way to do it in Teradata?
56120 Mar 2006 @ 03:20 PSTbarni07DatabaseReplyRun an Update with a subselectI reply to myself:UPDATE T1 FROM (SELECT t2_1, MIN(t2_2) from T2 group by 1) as D (D1, D2) SET Field2 = D2 WHERE Field1 = D1Got it :-)
56020 Mar 2006 @ 03:12 PSTbarni07DatabaseTopicRun an Update with a subselectIs it possible to build an update statement with a subselect? I mean, I have a table T1 with two fields: Field1 (PRIMARY KEY), Field2. I have another table T2 with two fields: T2_1, T2_2. I need so...
55920 Mar 2006 @ 03:06 PSTbarni07DatabaseReplyCan't connect to TeradataThank you. Now i'm able to log on. I hadn't installed the Demo, so I didn't have the Teradata Service Control and I couldn't start the database. Once I did that, I logged on as you said, with dbc, ...
55820 Mar 2006 @ 02:29 PSTKarrajConnectivityTopicTeradata ODBC 03.04.00.00 setting for handling UTF8 dataTeradata ODBC 03.03 was working fine when used for moving UTF8 data. But with the same setting when ODBC was upgraded to 03.04.00.00, the UTF8 characters are not handled properly. Is there some thi...
55720 Mar 2006 @ 01:53 PSTcandymanConnectivityReplyODBC- Enable MS-ACCESS Interoperability ModeHey, Its up! Cool Thanks
55620 Mar 2006 @ 12:28 PSTcandymanConnectivityReplyODBC- Enable MS-ACCESS Interoperability ModeHow do I tell the Patch #? Or should I just test release 8.0 to the non working PC, then if it works, load to the working laptop?
55520 Mar 2006 @ 12:25 PSTVik2006ToolsTopicmload acquision phase count checkHi,We have a MLOAD script that reads data from pipe separated data file. As I can see the acquisition phase count (Candidate records considered) during the MLOAD process in the log file. Customer w...
55420 Mar 2006 @ 11:28 PSTMNagatToolsTopicMonitoring rollback / abort progressHi experts,I was wondering if there really isn't a way for us to see the progress of a job when it is aborting due to any kind of failure. Specially if it's rolling back what it's done so far.On TD...
55320 Mar 2006 @ 02:58 PSTpoonamDatabaseTopicmacroshi, can someone plz pass on the sql to create a macro and the syntax to call the macro from a shell script.thanks.
55219 Mar 2006 @ 06:28 PSTKksTrainingTopicTeradata Professional needed (South Africa)Hello all,Teradata Professional needed for a leading financial company in South Africa ,you should have more than 1 yr experience on Teradata as Teradata Developer/ ETL / DBA etc. in a large projec...
55119 Mar 2006 @ 06:24 PSTKksToolsTopicTeradata Professional needed (South Africa)Hello all,Teradata Professional needed for a leading financial company in South Africa ,you should have more than 1 yr experience on Teradata as Teradata Developer/ ETL / DBA etc. in a large projec...
55019 Mar 2006 @ 06:22 PSTKksDatabaseTopicTeradata Professional needed (South Africa)Hello all,Teradata Professional needed for a leading financial company in South Africa ,you should have more than 1 yr experience on Teradata as Teradata Developer/ ETL / DBA etc. in a large projec...
54917 Mar 2006 @ 03:45 PSTMNagatDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.I'm a little unsure of using IDENTITY even with DECIMAL(18) because of this parallel implementation, since the 5753 error - Numbering for Identity Column columnname is over its limit - happens if t...
54817 Mar 2006 @ 03:32 PSTMNagatDatabaseReplyidentity column reached its maximum limitYou better use DECIMAL because of the distribution/amp nature of TD's implementation for IDENTITY. Please see this for more details:http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=9&m...
54717 Mar 2006 @ 03:26 PSTfarenasToolsTopicParameters and BTEQHi folks:I'm trying to make a simple unix script shell to define a variable and execute a bteq command. For example:#!/bin/shhomeDir=/home/OprBCI/FAA/MigracProcbteq < arch.btq > arch.out## End of ...
54617 Mar 2006 @ 01:09 PSTterauser1AnalyticsReplyidentity columnsALWAYS: Identity column values are always system generated.BY DEFAULT: Identity column values can be system generated or user inserted.You cannot insert values into, nor can you update, an identity...
54517 Mar 2006 @ 12:38 PSTBaldTonyDatabaseReplyHow can I spot strings that are in UPPER case?Supreme Being Deiter, I am in your debt. Worked a treat.Many Thanks.

Pages