What is the difference between a utility and api in a RUN SQL component

Answer Posted / dinesh

api mode is put a lock on the table whereas Utility doesn't. is it ?

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why might you create a stored procedure with the with recompile option?

644


what is the output when -1 is put in select_expr of FBE?

945


What do you mean by the term data warehousing?

622


How is the partitioning with key different from round robin partition?

668


What is the difference between partitioning with key / hash and round robin?

637






Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

660


Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

629


What is abinitio?

685


What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

706


Explain how you can run a graph infinitely in ab initio?

676


What is data mapping and data modelling?

969


Hi friends, what are the new features in abinito3.0?

2316


How abinitio eme is segregated?

802


What does it mean by the term 'sort component'?

678


What do you mean by a transaction file and how it is different from that of a sort file?

631