 |
 |
Archives of the TeradataForum
Message Posted: Tue, 28 Nov 2006 @ 15:36:07 GMT
| Subj: | | Re: Set role is not working with fastload |
| |
| From: | | Geoffrey Rommel |
| | We need to do set role in a fastload process but having error message <invalid set command>. But the same set role command is running
properly on SQLA. | |
SET ROLE is an SQL command. Most SQL commands are not accepted by FastLoad, although it does allow "create table" and a few others.
You could get around this by giving the FastLoad user only one role, or by setting his default role to 'All'.
| |
