What is the Difference Between Macro and Procedure

The main difference between Macro and Procedure is that a macro is used for a small number of instructions; mostly, less than ten instructions, while the procedure is used for a large number of instructions; mostly, higher than ten instructions.

1. What is the difference between macro and procedure in Teradata?
2. What are macro definitions?
3. What is difference between near and far procedure?
4. What is a procedure in assembly language?
5. What are macros in Teradata?
6. How do I create a stored procedure in Teradata?
7. What is macro explain with example?
8. What is the use of macro?
9. What are macro images?
10. What are the call and ret instructions and explain how they work?
11. What is a near procedure call in 8086 assembly language?
12. What are assembler directives in 8086?

What is the difference between macro and procedure in Teradata?

The macro contains only SQL and maybe dot commands that are only for use in BTEQ. ... A stored procedure does not return rows to the user like a macro. Instead, the selected column or columns must be used within the procedure. A stored procedure contains SQL to access data from within Teradata.

What are macro definitions?

A macro (which stands for "macroinstruction") is a programmable pattern which translates a certain sequence of input into a preset sequence of output. Macros can make tasks less repetitive by representing a complicated sequence of keystrokes, mouse movements, commands, or other types of input.

What is difference between near and far procedure?

A near call refers a procedure which is in the same code segment. A Far call refers a procedure which is in different code segment It is also called Intra-segment call. It is also called Inter-segment call A Near Call replaces the old IP with new IP A FAR replaces CS & IP with new CS & IP.

What is a procedure in assembly language?

Procedures or subroutines are very important in assembly language, as the assembly language programs tend to be large in size. Procedures are identified by a name. Following this name, the body of the procedure is described which performs a well-defined job.

What are macros in Teradata?

Macro is a set of SQL statements which are stored and executed by calling the Macro name. The definition of Macros is stored in Data Dictionary. ... Macro statements are executed as a single transaction. If one of the SQL statements in Macro fails, then all the statements are rolled back. Macros can accept parameters.

How do I create a stored procedure in Teradata?

Teradata stored procedure is created from the following commands: BTEQ utility using the COMPILE command.
...
Following is the syntax of the CREATE PROCEDURE statement.

1. CREATE PROCEDURE <procedurename> ( [parameter 1 data type, parameter 2 data type..] )
2. BEGIN.
3. <SQL or SPL statements>;
4. END;

What is macro explain with example?

Macro is defined as something that covers a large amount, or is large in size. An example of macro is the study of the key driving aspects of an economy; macro economics. An example of macro is a very close up photograph of an ant; a macro photograph.

What is the use of macro?

A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.

What are macro images?

By the original definition, a macro photograph is one in which the size of the subject on the negative or image sensor is life size or greater. ... In the digital age, a "true" macro photograph can be more practically defined as a photograph with a vertical subject height of 24 mm or less.

What are the call and ret instructions and explain how they work?

Two instructions control the use of assembly-language procedures: CALL pushes the return address onto the stack and transfers control to a procedure. RET pops the return address off the stack and returns control to that location.

What is a near procedure call in 8086 assembly language?

Near Call -- Procedure Call (call)

The call instruction calls near procedures using a full pointer. ... The offset of the instruction following the call instruction is pushed onto the stack. After the procedure completes, the offset is popped by a near ret instruction within the procedure.

What are assembler directives in 8086?

An assembler supports directives to define data, to organise segments to control procedure, to define macros. It consists of two types of statements: instructions and directives. The instructions are translated to the machine code by the assembler whereas directives are not translated to the machine codes.