Thanks Rob;
I believe we tried CRTSQLPKG on the program after it was promoted to production, no joy, but that was a year ago so I could be wrong.
We are going to attempt to recreate the problem now that we have the time to do a full investigation.
Duane Christen
--
Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx
Visit PAETEC.COM
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, February 02, 2010 9:07 AM
To: Midrange Systems Technical Discussion
Subject: RE: IDENTITY_VAL_LOCAL
Has something to do with "SQL package". It's an interesting challenge for change management software. On some systems we had to go to the target system and run CRTSQLPKG. You might have to stick that in your form.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Christen, Duane" <Duane.Christen@xxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/02/2010 10:00 AM
Subject: RE: IDENTITY_VAL_LOCAL
Sent by: midrange-l-bounces@xxxxxxxxxxxx
FYI:
I had a problem with the "select from final table" statement soon after we
went to 6.1, December 2008. It worked fine on the dev box and if we
manually SAVRSTed the program object to the production box it would work
correctly. But when Turnover did the promotion (SAVRSTed the program
object) it would fail looking for the development library it was created
in, as I remember. Our System i DBA (yes we have one) was dealing with
other problems at the time and I could work around the problem by using
the previous syntax so he didn't peruse the issue.
Reading this thread reminded me and our DBA and I are now going to
re-investigate the problem and take it up with Turnover/IBM, assuming it
still exists.
Duane Christen
--
Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx
Visit PAETEC.COM
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, February 02, 2010 8:07 AM
To: Midrange Systems Technical Discussion
Subject: Re: IDENTITY_VAL_LOCAL
Study hard Chuck's recommendation of the 6.1 "select from insert". This
is what your developers want.
Rob Berendt
midrange.com
