Unanswered: read text file with db2 stored procedure
I want to know if itīs possible to read a text file using a db2 stored procedure?
I konw how to make it using Oracle with the commands:
vr_file := utl_file.fopen('e:\ftp_home\utl_dados', vr_arquivo, 'W'); -> open file
utl_file.get_line(vr_file, vr_linha); -> read line
utl_file.put_line(vr_file, vr_linha); -> insert line
utl_file.fflush(vr_file2); -> "commit" line
utl_file.fclose(vr_file); -> close file
Is there anyone who know how I can make it?