| 567 | 21 Mar 2006 @ 08:57 PST | suvomoy | Analytics | Reply | Teradata function equivalent to 'LIKE %..%' in Teradata | Hi 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) ... |
| 566 | 21 Mar 2006 @ 02:58 PST | MATIZ | Tools | Reply | BTEQ logon problem | YOU 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... |
| 565 | 20 Mar 2006 @ 10:29 PST | Fred | Tools | Reply | Monitoring rollback / abort progress | In 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 ... |
| 564 | 20 Mar 2006 @ 07:00 PST | shaik.feroz@aaa-calif.com | Database | Reply | macros | create 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... |
| 563 | 20 Mar 2006 @ 06:47 PST | shaik.feroz@aaa-calif.com | Database | Reply | select first N records | Are 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... |
| 562 | 20 Mar 2006 @ 04:14 PST | barni07 | Database | Topic | select first N records | In 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? |
| 561 | 20 Mar 2006 @ 03:20 PST | barni07 | Database | Reply | Run an Update with a subselect | I 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 :-) |
| 560 | 20 Mar 2006 @ 03:12 PST | barni07 | Database | Topic | Run an Update with a subselect | Is 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... |
| 559 | 20 Mar 2006 @ 03:06 PST | barni07 | Database | Reply | Can't connect to Teradata | Thank 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, ... |
| 558 | 20 Mar 2006 @ 02:29 PST | Karraj | Connectivity | Topic | Teradata ODBC 03.04.00.00 setting for handling UTF8 data | Teradata 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... |
| 557 | 20 Mar 2006 @ 01:53 PST | candyman | Connectivity | Reply | ODBC- Enable MS-ACCESS Interoperability Mode | Hey, Its up! Cool Thanks |
| 556 | 20 Mar 2006 @ 12:28 PST | candyman | Connectivity | Reply | ODBC- Enable MS-ACCESS Interoperability Mode | How 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? |
| 555 | 20 Mar 2006 @ 12:25 PST | Vik2006 | Tools | Topic | mload acquision phase count check | Hi,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... |
| 554 | 20 Mar 2006 @ 11:28 PST | MNagat | Tools | Topic | Monitoring rollback / abort progress | Hi 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... |
| 553 | 20 Mar 2006 @ 02:58 PST | poonam | Database | Topic | macros | hi, can someone plz pass on the sql to create a macro and the syntax to call the macro from a shell script.thanks. |
| 552 | 19 Mar 2006 @ 06:28 PST | Kks | Training | Topic | Teradata 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... |
| 551 | 19 Mar 2006 @ 06:24 PST | Kks | Tools | Topic | Teradata 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... |
| 550 | 19 Mar 2006 @ 06:22 PST | Kks | Database | Topic | Teradata 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... |
| 549 | 17 Mar 2006 @ 03:45 PST | MNagat | Database | Reply | Identity 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... |
| 548 | 17 Mar 2006 @ 03:32 PST | MNagat | Database | Reply | identity column reached its maximum limit | You 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... |
| 547 | 17 Mar 2006 @ 03:26 PST | farenas | Tools | Topic | Parameters and BTEQ | Hi 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 ... |
| 546 | 17 Mar 2006 @ 01:09 PST | terauser1 | Analytics | Reply | identity columns | ALWAYS: 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... |
| 545 | 17 Mar 2006 @ 12:38 PST | BaldTony | Database | Reply | How can I spot strings that are in UPPER case? | Supreme Being Deiter, I am in your debt. Worked a treat.Many Thanks. |
| 544 | 17 Mar 2006 @ 11:24 PST | Renato Dba | Database | Reply | Can't connect to Teradata | Hi,if I understood its question, when you install the teradata DEMO, the using standard is the DBC and the password is the same one. After Logon, create another user and modifies the password of t... |
| 543 | 17 Mar 2006 @ 11:06 PST | rlaskar | Database | Reply | Define Teradata? | http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfm?page=Teradata%20DatabaseYou will find lot of document on teradataThanks,rlaskar |
