1.

What is Macro and how it can be used?

Answer» Procsql; Connect to Teradata( USER= “ &user_id.” PASSWORD =” &dbpass” tdpid =rchgrp2 MODE= ‘teardata’);

CREATE table work. Account_details as (SELECT Account_ Number, Enroll_ Date, Sales , City  From Master_ acct_ details Where Account_ Number is not null and Sales GT 40000);

Disconnect from Teradata; QUIT;


Discussion

No Comment Found

Related InterviewSolutions