Unanswered: read text file with db2 stored procedure
Hello! I know that it´s a Oracle forum but, maybe there is somebody who can help me.
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_file); -> "commit" line
utl_file.fclose(vr_file); -> close file
Is there anyone who know how I can make it?