Hi all,

I am new to DB2 Programming.

I am required to write an UDF that takes a table name as input parameter and returns sequence number based on production or DR servername.

Questions:

How do I assign a value to a local variable within this UDF?

For Example:

Below is the query to find the server name. This query returns "DFORT001"
How do we store this value in a local variable (v_server) within UDF? What is the syntax?

SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1



SELECT v_server = CURRENT SERVER FROM SYSIBM.SYSDUMMY1; => This gives error
SELECT CURRENT SERVER INTO :v_server FROM SYSIBM.SYSDUMMY1; => This gives error
SELECT CURRENT SERVER INTO v_server FROM SYSIBM.SYSDUMMY1; => This gives error

OR CAN WE DO THIS?

SET v_server = (SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1);

What would be best approach?

Thanks,
Balu

The SET should work.

Andy

You have to find the shortest way, if you are professional programmer:

SET :v_server = CURRENT SERVER;

SET :var_timestamp = CURRENT TIMESTAMP;

Lenny