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.

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;

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

0 Answers  

---

How to get DML using Utilities in UNIX?

1 Answers  

---

What are the steps to create a repository in ab initio?

0 Answers  

---

What is regex (lookup)? When you should use it? How to use in abinitio graph?

1 Answers   Steria, Wipro,

---

What is common among data validity and data integrity?

0 Answers  

---

What do you mean by a transaction file?

0 Answers  

---

Difference between public and private projects and how to make private to public?

1 Answers  

---

What is the function that transfers a string into a decimal?

0 Answers  

---

I wanted to learn Ab Initio, Could you please send the material to my personal email id.

2 Answers  

---

How can you connect eme to abinitio server?

1 Answers  

---

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

0 Answers  

---

How do you add default rules in the transformer?

0 Answers  

---