Bill, Not quite sure how you would do that from a macro. But you can re-execute data loads from within Studio. After completing a data load (Data Transfer), an entry is placed in the Transfer History View. You can select the entry and press the ReExecute button. It will bring up the dialog and give you the option to replace or append the data.
Good article Thanks fgrimmer! We recently switched some of our business users from SQL assistant to Teradata Studio and I gave a demo to these users last week I got questions from users and I was not sure these features in Teradata Studio can you please answer these:
Please update on this. Thank you.
Ashwin, 1) No, not from a result set. You can filter the data when exporting from a table. 2) We are working on providing this feature now. It will be available in our next release.
Our users are facing issue while executing Stored Procedure from Teradata studio here is error:
Failed [5510 : HY000] Invalid session mode for procedure execution.
Elapsed time = 00:00:00.000
My Question : Every time we need to change this Mode or Can we save couple of modes in properties? since user run variety of SQL's may have in different mode so changing the mode every time is hard right.
Please suggest on this.
Also Forget to mention:
Some of our users are highly experiencing stability / system freeze issues which make running queries very slow for them. This is on Windows XP OS.
What could be the issue and how can we resolve please suggest.
Ashwin, The error message 'Failed [5510 : HY000] Invalid session mode for procedure execution.' occurs because "the session mode within which the CALL SQL is submitted is different than the one in which the stored procedure was created. A stored procedure created in ANSI mode cannot be executed in Teradata mode and vice versa." You could have a separate connection profile with the session mode set differently for executing the stored procedure. But a connection profile can only have one TMODE property setting.
Can you provide more information about the system freeze issue? We have fixed some issues with canceling long running queries in our recent release.
The users are experiencing very long time to connect TD and loading schemas.
While expanding the schemas on left panel under Data Source Explorer when you click on SCHEMAS immediately getting freeze and taking long to get back from freeze.
Please suggest on this.
Appreciate your quick Response.