How can the DML for Excel file will be generated ?
- Using excel-gendml.ksh located in the $AB_HOME/bin
- Using excel_gendml.ksh located in the $AB_HOME/bin
- Using gendml.ksh located in the $AB_HOME/bin
-
All of the above
The excel-gendml.ksh script located in $AB_HOME/bin is used to generate DML (Data Manipulation Language) for Excel files in Ab Initio. This utility parses the Excel structure and creates corresponding DML definitions. The other options have incorrect script names.
To generate the DML (Data Manipulation Language) for an Excel file, you can use the "excel-gendml.ksh" script located in the "$AB_HOME/bin" directory.
Option A) Using excel-gendml.ksh located in the $AB_HOME/bin - This option is correct because it specifies the correct script name and location to generate the DML for an Excel file.
Option B) Using excel_gendml.ksh located in the $AB_HOME/bin - This option is incorrect because it specifies an incorrect script name ("excel_gendml.ksh" instead of "excel-gendml.ksh") to generate the DML.
Option C) Using gendml.ksh located in the $AB_HOME/bin - This option is incorrect because it specifies an incorrect script name ("gendml.ksh" instead of "excel-gendml.ksh") to generate the DML for an Excel file.
Option D) All of the above - This option is incorrect because only option A is correct. Options B and C specify incorrect script names to generate the DML for an Excel file.
Therefore, the correct answer is A) Using excel-gendml.ksh located in the $AB_HOME/bin.