Stupid question

nelapsi · #1 (**permalink**) 12-09-04, 05:24

Sorry for stupid question and for my poor english, but how i can to find a sin(5) ?
In postgres i just type 'select sin(5)', but in DB2 it doesnt work :-((

okman · #2 (**permalink**) 12-09-04, 05:30

Try

Code:

select sin(5) from sysibm.sysdummy1

nelapsi · #3 (**permalink**) 12-09-04, 05:39

Quote:

Originally Posted by okman

Try

Code:

select sin(5) from sysibm.sysdummy1

thanks

can you say, how i can select nextval from sequence:?

urquel · #4 (**permalink**) 12-09-04, 09:34

Be aware that the DB2 sine function is the sine of an angle expressed in RADIANS.

bmujeeb · #5 (**permalink**) 12-09-04, 10:49

db2 "values nextval for <sequence_name>"

You can also use

db2 "select nextval for test_seq from sysibm.sysdummy1"

regards

Mujeeb

nelapsi · #6 (**permalink**) 12-10-04, 07:51

Quote:

Originally Posted by okman

Try

Code:

select sin(5) from sysibm.sysdummy1

i've found more simple method :
values(sin(5))
$)

urquel · #7 (**permalink**) 12-10-04, 09:23

Or even more simply -0.95892427466313846889315440615599 and bypass the DBMS altogether.

nelapsi · #8 (**permalink**) 12-10-04, 10:03

How can I get in seconds time elapsed since 1970 year?

n_i · #9 (**permalink**) 12-10-04, 10:16

We've had this discussion before:
http://www.dbforums.com/t1004639.html

nelapsi · #10 (**permalink**) 12-17-04, 13:44

please someone give an example of function (in sql) with "select into" statement....
I newbie in DB2 and I try this

Code:

create function tf() returns integer
language sql
not deterministic
no external action
begin atomic
    declare iii integer default 7;
    select id into iii from tt;
    return iii;
end@

Code:

but I have error :SQL0104N  An unexpected token "iii" was found following ";     select id
into".  Expected tokens may include:  "<space>".  LINE NUMBER=7.
SQLSTATE=42601

ARWinner · #11 (**permalink**) 12-17-04, 14:08

Try:

create function tf() returns integer
language sql
not deterministic
no external action
begin atomic
declare iii integer default 7;
set (iii) = (select id from tt);
return iii;
end@

Andy

nelapsi · #12 (**permalink**) 12-18-04, 05:32

please, smb, give an example of procedure (in sql) with out parameter and with calling of another stored procedures
I've tried this

Code:

CREATE PROCEDURE tp(ss varchar(100), out ret integer)
language sql
begin
    set (ret) = (select id from tt);
    insert into tt1 values(12, ss);
end@

and take an error...
and another question.
can I use an user defined type in pocedures?

nelapsi · #13 (**permalink**) 12-18-04, 07:55

Why this procedure

Code:

CREATE PROCEDURE UTIL.CREATE_USER (u_login varchar(100), pass varchar(100), u_email varchar(100), comm varchar(100), person integer, uuser integer)
LANGUAGE SQL
begin atomic
    declare ret integer;
    select max(id) + 1 into ret from UTIL.Users;
    insert into UTIL.Users values (ret, u_login, pass, u_email, comm, nullif(person,0), 0);
    call util.set_user_right ('UTIL', 'Users', ret, uuser, 31);

end@

generates an error:

Code:

SQL0104N  An unexpected token "''UTIL'', ''Users''" was found following
"til.set_user_right (".  Expected tokens may include:  "<psm_var_list_input>".
LINE NUMBER=9.  SQLSTATE=42601

Internet Services

Web Development

Digital Marketing

Consumer Tech