59442 | 25 Aug 2016 @ 05:05 PDT | Fred | Analytics | Reply | Release Lock from a Table | If you ROLLBACK / ABORT or COMMIT the transaction, then the locks are released. And in Teradata mode, a database error causes an automatic rollback before returning the error status to the client.
|
59441 | 25 Aug 2016 @ 05:01 PDT | Fred | Tools | Reply | Teradata 14.10 History Window Gone | Under Tools / Options / File paths tab, be sure the history file path exists, is writeable, and has space.
|
59440 | 25 Aug 2016 @ 04:51 PDT | Fred | Database | Reply | How to grant all required privileges retained by DBC to my new admin user? | WITH ADMIN OPTION means you can grant role membership to or revoke role membership from other users (or roles), or DROP the role. But a role initially conveys no database rights, you have... |
59439 | 25 Aug 2016 @ 04:49 PDT | agnit.chatterjee1988 | Database | Reply | When to use Join Index | Thanks Samir for your reply.
|
59438 | 25 Aug 2016 @ 04:17 PDT | siddarthy | General | Reply | interview help | siddarthy8@gmail.com
mrsuryatej@gmail.com
can you please forward the document. Thanks
|
59437 | 25 Aug 2016 @ 03:39 PDT | franceszhu | Database | Topic | How to grant all required privileges retained by DBC to my new admin user? | I created an administrative user "DBADMIN" from user DBC by following the standard best practice. The admin user will manager all the subsequent users and databases. However, I am not cle... |
59436 | 25 Aug 2016 @ 02:49 PDT | SureshKT | Analytics | Reply | Query_Discussion_HELP | Hi All,
I have a question on similar lines. I am trying to understand from Architecture presepctive how Teradata will behave for the below scenario. Any help would be appreciated. Especially expec... |
59435 | 25 Aug 2016 @ 02:27 PDT | imgregduh | Tools | Topic | SchemaLoader results? Views via EF to EDMX? | Is there a way to get the SchemaLoader results?
The cmd prompt it opens closes immediately and I cant seem to pause it to read what it output.
I cant tell what went wrong or what went right... |
59434 | 25 Aug 2016 @ 12:49 PDT | feinholz | Tools | Reply | TPT Script - Import from TD into HDFS. | As with any other TD-to-flat-file TPT scenario, you can use the Export-operator-to-DC-operator scenario.
This will export data from Teradata and write to HDFS.
Just provide the information for th... |
59433 | 25 Aug 2016 @ 12:22 PDT | aaibinder | Tools | Topic | TPT Script - Import from TD into HDFS. | I've been searching for this in documentation all day, maybe someone knows this already.
I have read that since version 15.0, it's possible to go from a TPT script directly into HDFS. Righ... |
59432 | 25 Aug 2016 @ 11:09 PDT | teradatauser2 | Database | Reply | When to use Join Index | Hi,
Different JI has different use. If you have a table and you want to join to another table on some other column (than current PI), then you should create a Single table JI on the column you joi... |
59431 | 25 Aug 2016 @ 09:50 PDT | dnoeth | Database | Reply | Case statement syntax change? | There's no YEAR or MONTH function in Teradata, this is (deprecated) ODBC-syntax, which might be automatically replaced with valid SQL by the ODBC driver. In older releases of SQL Assistant... |
59430 | 25 Aug 2016 @ 09:38 PDT | siddarthy | Database | Reply | Best way to generate the Sequential numbers : CSUM or IDENTITY columns? | Also do use ASC or DESC with the ORDER BY ;)
|
59429 | 25 Aug 2016 @ 09:32 PDT | agnit.chatterjee1988 | Database | Reply | When to use Join Index | Can anyone please help?
|
59428 | 25 Aug 2016 @ 07:49 PDT | cqhollon | Database | Topic | Case statement syntax change? | I recently upgraded to Teradata SQL assistant v15.10 and teh database is version 14.00. All of a sudden I get a syntax error on this statement
the error is Failed 3706 Syntax error: expected... |
59427 | 25 Aug 2016 @ 07:22 PDT | JonManGo42 | Tools | Reply | Teradata 14.10 History Window Gone | I have the same problem with SQLA 15.0. I have had access to the History window for as long as I have had SQLA installed. The other day, I closed the History window, and "Show History" is... |
59426 | 25 Aug 2016 @ 06:07 PDT | anil_athalye | Database | Reply | ALTER TABLE on UNICODE character type issue | Thanks,
It worked when I included all the attributes/constraints in the ALTER Table statement.
Ani.
|
59425 | 25 Aug 2016 @ 04:03 PDT | juanalfonso | Database | Reply | Problems installing in TDExpress15.00.02_Sles11_40GB | Thanks!
I downloaded and installed the Teradata Express 15.10 VM and It seems to be possible to install SAP DS here :)
But on the other hand, I've fount that UltraVNC (to make a remote deskto... |
59424 | 25 Aug 2016 @ 03:12 PDT | bhushan.koli | Connectivity | Topic | Teradata performance mointoring for each querry Jmeter testplan | Hi,
I am connecting teradata db (located on remote location) from my local machin through
jmeter 3.0 ,and my testplan contains 20 querries and i want to measure performance (cpu,memory)
fo... |
59423 | 25 Aug 2016 @ 02:01 PDT | Ghalia | Tools | Reply | Zero records are fetching when using where statement in TPT | Hi,
After using LOCK TABLE MY_TABLE EXCLUSIVE
I have an update request
Then , I want to add something like RELASE LOCK from MY_TABLE after the update, in case of fail.
Is it possible... |
59422 | 25 Aug 2016 @ 12:13 PDT | krishna1985 | Tools | Topic | MULTILOAD BUFFER ERROR!!! urgent | Hi All,
I am trying to load the 8 mil rows into the target table and when I try to insert into target table then I get the below issue
* 16:46:18 UTY1802 Processing Import Sequ... |
59421 | 24 Aug 2016 @ 11:33 PDT | G787010 | General | Reply | interview help | Hi,
Could you please share the questions related to FSLDM?
Thanks in Advance,
Suwarna S
Mail:swarna.apr13@gmail.com
|
59420 | 24 Aug 2016 @ 10:03 PDT | kamlesh114 | Database | Reply | PPI | CREATE MULTISET TABLE SUPPORTDB.TABLE1
(EMPNO INT,E_NAME VARCHAR(100),JOIN_DATE DATE )
UNIQUE PRIMARY INDEX (EMPNO)
PARTITION BY RANGE_N (JOIN_DATE BETWEEN '2015-01-01' AND ... |
59419 | 24 Aug 2016 @ 06:36 PDT | jasonmoore2k | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | I can see why it would be important to preserve existing behaviour, and I think the approach of using a connection parameter as you've described would work well.
|
59418 | 24 Aug 2016 @ 02:17 PDT | dnoeth | Database | Reply | ODBC TimeStamp | See if this works.
On a session level set the timezone to your local daylight saving timezone:
SET TIME ZONE 'America Brazil';
and then remove the '-00:00' and cast like this... |