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'.