#DateForumTypeThreadPost
92115 Sep 2014 @ 02:58 PDTGeneralReplyEXECUTING PROCEDURE BY a USER OTHER THAN THE CREATORThis link will help: https://forums.teradata.com/forum/database/execute-access-for-procedure
92015 Sep 2014 @ 12:39 PDTTeradata ApplicationsReplyQuestions on Inside AMPFSG cache stores the most recently used database segments. When Teradata Database needs to read a data block, it checks and reads from cache instead of from disk, whenever possible.FSG purges least...
91913 Sep 2014 @ 08:54 PDTGeneralReplyImporting data in data mode is failing in BTEQRules for all Platforms • The  o nl y  a c c e pt a bl e  d a t a  t y pe s  f or  VARTEXT r e c or ds  a r e  VARCHAR,  VARBYTE,  a nd ...
91813 Sep 2014 @ 12:22 PDTDatabaseReplyCollect statsIf you can provide more details, then it will be easy, reasons, what is there in intermediate etc.. etc... You can refer to the link http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#p...
91712 Sep 2014 @ 11:56 PDTTrainingReplyCerfication Suggestion PlsLet me see if I can suggest you. It seems you are asking about certification: you can refer to this link: http://in.teradata.com/teradata-certified-professional-program/?LangType=16393&Lang...
91612 Sep 2014 @ 08:58 PDTToolsReplyFastload to non-empty tableI am not sudhansu :), let me just give the link: http://www.info.teradata.com/edownload.cfm?itemid=140840008
91512 Sep 2014 @ 08:55 PDTDatabaseReplyDynamic partition eliminationFrom TD docs: Dynamic row partition elimination (DPE) is a form of partition elimination that cannot occur until data values in the tables are known in order to eliminate partitions: Teradata Data...
91412 Sep 2014 @ 06:34 PDTToolsReplyQuery not working in Teradata SQL Assistant with Teradata .Net while the same query is working with ODBC connection & vice versaIt is always good to check the readme documents of  ODBCs..., like in http://downloads.teradata.com/download/connectivity/ http://downloads.teradata.com/download/connectivity/odbc-driver/wind...
91312 Sep 2014 @ 04:51 PDTDatabaseReplyPass single quote as parameter in stored procedureMaybe you can try something like this previous post? https://forums.teradata.com/forum/database/how-to-parametrize-where-in-clause-in-stored-procedure  
91212 Sep 2014 @ 04:38 PDTDatabaseReplyCAST and SUBSTR can be applied on the same column at a time in the same queryYou can check your output and see if this is what you want. To avoid confusion ,maybe you can show what you have as input and what you want as output. This is just one way I feel, to interpret bet...
91112 Sep 2014 @ 01:46 PDTTeradata ApplicationsReplyQuestions on Inside AMPToo many questions :) You can have a look at this link : http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/appc.038.79.html There are some mor...
91012 Sep 2014 @ 01:08 PDTGeneralReplyOracle Data used as Input for BTEQDid you try with .logon 127.0.0.1/dbc and password dbc?
90912 Sep 2014 @ 01:03 PDTDatabaseReplyQuery IssueIf the requirement drives for it and you get what is required and there is no performance issue, then good. TO_CHAR is oracle function. I am confused here, are you learning oracle here in Teradata...
90811 Sep 2014 @ 10:34 PDTConnectivityReplyMS Visio 2010Strange!!!! even after  refreshing too or restarting your MS Visio? Maybe you contact MS visio support too.
90711 Sep 2014 @ 08:49 PDTDatabaseReplyQuery IssueYou put comas in case when. I use to_char too for date conv. SELECT EMPNO, ENAME, CAST(JOB ||'_'|| MGR AS VARCHAR2(50)), TO_CHAR(HIREDATE,'YYYY-MM-DD') AS JDATE, CAS...
90611 Sep 2014 @ 08:29 PDTGeneralReplySELECT 'D_TABLE' as TABLENAMEIt is not a dumb question. It is a very good question. You will learn more by practicing and implementing. Keep learning. Cheers,
90511 Sep 2014 @ 08:06 PDTDatabaseReplyConvert string to dateyou can use: select cast(cast('20130421' as date format 'yyyymmdd') as date format 'yyyy-mm-dd');  
90411 Sep 2014 @ 01:49 PDTDatabaseReplycopying table from Prod to QAYou can use : INSERT INTO your_databasename_QA.A SELECT * FROM your_databasename_PROD.B; I give your_databasename_QA and  your_databasename_PROD as example only. You can also think of ...
90311 Sep 2014 @ 01:09 PDTDatabaseReplycopying table from Prod to QAI suggest you talk to the DBA --- if you can just do an insert ...select or how much data you want ...and when you can do .... not to disturb the production system.
90211 Sep 2014 @ 01:00 PDTConnectivityReplyMS Visio 2010I am not a MS Visio expert :). Let me just try to pitch in. What do see in your ODBC Data Source Administrator , when you click on "Add" . Is Teradata in the list , that means for other a...
90111 Sep 2014 @ 12:41 PDTDatabaseReplycopying table from Prod to QADo you have tpt, or can you see tpt wizard?
90011 Sep 2014 @ 12:30 PDTGeneralReplySELECT 'D_TABLE' as TABLENAMEFrom the context, it means that an aliased field name TABLENAME will have a value 'D_TABLE'. Why don't you execute the query and see the result in sql assistant or bteq?
89911 Sep 2014 @ 12:18 PDTDatabaseReplyNumber of tablesWe build  a warehouse for business purpose.   I suggest you go through this document, in brief.It is brief and to the point. What do you want , dimensional or 3 NF? http://assets.terad...
89809 Sep 2014 @ 08:57 PDTGeneralReplyBTEQ export through shell scriptYou can also think of doing thus if casting to varchar is too big--- if it is convenient--- if it does not produce redundant data SELECT         'FILENAME'||'=...
89709 Sep 2014 @ 09:52 PDTDatabaseReplyCHECKSUM TABLE VALUEHandle with care when you go for dbscontrol. Once you are in dbscontrol, type HELP checksum. You can see the settings there. Type QUIT to come out. Are yout authorized to make changes? eg: m...

Pages