Subject | Use of BEGIN/END in sql scripts |
---|---|
Author | Andrea Raimondi |
Post date | 2013-02-24T18:55:32Z |
Hello!
For a number of reasons, I do not want to use a stored procedure for this.
What I need to do is a sort of generator on steroids, with a very high
power function result. Thus my code ought to be something like SELECT
GEN_ID(GEN_MY_GEN)+POWER(2,32)*MYFIELD
FROM....
I am at all not sure I can call gen_id that way though, thus probably my
best bet is to use a begin/end pair and perform the calculation outside the
select. Do you know if I can do that? Otherwise, what is the best way to do
it? Can I call gen_id in a select?
Thanks
A
[Non-text portions of this message have been removed]
For a number of reasons, I do not want to use a stored procedure for this.
What I need to do is a sort of generator on steroids, with a very high
power function result. Thus my code ought to be something like SELECT
GEN_ID(GEN_MY_GEN)+POWER(2,32)*MYFIELD
FROM....
I am at all not sure I can call gen_id that way though, thus probably my
best bet is to use a begin/end pair and perform the calculation outside the
select. Do you know if I can do that? Otherwise, what is the best way to do
it? Can I call gen_id in a select?
Thanks
A
[Non-text portions of this message have been removed]