All forum activity

#DateUserForumTypeThreadPost
5969407 Sep 2016 @ 06:45 PDTcheese03ConnectivityReplyConnectivity issueHas you been able to resolve this issue? I am getting the exact same error? Even with the permissions on the file set to 0555,0777,4100 and 4100.
5969307 Sep 2016 @ 03:24 PDTfeinholzToolsReplyFastLoad - Data ConversionsFastExport itself cannot export the data and write it out in delimited format. So, I guess you must be CASTing your SELECT statement. Do you have to use SQLAssistant? Have you tried TPT? Can you...
5969207 Sep 2016 @ 02:51 PDT808healthcareDatabaseTopicCollapse one to many into one SQL query result rowI would like to collapse records from a one to many relationship down into a single query result row, a task can have one or two resources assigned (there is no limit on the number of resources tha...
5969107 Sep 2016 @ 02:44 PDTabhishek.jadhavDatabaseReplyCollect Stats with insert statementA third statement for collecting stats is required.
5969007 Sep 2016 @ 02:25 PDTZAtkinsoToolsReplyFastLoad - Data ConversionsSorry to double post but I believe I side stepped your question. The data in the exported file is DATE with FORMAT 'YY/MM/DD'. The table has this same type and format. However, as I underst...
5968907 Sep 2016 @ 02:06 PDTZAtkinsoToolsReplyFastLoad - Data ConversionsHey Steve,  I am exporting the data from the same table. Creating a new empy version of the same table and fastloading the data that was exported from the original table. I am working on a to...
5968807 Sep 2016 @ 01:48 PDTfeinholzToolsReplyFastLoad - Data ConversionsTo which type of data conversions are you referring? The FastLoad script is just loading data. Teradata expects the Date/Time/Timestamp data to be in a very specific format. If the incoming data...
5968707 Sep 2016 @ 01:18 PDTteradatauser2DatabaseReplyFind blocking sessions and tablesThanks Abhishek, it works.
5968607 Sep 2016 @ 12:34 PDTZAtkinsoToolsTopicFastLoad - Data ConversionsHello,  I am having issues performing data conversions specially with dates and timestamps while using fastload. My script is pasted below. All my rows are being imported and sent to error_1 ...
5968507 Sep 2016 @ 12:24 PDTdnoethDatabaseReplyCompute with immediate previous row value derivedYour calculation is similar to  1000 * 1.1 ** (row_number() over (order by Date)-1) To get he start value you might try min(Amount) over () * 1.1 ** (row_number() over (order by Date)...
5968407 Sep 2016 @ 11:16 PDTSGITDatabaseTopicvolatile tables inside the stored procedure Hello,    I have the following two questions please:   1) While creating a volatile talbe inside a stored procedure : it needs to be created first outside the SP a...
5968307 Sep 2016 @ 11:06 PDTPrivate Forum
5968207 Sep 2016 @ 10:39 PDTabhishek.jadhavDatabaseReplyFind blocking sessions and tables You can use following functions to map the ids to names IdentifyTable IdentifyDatabase   dbid=1 is for DBC tid=102 is for AccessRights table
5968107 Sep 2016 @ 10:24 PDTVandeBergBToolsReplyArcmainT@YS = Teradata At Your Service  Somebody in your organization, probably the lead DBA should have an account set up to download all the wonders of TD documentation, hotfixes and new releases...
5968007 Sep 2016 @ 09:51 PDTtomnolanGeneralReplyConverting Unix/EPOCH time to PSTYou said that you wanted to get the "PST date", but time zones are not associated with DATE values. In other words, the Teradata Database does not offer a DATE WITH TIME ZONE data type. ...
5967907 Sep 2016 @ 09:31 PDTabhishek.jadhavDatabaseReplyCompute with immediate previous row value derived Let say your table has first record (2016-11-01, 1000) then you can run the below SQL once everyday which will calculate new Amount and insert it into the same table.   INS into dbn...
5967807 Sep 2016 @ 08:49 PDTarteaga7ToolsReplyArcmainWhat does T@YS mean? Do you have a sample script you use to backup a teradata database instance?
5967707 Sep 2016 @ 08:38 PDTteradatauser2DatabaseReplyFind blocking sessions and tablesCould anyone please help me on this ? --samir
5967607 Sep 2016 @ 07:59 PDTToddAWalterDatabaseReplyTeradata block storageCorrect. The row index list is just a set of offsets from the beginning of the block rather than a pointer but the effect is the same.
5967507 Sep 2016 @ 07:58 PDTdeven_rkDatabaseTopicCompute with immediate previous row value derived Hi All,   I have the below data, wherein I want to compute 'Amount' data dynamically in a 'Select' statement as given below, here I want to refer the previous ro...
5967407 Sep 2016 @ 07:58 PDTdeven_rkDatabaseTopicCompute with immediate previous row value derived Hi All,   I have the below data, wherein I want to compute 'Amount' data dynamically in a 'Select' statement as given below, here I want to refer the previous ro...
5967307 Sep 2016 @ 06:32 PDTchakradhar.challaHadoopTopicHaving an Issue with CHAR,VARCHAR,DATE Data types while exporting/importing from Hive to Teradata using TDCHHello, I am trying to Import/Export Tables from/to Teradata into Hive. But If Hive table has CHAR/VARCHAR/DATE data types, I am getting below error from TDCH Connector INFO tool.ConnectorExpor...
5967207 Sep 2016 @ 05:39 PDTAganediwalDatabaseTopicCollect Stats with insert statementHi all, I am using below two statements to create table and insert some data from an existing table. Is there a way in which stats will be automatically collected after insert statement completes...
5967107 Sep 2016 @ 05:31 PDTGlassToolsReplyArcmainYou can find all TTU downloads at T@YS   Rglass
5967007 Sep 2016 @ 03:23 PDTmikemadrinanGeneralTopicWorking with XMLTABLE, problem extracting data where elements have no prefixes/namespacesI am working on an XML parsing requirement using XML Table.  I am running into a problem with data from elements with no namespaces or prefixes.  Extraction using XMLTable doesn't see...

Pages