State the first_defined function with an example?

Answer Posted / hamshapriya

This function is similar to the function NVL() in Oracle database

- It performs the first values which are not null among other values available in the function and assigns to the variable

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Within a cursor, how would you update fields on the row just fetched?

865


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

879


What is a local lookup?

965


What is the difference between a scan component and a rollup component?

921


What is the role of co-operating system in abinitio?

1188


Give one reason when you need to consider multiple data processing?

915


What are the six data process products of ab initio (architecture of ab initio)?

910


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2417


Tell us about the architecture of abinitio.

900


How you can run a graph infinitely in ab initio?

1165


What is ab initio enterprise meta>environment (eme)?

1227


What is the use of the co> operating system in ab initio?

860


Why might the optimizer use a table scan when an index is available?

2077


How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4184


What information does a .dbc file extension provides to connect to the database?

983