Re: Database What the ...

Yup - the sequence numbers were apparently arbitrary and does indeed have an effect running in ACS with "Save results" compared with running anywhere else.

IBM have confirmed there is an issue. It apparently has something to do with them changing the type of cursor being used when you say you want the ability to save results.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Sep 30, 2018, at 5:32 PM, Steve Richter <stephenrichter@xxxxxxxxx> wrote:

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

--
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