You can use the Stored Procedure Browser to see the tables and views that are attached to a stored procedure and to view the code that is used by a particular stored procedure template. You can also attach tables and views in your model to existing stored procedures.
To attach or detach a Teradata table or view to a stored procedure template
The Teradata Procedure Browser opens.
Lists the names of table-level stored procedure templates in the model.
Displays the first line of the stored procedure template, which can include SQL statements and macros.
Lists all tables and views in the model that are not attached to the selected stored procedure template. Use the arrow to attach the selected table or view to the selected stored procedure template.
Lists the tables and views that are attached to the selected stored procedure template. Use the arrow to detach the selected table or view from the selected stored procedure template.
Displays the template code for the selected stored procedure template. You change the code for the stored procedure template in the Stored Procedure dialog.
Displays the expanded code for the selected stored procedure template. Expanded code is the code that will appear in the schema script when the schema is generated.
The Teradata Procedure Browser closes.
Copyright © 2012 CA. All rights reserved. |
|