Can we use Host variables in the Update staement?

poongs · New User Joined: 24 Jan 2007 Posts: 28 Location: pune

Hi everybody

Can we move the updated field of the table into the host variables?means directly can we give "into :host-var" clause in teh updte stmt?

guptae · Posted: Tue Apr 03, 2007 6:35 pm

Hi There,

Yes we can directly use host variable as follows

poongs · New User Joined: 24 Jan 2007 Posts: 28 Location: pune

Hi

thnx for the reply....i got an idea on that....but i'm not sure...whether we can use the "into :host-var" clause in the update stmt....an example wud be like the one below:

update date-1

set var1 = var1+1

into :ws-var

where var2 = 2

that is i'm upadating a field in the table as weel as i want to move the updated field into my host variable.is it possible...coz this may avoid another SQL stmt of selecting the updated filed....

thnx in advance.

guptae · Posted: Wed Apr 04, 2007 10:03 am

Hi poongs,

I think it would not work

vini_srcna · Posted: Wed Apr 04, 2007 11:37 am

It violates the Update statement Syntax. It will not work

poongs · New User Joined: 24 Jan 2007 Posts: 28 Location: pune

thnx everybody for clearing my doubt...

dick scherrer · Posted: Thu Apr 05, 2007 2:24 am

Hello,

Another way to think of it might be that we "read" into and we "write" from.