jmaria
Last Activity: Oct 20 '06, 11:21 AM
Joined: Oct 16 '06
Location:
-
Sorry, thanks, I could execute it ok -
trouble with open cursor in DB2
Hello
Sorry, I don't find a specific forum for DB2, please help me with this. The cursor don't open :-(, I don't know why, any ideas?
I want to update the colum "co_peticio n" from table rem_tempo2 with the respective value from the table peti_imp.
The procedure is:
CREATE PROCEDURE act_copeticion (OUT errorCode INTEGER, OUT errorLabel CHAR(32)
)
RESULT SETS... -
Hello
I need to do a simple sum with two selects in db2, each select is the count's results.
Please, could you give me an idea, how to do this?. I need to have the result with one query only.
I want to get the sum of the two counts, from queries like this:
select count(a) from table1 where b=c + select count(q) from table2 where z=y
I have worked with sybase, not with db2, With...Leave a comment:
-
select 1 + 1
Hola
necesito hacer una simple suma de dos sentencias en db2 con una select, me podéis dar una idea por favor?, he trabajado mas con sybase y con sybase podia hacer por ejemplo: select 1 + 1 , quiero hacer algo parecido db2 pero esto no me funciona
quiero sumar dos sentencias, algo asi:
select count(campo) from tabla1 where condicioncualqu iera +
select count(campo) from tabla2 where condicioncualqu iera.... -
select 1 + 1
Hola
necesito hacer una simple suma de dos resultado en db2 con una select, me podéis dar una idea por favor?, he trabajado mas con sybase y con sybase podia hacer por ejemplo: select 1 + 1 , quiero hacer algo parecido db2 pero esto no me funciona
quiero sumar dos sentencias, algo asi:
select count(campo) from tabla1 where condicioncualqu iera +
select count(campo) from tabla2 where condicioncualqu iera....
No activity results to display
Leave a comment: