Creating a csv Report

Use the code as a frame work and do your own enhancements for creating a simple csv report.

&NewDirectory = " C:\temp\folder ";

CreateDirectory(&NewDirectory, %FilePath_Absolute);

& file = GetFile("C:\temp\folder\reportname.csv", "W", %FilePath_Absolute);

& file.WriteLine(",,,Heading of the File);

& file.WriteLine("");

&file.WriteLine(" File titles separated by commas");

Sql=Create sql();

While sql.fetch()

&file.WriteLine(Pass the variable container in a loop in case of multiple rows);

End-while;