Archives of the TeradataForum

Message Posted: Mon, 14 Nov 2005 @ 18:54:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

All,

Outside of using Stored Procedures for DBA Administrative tasks (such as setting up users), we mostly use stored procedures for our front-end maintenance\mappings appliations. For instance, in a multi-screen process, our users will choose a record and map it to another one or more other records. The stored procedure call made by the front end application consists of 4 parameters (Action_Ind describing the Action (i.e., map or unmap), PK of the object to be mapped, PK of the object(s) something is being mapped to (elements of the key seperated by '|' and PKs seperated by '||'), and an Error Message.) Here is an example of the call:

     Call CBS_ME_VIEWS.BUSINESS_OWNER_DLVRPNT_EDT_OUT
     (
     'E',
     '700023803|36514|03/04/2005|103349',
     '0000000000001|70|U||0000000000002|10|U||0000000000002|70|U||00000000000
     02|100|U||0000000000003|10|U||0000000000003|70|U||0000000000003|100|U||0
     000000000004|10|U||0000000000004|70|U||0000000000004|100|U||000000000000
     5|10|U||0000000000005|70|U||0000000000005|100|U||0000000000006|10|U||000
     0000000006|70|U||0000000000006|100|U||0000000000007|10|U||0000000000007|
     70|U||0000000000007|100|U||0000000000008|10|U||0000000000008|70|U||00000
     00000008|100|U||0000000000009|10|U||0000000000009|70|U||0000000000009|10
     0|U||0000000000010|70|U||0000000000010|100|U||0000000000011|10|U||000000
     0000011|70|U||0000000000011|100|U||0000000000012|10|U||0000000000012|70|
     U||0000000000012|100|U||0000000000013|10|U||0000000000013|70|U||',

     Error_Message
     );

Via a stored procedure, we are able to parse this information into different Global Temp tables. We then join these Global temp tables to our reporting tables to determine whether the mapping/unmappings should insert or update our processing tables. To date, we are extremely pleased with Teradata's stored procedures and the progress Teradata has made over these last couple of releases.

My 2 cents regarding the benefit of Teradata Stored Procedures,

Clay

	<Prev	Next>		<<First	<Prev	Next>	Last>>