All forum activity

#DateUserForumTypeThreadPost
5921917 Aug 2016 @ 02:09 PDTlatingntlmanDatabaseTopicDeclaring variables in Terdata SQL AssistantHi, I'm connected to a DB2 datasource thru TD Sql assistant. I'm writing a simple query to pull purchase order header and detail info for a specific PO number as in the example below. Howe...
5921817 Aug 2016 @ 01:26 PDTprateek.bansal07ToolsTopicGetting export results in same date format as in Teradata table using BTEQI am fairly new to Teradata. I have been struggling to get exact format for all the dates in my select query when doing an export using BTEQ.    Here is my script : /opt/teradata/cl...
5921717 Aug 2016 @ 07:38 PDTdnoethDatabaseReplyterdata query.@GTeradata: You probably run an older version of Teradate where you need to add the column list like WITH cte (col1,col2,.., rn, pairs) AS   @Kuldeepg92: There's no way to avoid p...
5921617 Aug 2016 @ 05:52 PDTdnoethTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?There's a link on the download site "how to install and configure Teradata Express for VMware." :-) http://downloads.teradata.com/node/415
5921517 Aug 2016 @ 05:11 PDTkhawar.ameerDatabaseTopicResults differ between query applied on single and query applied on whole branch accountsDear All, Please refer this ACCOUNT_NUM = 680213 BRANCH_PARTY_ID = 12311 Both ACCOUNT_NUM and BRANCH_PARTY_ID are part of EVENT table. Account No 680213 is part of branch 12311 I run followin...
5921417 Aug 2016 @ 04:27 PDTGTeradataDatabaseReplyterdata query. Hi dnoeth/Kuldeep, I have tried with below query its giving me error as below.   Syntax error: expected something between the word 'cte' and the 'AS' keyword. ...
5921317 Aug 2016 @ 03:59 PDTtanmaykuTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?Hey Mr. Vink,   Thanks a lot, I didn't know that, but it worked.  :) I thought that the database credentials must be same as the OS login creds like in Windows.
5921217 Aug 2016 @ 03:54 PDTJohannes VinkTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?The first user on the database is dbc/dbc. Is that what you are looking for?
5921117 Aug 2016 @ 03:47 PDTtanmaykuTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?Hello dnoeth,   Isn't the default userId and password "root" and "root"? I entered the same. Or do I first need to create a database on localhost, using the create D...
5921017 Aug 2016 @ 03:33 PDTmanaswi_patilDatabaseReplySubstitute for "LIKE" in teradata Hi Dieter, The condition given by you using REGEXP_SIMILAR worked for me. I was missing out the '.*' part. i had tried below query which worked for me:   select cas...
5920917 Aug 2016 @ 03:12 PDTdnoethTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageYou do the standard (Suse) Linux way: Computer -> Control Center -> Network Settings -> Edit
5920817 Aug 2016 @ 03:09 PDTdnoethDatabaseReplySubstitute for "LIKE" in teradata Standard SQL LIKE only supports _ & %, using ranges is characters is an extension (e.g. SQL Server).   What did you try? There's no regexp_like in Teradata, but regexp_similar works...
5920717 Aug 2016 @ 03:04 PDTdnoethTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?Well, the error message is self-explaining:  The UserId, Password or Account is invalid.   You used a wrong username or password.
5920617 Aug 2016 @ 02:20 PDTpunitgupta87ConnectivityTopicConnecting to Oracle Teradata ODBC Driver is giving an error while I am trying to access tables afer connecting to oracle database from Teradata SQLAssistant. Error is as :  -------------------------------------...
5920517 Aug 2016 @ 02:00 PDTtanmaykuTeradata StudioTopicHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?I'm a new Teradata user. I just installed Teradata Express VM edtion. When I open Teradata Express Studio, I get the error mentioned above in the title.  Further I get following details r...
5920417 Aug 2016 @ 01:43 PDTStrickersDatabaseReplyConsole user/dbHi Heps, What ever happened to this?   Wreyyyyyyy
5920317 Aug 2016 @ 12:31 PDTloveysaxenaTeradata Database on VMWareTopicHow to change i.p of a TD VM ImageHi All,   I have a TD VM image of version 15 and i have made a copy of this image i.e. if the original image name is x i have made a copy of it as x_copy. I have installed VM Workstation an...
5920217 Aug 2016 @ 12:02 PDTKuldeepg92DatabaseReplyterdata query.show table RX_WK.INSTRUCTOR_COURSE INSTRUCTOR_ID INTEGER, COURSE_ID INTEGER show table RX_WK.STUDENT_COURSE     STUD_ID INTEGER,  COURSE_ID INTEGE...
5920116 Aug 2016 @ 11:28 PDTKuldeepg92DatabaseReplyterdata query.Thank you very much Dieter it is working fine.   Complexity increses within the question . 1.       Group shouldn’t  be of two people having the s...
5920016 Aug 2016 @ 10:54 PDTJohannes VinkDatabaseReplyCreating a snapshot from Type 2 behaviourI remember that the INTERVAL function could be usefull. This prevents a product join to your calendar dimension. We ended up with making the tables physical for maximum performance and to make it e...
5919916 Aug 2016 @ 09:26 PDTFredDatabaseReplySpool space error 2646 collecting statisticsThe obvious answer is raise the spool space limit, or possibly to use sampled statistics. But another thing to check is whether EDW_CHECKSUM1 is a VARCHAR/VARBYTE field that has been defi...
5919816 Aug 2016 @ 09:21 PDTFredDatabaseReplyCopying Macro one DB Server to another DB with changed Internal Tables wrt to the new DB instanceMacros reference database objects by fully-qualified names, not by internal IDs.
5919716 Aug 2016 @ 09:14 PDTFredToolsReplyCasting Date in Bteq utilitiesNot sure I understand your question at this point. Are you saying that you loaded to a staging table as character, and now you want a SQL expression that will CAST the character string to a Timesta...
5919616 Aug 2016 @ 09:01 PDTFredToolsReplyFatal Error with TD TPT APIOn current releases of TD the number of sessions is limited via TASM/TIWM settings. You can't have more instances than sessions, and you can't have more sessions than workload man...
5919516 Aug 2016 @ 07:30 PDTssavoyeToolsReplyTPT - Instances Vs SessionsThanks Steve! It looks like FileReaderMultipleReaders = 'Yes' works.

Pages