#DateForumTypeThreadPost
1706 Feb 2013 @ 04:11 PSTDatabaseTopicInvalid Timestamp  Goodnight   I have a problem doing a CAST in this query to execute, get the error invalid timestamp.   SELECT (CAST( (CAST(TRIM(Stg.Fecha_Ejecucion_OOSS) AS...
1612 Sep 2012 @ 11:27 PDTDatabaseReply3810: Column / Parameter 'EDW_STAGE.F4.CLIENTE_ID' does not exist The problem really if it was the name of the field if it was incorrect, the correct name was party_id and customer_id, this can be given by post solved.
1512 Sep 2012 @ 09:29 PDTDatabaseTopic3810: Column / Parameter 'EDW_STAGE.F4.CLIENTE_ID' does not exist Trying to run this query I get the customer_id column does not exist and still do not understand why they should join me to bring the data for this column. Thank you in advance for your att...
1406 Sep 2012 @ 12:47 PDTDatabaseTopic2616: Numeric overflow occurred During computation Running the "Insert - Select" I get the following error message "2616: Numeric overflow occurred During computation.", But if you just run the "Select" does indepen...
1309 Aug 2012 @ 12:21 PDTDatabaseTopicConcatenate the last day of the month to a date. Good Afternoon, My question is this what I want to do is to a date depending on the month to add the last day of the month. For example I get: 201001 and it looks like this 20100131 ...
1209 Jul 2012 @ 08:27 PDTDatabaseReplyError Code 6706: The string contains an untranslatable character. Yes, thanks indeed that was the problem the temporary table was the Unicode character set, but the table would be fine where the data was the latin character set, changing the character of the t...
1109 Jul 2012 @ 06:28 PDTDatabaseTopicError Code 6706: The string contains an untranslatable character. Greetings, running this query I get the error message. Error Code 6706: The string contains an untranslatable character. I find it very strange and really had not seen him, if I could give an in...
1005 Jul 2012 @ 07:20 PDTDatabaseTopiccalculate the size of a table in teradata My question is as calculating the weight that can occupy a table in the database knowing that will add about 120 million records in a table, the insert will be done through the Multiload. What I...
926 Jun 2012 @ 11:34 PDTDatabaseReplyCursors in teradata Thanks again for your answers.
826 Jun 2012 @ 11:33 PDTDatabaseReply¿Alternatives to increase the performance of this query? Thank you for your invaluable help, the problem was resolved by reviewing the structure of the temporary table TEMP BD_STAGING.PE719_AGHPRO where it was found that the primary key this was poorl...
725 Jun 2012 @ 01:20 PDTDatabaseTopicError creating a JOIN INDEX 5464: Error en JOIN INDEX DLL, Cannot create this index over a view. I could indicate the correct way to create them.
625 Jun 2012 @ 11:39 PDTDatabaseReply¿Alternatives to increase the performance of this query? Back and collect the statistics and run the Explain and showed me the same result, then run the query to see if there was increased execution speed of the consultation and continues with the sam...
525 Jun 2012 @ 09:40 PDTDatabaseReply¿Alternatives to increase the performance of this query? Thanks dieter, this is the result shows me explain.  1) First, we lock EDW_ODS.IPS_CARACTERISTICA in view      MDB_CONSULTAS.VC_PROGRAMA_PP for access, we lock EDW...
425 Jun 2012 @ 09:31 PDTDatabaseReplyCursors in teradata I need to improve the performance of query execution where a table of about 5000 records matches them to another table of three million records, the problem is that each record in the table of 5...
325 Jun 2012 @ 08:59 PDTDatabaseTopicCursors in teradata Good morning, Who can tell me as the creation and use of a cursor in teradata, if possible as I do.
225 Jun 2012 @ 07:41 PDTDatabaseReply¿Alternatives to increase the performance of this query? Excuse me, maybe I was not very clear on what I wanted to explain and what the query. This first LEFT JOIN What it does is compare the type of document the patient in the temporary tab...
122 Jun 2012 @ 02:44 PDTDatabaseTopic¿Alternatives to increase the performance of this query? Hello, I have several questions about the delay in execution of this query. As you can increase the performance of my query. Right now I have a query that do join with multiple tables ...