What is differnce between Error code and Error Level in Bteq
Answer Posted / yuvaevergreen
Error code or return code is a value returned by BTEQ at
the end of each query. Error level is a bteq command used
to assign severity to some error numbers.
.IF ERRORCODE > 0 THEN .GOTO ... is an example for error
code .SET ERRORLEVEL 3807 SEVERITY 0 is an example.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the different functions performed in development phase?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Highlight the points of differences between the database and user in Teradata.
What are aggregate tables? How do you design them using teradata?
How would you load a very large file in teradata in general?
What do you mean by fastexport in teradata?
any one answer me how they can analyzing the project using data ware housing?
During the Display time, how is the sequence generated by Teradata?
Different phases of multiload?
What is upsert statement in teradata?
What is the command in bteq to check for session settings ?
Explain how spool space is used.
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?