Hello!
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?
Thanks!

yes
Use Java or C to create a stored procedure

But I want to know a way to read a text file using SQL PL.
Do you know if it´s possible?

No, there are no means in SQL to do that.

Can you give me some example of a java stored procedure that read/write a text file?
Thanks

There are some examples shipped with the DB2 Development Client; they're usually in sqllib/samples.

I didn´t find any example at this directory...
Could you send me some examples?
Do you mind to send it to tessyabs@hotmail.com?
Or paste the examples here if you prefer... please!
Thanks!!

http://publib.boulder.ibm.com/infoce...d/r0007620.htm