Re: Database What the ...

Jon,

you mean there is not a 01, 02, 03, ... in the resulting set of rows? I
can see the resulting sequence numbers not matching the lastname, firstname
order by, since the input rows are not in lastname order. Odd that ACS
would have any affect on the running of an SQL statement.




On Sun, Sep 30, 2018 at 11:29 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

I have been using this SQL set to generate a list of Ids for several years
now. It has always worked with no issues.

Today when run in Run SQL scripts instead of producing sequence numbers in
the range 01 to (number of rows in the result set) it is producing a crazy
range of numbers.

No OS upgrade, no database PTFs applied that I can think of since the last
time this ran correctly.

Anyone got any ideas on what could be causing this?

set schema = siddbv2;

drop sequence team_number;

create sequence team_number as int start
with 1 increment by 1;

select trim(firstname) || ' ' ||
trim(lastname) as name, 'SQLINTRO' || right( '0' || varchar( next
value for team_number ), 2) as Team
from siddbv2.alumni a
inner join siddbv2.attendee b on a.regid = b.regid
where event = '1810SM' and
(atworkshp1 = 'WKS29' or atworkshp2 = 'WKS29') and
regType not in ('X', 'Z')
order by lastname, firstname;


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD