If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Stored Procedures OUT argument

I have a unix shell script that calls it like this:
db2 "CALL DAY0_PROC(?)";

After this call, in the unix script, I want to capture the OUT value in a variable and echo it (and later write it to a file..). The code as it is, displays a long show of:
Value of output parameters
--------------------------
Parameter Name : V_TS
Parameter Value : 2004-07-14-16.21.26.715864
Return Status = 0

I have tried passing '$variable' and 'variable' in the call - doesnt work. What should I be doing?? Somehow, IBM documentation describes at length the use with C/Java etc. but not with Unix....

On the same note, I am having trouble doing INOUT with Timestamps from Unix. I have a stored proc like this:
CREATE PROCEDURE CONT_PROC (INOUT v_ts TIMESTAMP)

If I make a call like this from a unix script:
db2 "CALL CONT_PROC('2004-05-06 09:02:21.163751')";
the call works fine (apparently, I still cant actually use OUT in its capacity, I am doing the grep way suggested in this thread). But the argument in the CALL needs to be a variable. So the script looks something like this:

read date1 < prop.txt;
db2 "CALL CONT_PROC($date1)";

Surely, this is wrong and I get this error:
SQL0104N An unexpected token "09" was found following "_PROC(2004-05-06". Expected tokens may include: "+". SQLSTATE=42601
SQL3022N An SQL error "-204" occurred while processing the SELECT string in
the Action String parameter.

How do I send a Timestamp type variable into the CALL from the UNIX script??