Hi all,

Its possible to create a java UDF that write some text into an
external file?
DB2 v.9.72
On WindowsXP pro

I want the possibility to write in sql


select MyDebugFunction('C:\test.txt','hello world')
from SYSIBM.sysdummy1

JH

Create UdfZ.java

import java.io.*;

public class UdfZ {

public static String MyDebugFunction (String plik, String tresc){
String ret = "OK";
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(plik));
out.write(tresc);
out.close();
}
catch (IOException e) {
ret = e.getMessage();
}

return ret;
}

public static String MyDebugFunctionAppend (String plik, String
tresc){
String ret = "OK";
try
{
BufferedWriter out = new BufferedWriter(new
FileWriter(plik,true));
out.write(tresc);
out.close();
}
catch (IOException e) {
ret = e.getMessage();
}

return ret;
}

}


compile it and copy class file into $DB2/sqllib/function directory
then call sql

CREATE FUNCTION MyDebugFunctionAppend(VARCHAR(100),VARCHAR(100))
RETURNS VARCHAR(100)
EXTERNAL NAME 'UdfZ!MyDebugFunctionAppend'
LANGUAGE JAVA
PARAMETER STYLE JAVA
DETERMINISTIC
FENCED
CALLED ON NULL INPUT
NO SQL
NO EXTERNAL ACTION

CREATE FUNCTION MyDebugFunctionAppend(VARCHAR(100),VARCHAR(100))
RETURNS VARCHAR(100)
EXTERNAL NAME 'UdfZ!MyDebugFunctionAppend'
LANGUAGE JAVA
PARAMETER STYLE JAVA
DETERMINISTIC
FENCED
CALLED ON NULL INPUT
NO SQL
NO EXTERNAL ACTION


select MyDebugFunctionAppend('d:\out.txt','test1') from
sysibm.sysdummy1

On 9 Nov, 00:16, AD <ada... (AT) gmail (DOT) com> wrote:
Thank you AD!
It works.

The only problem i have is that out.newLine() doesn't work.
Also out.write(s+"\r\n") doesn't work...

I don't know why.

JH

On 11 Lis, 18:22, John Hopfield <Hopfi... (AT) freemail (DOT) it> wrote:
Replace

out.write(tresc);
out.close();

with

out.write(tresc);
out.newLine();
out.close();

it works for me

On 11 Lis, 23:09, AD <ada... (AT) gmail (DOT) com> wrote:
Also check this link
http://www.ibm.com/developerworks/da...0302izuha.html

On 11 Nov, 23:09, AD <ada... (AT) gmail (DOT) com> wrote:
i have added out.newLine() and then recompiled the java class and re-
installed into "FUNCTION" folder.
But...don't works
After a reboot now is OK.

Thank you
JH

On 12 Lis, 09:29, John Hopfield <Hopfi... (AT) freemail (DOT) it> wrote:

After recompiling and copying refreshed class you should call

db2 "CALL SQLJ.REFRESH_CLASSES()"