Error 3654 In Teradata
Posted: Thu, 21 May 2009 @ 21:58:09 GMT
baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Teradata : Product Forums : General : Problem with procedure compiling Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page slekkala Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-12-2013 11:16 AM 09-12-2013 11:16 AM Problem with http://teradataforum.com/teradata/20090521_215809.htm procedure compiling Any one please help me, INSERT INTO Q_SCM_VW.supplier_performance_work ( date_key, supplier_key, plant_key, buyer_key, part_key, active_status, shipments, value_shipped, quantity_shipped, scheduled_shipments, delivery_failures, quality_failures, administrative_failures, quantity_defective, amount_spent, http://community.teradata.com/t5/General/Problem-with-procedure-compiling/td-p/43237 value_defective, notes_supplier_id, notes_facility_id, the_date, part_number, SYSTEM ) SELECT 0 AS date_key, 0 AS supplier_key, 0 AS plant_key, 0 AS buyer_key, 0 AS part_key, active_status, SUM(shipments) AS shipments, SUM(value_shipped) AS value_shipped, SUM(quantity_shipped) AS quantity_shipped, SUM(scheduled_shipments) AS scheduled_shipments, SUM(delivery_failures) AS delivery_failures, SUM(quality_failures) AS quality_failures, SUM(administrative_failures) AS administrative_failures, SUM(quantity_defective) AS quantity_defective, SUM(amount_spent) AS amount_spent, SUM(value_defective) AS value_defective, notes_supplier_id, notes_facility_id, the_date, part_number, SYSTEM FROM (SELECT notes_supplier_id, notes_facility_id, ADD_MONTHS(datetime_received- (EXTRACT(DAY FROM datetime_received) -1 ), 1) -1 AS the_date, part_number, COALESCE(active_status,'Active') AS active_status, CAST(1 AS DECIMAL(20,6)) AS shipments, value_received AS value_
expressions are incompatible. Teradata code 3654 Corresponding select-list expressions are http://teradataerror.com/3654-Corresponding-select-list-expressions-are-incompatible.html incompatible. Error description error explanation... Explanation: If a query contains a UNION, MINUS, or INTERSECT operator, then the data types for all select-list expressions must be compatible with the corresponding expression in the select-list for the first SELECT in the query. All numeric data error 3654 types are considered compatible. Character data types are not compatible with numeric data types. Byte data types are only compatible with byte data types. Graphic data types are only compatible with graphic data types. Generated By: OPT modules. For Whom: End User. Remedy: Correct error 3654 in the statement and resubmit the request.
More information Teradata error 5695 ’%VSTR’ is not a global temporary trace table. Teradata error TPT3590 Error: in PERIOD datatype. Length specified must be a value between 0-6. Teradata error TDP0603 SESSION number FORCED OFF BY TERADATA DATABASE PM/PC Teradata error 9541 Diagnostic REWRITEQRY that returns rewritten text is applied on this query. Teradata error TDP0902 TDP USER SECURITY EXIT INTERFACE DISABLED Teradata error TPT13107 Error %d retrieving DML statement for DML group: %d Teradata error The job is terminated. Teradata error 5338 More than 1,000 volatile tables in current session. Teradata error The %s column no longer exists in the selected %s. Teradata error 9542 A security constraint with the name %VSTR already exists. Error category errors 36* Teradata Database Errors