What is conditional DML and Structured DML?

Answers were Sorted based on User's Feedback



What is conditional DML and Structured DML?..

Answer / madhugreddy

Strucrured DML is nothing but the normal DML you specify.
Conditional Dml is the one where you write DML based on conditions with IF,IF-ELSE based on the requirement.
most of the times you write structured DML.

Is This Answer Correct ?    16 Yes 0 No

What is conditional DML and Structured DML?..

Answer / keerthika

Structure DML is usually used to read data file that contains records in each with same data format.

Conditional DML using data file will contain cluster of records in each row with different data format, each record can be read using different conditional DML based on the record identifier at the start of each record row

Structure DML Sample :
record
string(5) name;
decimal(10) contact_number;
end;


Conditional DML Sample :

if(record_identifier=='H') then
record
string(5) file_name;
end;
else if(record_identifier=='D') then
record
string(5) name;
decimal(10) contact_number;
end;
else if(record_identifier=='T') then
record
decimal(10) record_count_in_file;
end;

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

What is the default layout of a component ? Is it mandatory to set the layout of a component ?

3 Answers   IBM,


How can we RUN a graph in UNIX?

3 Answers  


how does deadlock occur?

6 Answers   IBM,


What is the Reformat Layout?(i/p ->Reformat->o/p)

2 Answers   IBM,


Layout - L1*, L1 - What is the difference

3 Answers  






Mention what is a partition and what are the different types of partition components in abinitio?

0 Answers  


Have you used the rollup component? Describe how?

0 Answers  


How can a graph be run infinitely?

0 Answers  


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

0 Answers  


What is air_project_parameters and air_sandbox_overrides? what is the relation between them?

1 Answers   IBM,


The methods to improve performance of a graph?

0 Answers  


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

0 Answers  


Categories