------------------------
Paul Stagnoli
Technical Services
Exchange Bank
440 Aviation Blvd
Santa Rosa, CA 95403
Phone: 707-524-3238
Fax : 707-524-3269
------------------------
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
midrange-l-request@xxxxxxxxxxxx
Sent: Friday, February 26, 2010 11:12 AM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 9, Issue 365
Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific than
"Re: Contents of MIDRANGE-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Re: Joining two same tables in different libraries using SQL
(Vern Hamberg)
2. Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT (Steve Richter)
3. Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT (Steve Richter)
4. Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT (Michael Ryan)
5. Re: Joining two same tables in different libraries using SQL
(Alan Shore)
6. Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT (James Perkins)
7. RE: Silverlight and IBM i was : Why i??? NEED YOUR INPUT
(Neill Harper)
8. Re: Silverlight and IBM i was : Why i??? NEED YOUR INPUT
(Lukas Beeler)
9. Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT (Scott Klement)
----------------------------------------------------------------------
message: 1
date: Fri, 26 Feb 2010 11:59:46 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>
subject: Re: Joining two same tables in different libraries using SQL
Dina
Very nice - and I think you can update multiple fields by putting them
in a list separated with commas and in parentheses, and have matching
columns selected in the subselect.
Regards
Vern
dina ramzy wrote:
Dear All,
Dear All,
Thanks a lot for all the helpful replies.
I also found an exact example for what I need to do at this link:
http://search400.techtarget.com/tip/0,289483,sid3_gci1027756_mem1,00.h
tml
Here is a snippet:
"You can easily update a field in one file with SQL by using a field
in another file where unique field matching is possible. In the example,
I want to update all the load dates in FILE1 to contain the same load
date as found in FILE2 matching the two files by company and claim.
COALESCE covers the situation where one field may contain a NULL.
Note that the field to be updated must be compatible with the field
updated from.
UPDATE FILE1 A SET A.LOADDT = (SELECT COALESCE(B.LOADDT, A.LOADDT)
FROM FILE2 B WHERE A.COMP = B.COMP AND A.CLAIM = B.CLAIM)"
Thanks and have a nice week-end
Dina
From: David.FOXWELL@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Date: Fri, 26 Feb 2010 12:57:55 +0100
Subject: RE: Joining two same tables in different libraries using SQL
-----Message d'origine-----
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de dina ramzy
SELECT A.FLD12, B.FLD12 FROM LIB1.TABLE1 A, LIB2.TABLE1 B WHERE
A.KEYFLD1 = B.KEYFLD1 AND
A.KEYFLD2 = B.KEYFLD2
Now I want to update table A and set FLD12 to be the same as the
corresponding one in table B (A.FLD12 = B.FLD12)
Could you please help me in writing this SQL statement.
UPDATE update_table U
SET myfield = (SELECT M.MyField FROM MasterTable M WHERE U.MyKey=
M.MyKey) WHERE U.MyKey IN (SELECT U.MyKey FROM MasterTable M)
And read the valuable lesson from Charles Wilt to myself here :
http://archive.midrange.com/midrange-l/200904/msg00775.html
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
------------------------------
message: 2
date: Fri, 26 Feb 2010 12:59:56 -0500
from: Steve Richter <stephenrichter@xxxxxxxxx>
subject: Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT
On Fri, Feb 26, 2010 at 12:44 PM, James Perkins <jrperkinsjr@xxxxxxxxx>
wrote:
Over what period of time did Microsoft invest billions into OSS? I
don't have any numbers, but I would say IBM spend loads of money on
open source.
James, I did not claim MSFT invests in OSS. I said "... microsoft
invests heavily, over the long term, in their OS, languages,
frameworks, tools. ..."
-Steve
------------------------------
message: 3
date: Fri, 26 Feb 2010 13:02:43 -0500
from: Steve Richter <stephenrichter@xxxxxxxxx>
subject: Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT
On Fri, Feb 26, 2010 at 12:25 PM, Paul Nelson <nelsonp@xxxxxxxxxxxxx>
wrote:
Steve,
Do you lock the doors to your house when you go out? How about your
car doors? Do you leave your Social Security card lying around? Would
you trust a heart surgeon who got his degree through Open Source
University?
Paul,
Linux works great. ( that is what I hear at least. ). 2nd, I think
you are asserting security by obscurity.
------------------------------
message: 4
date: Fri, 26 Feb 2010 13:13:07 -0500
from: Michael Ryan <michaelrtr@xxxxxxxxx>
subject: Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT
Maybe we could move it to
MIDRANGE-justcheckthearchivesforeverypositiononthisissueadinfinitumadnau
seum.
That's not a palindrome.
On Fri, Feb 26, 2010 at 12:56 PM, David Gibbs <david@xxxxxxxxxxxx>
wrote:
Folks:
This topic has been beaten to death in the past ... can we either drop
it or move the discussion over to MIDRANGE-NONTECH (
http://midrange-nontech.l.midrange.com)?
Thanks!
david
--
IBM i on Power -- For when you can't afford to be out of business.
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 5
date: Fri, 26 Feb 2010 13:14:57 -0500
from: Alan Shore <AlanShore@xxxxxxxx>
subject: Re: Joining two same tables in different libraries using SQL
Vern, Dina
That is correct
see the following web page
http://www.itjungle.com/mgo/mgo121203-story02.html
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
Vern Hamberg
<vhamberg@comcast
.net>
To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc
02/26/2010 01:07
Subject
PM Re: Joining two same tables in
different libraries using SQL
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
Dina
Very nice - and I think you can update multiple fields by putting them
in a list separated with commas and in parentheses, and have matching
columns selected in the subselect.
Regards
Vern
dina ramzy wrote:
Dear All,
Dear All,
Thanks a lot for all the helpful replies.
I also found an exact example for what I need to do at this link:
http://search400.techtarget.com/tip/0,289483,sid3_gci1027756_mem1,00.htm
l
Here is a snippet:
"You can easily update a field in one file with SQL by using a field
in
another file where unique field matching is possible. In the example, I
want to update all the load dates in FILE1 to contain the same load date
as found in FILE2 matching the two files by company and claim.
COALESCE covers the situation where one field may contain a NULL.
Note that the field to be updated must be compatible with the field
updated from.
UPDATE FILE1 A SET A.LOADDT = (SELECT COALESCE(B.LOADDT, A.LOADDT)
FROM
FILE2 B WHERE A.COMP = B.COMP AND A.CLAIM = B.CLAIM)"
Thanks and have a nice week-end
Dina
From: David.FOXWELL@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Date: Fri, 26 Feb 2010 12:57:55 +0100
Subject: RE: Joining two same tables in different libraries using SQL
-----Message d'origine-----
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de dina ramzy
SELECT A.FLD12, B.FLD12 FROM LIB1.TABLE1 A, LIB2.TABLE1 B WHERE
A.KEYFLD1 = B.KEYFLD1 AND
A.KEYFLD2 = B.KEYFLD2
Now I want to update table A and set FLD12 to be the same as the
corresponding one in table B (A.FLD12 = B.FLD12)
Could you please help me in writing this SQL statement.
UPDATE update_table U
SET myfield = (SELECT M.MyField FROM MasterTable M WHERE U.MyKey=
M.MyKey) WHERE U.MyKey IN (SELECT U.MyKey FROM MasterTable M)
And read the valuable lesson from Charles Wilt to myself here :
http://archive.midrange.com/midrange-l/200904/msg00775.html
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
--
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:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 6
date: Fri, 26 Feb 2010 10:44:52 -0800
from: James Perkins <jrperkinsjr@xxxxxxxxx>
subject: Re: open source the IBM i kernel. Was: Why i??? NEED YOUR
INPUT
Whoops, sorry about that I misread it. They do invest in their
languages, but for better or for worse, they don't really care about
being backwards compatible either.
Now, for Davids and the rest of the lists sanity, I'll leave it at that.
--
James R. Perkins
On Fri, Feb 26, 2010 at 09:59, Steve Richter <stephenrichter@xxxxxxxxx>
wrote:
On Fri, Feb 26, 2010 at 12:44 PM, James Perkins
<jrperkinsjr@xxxxxxxxx> wrote:
Over what period of time did Microsoft invest billions into OSS? I
don't have any numbers, but I would say IBM spend loads of money on
open source.
James, I did not claim MSFT invests in OSS. I said "... microsoft
invests heavily, over the long term, in their OS, ?languages,
frameworks, tools. ..."
-Steve
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 7
date: Fri, 26 Feb 2010 18:45:00 -0000
from: "Neill Harper" <neill.harper@xxxxxxxx>
subject: RE: Silverlight and IBM i was : Why i??? NEED YOUR INPUT
Do those Silverlight apps run on the iphone, PS3, Nintendo wii any
browser that isn't Internet explorer?
If they do then this sounds like a cracking technology.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: 26 February 2010 14:27
To: Midrange Systems Technical Discussion
Subject: Silverlight and IBM i was : Why i??? NEED YOUR INPUT
On Thu, Feb 25, 2010 at 3:02 PM, Aaron Bartell <aaronbartell@xxxxxxxxx>
wrote:
So you get instant deployment of your application, but without all the
CSS,
Javascript, HTML, server side/client side stuff that complicates web
programming.
And how well does that work when you are talking about an application
that has thousands of screens? ?How well does deployment work then?
?Are the files big like the Flex .swf approach?
Even though we have much more bandwidth than 5 years ago, I think
Microsoft
is shooting themselves in the foot by having compiled home grown
objects downloaded to the browser for every screen. ?They could have
made a much thinner and better performing veneer by only passing down
a screen definition to a render engine and keep all of the compiled
programs on the server so you never have to wonder if everybody is
operating on the same version of code.
The entire application is dowloaded, not a single screen. When you
create a SL project in VS you get a resulting .XAP file in the ClientBin
directory. That is a .zip file, only with a .xap extension.
Explaining in Java terms, the browser app runs in a JVM with the runtime
framework excluding parts that enable access to the local machine.
XAML, which originated with WPF is really, really, really good for doing
the GUI - what HTML and CSS are used for in web apps.
Using web services to put and get data to the server is all the rage now
as the way to design apps. Silverlight is dead center in that style of
app design. ( Not that using web services to this extent is easy and
without problems. This blogger has a lot of interesting things to say:
http://wildermuth.com/ )
One of the really good things that MSFT is doing regards LINQ. Linq is a
replacement for SQL. A Linq query is compiled, composed, stored in
something called an "expression tree". That expression tree is a data
structure which can be transmitted over the wire from client to server.
( the IQueryable interface is a combo of IEnumerable for iterating thru
a collection and an expression tree. ) The usage in Silverlight is to
have the C# silverlight client code contain a Linq query to access the
database. Parts of the .NET framework like WCF and RIA services take
that linq query in expression tree form, send it up to the server thru a
web service call, at the server convert the expression tree to SQL, run
the SQL against the database server ( note, that database server could
be DB2 on IBM i ), get the resulting result set, convert the result set
to XML or whatever and send the results back as the return value of the
web service call. For paging thru a large database, you use TAKE and
SKIP in your LINQ code to limit the number of rows returned.
www.silverlight.net has loads of videos that explain how it all works.
The forums that are hosted there are very busy and you get excellent
answers to your questions.
-Steve
--
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:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 8
date: Fri, 26 Feb 2010 20:02:59 +0100
from: Lukas Beeler <lukas.beeler@xxxxxxxxxxxxxxxx>
subject: Re: Silverlight and IBM i was : Why i??? NEED YOUR INPUT
On Fri, Feb 26, 2010 at 19:45, Neill Harper <neill.harper@xxxxxxxx>
wrote:
Do those Silverlight apps run on the iphone, PS3, Nintendo wii any
browser
that isn't Internet explorer?
No, Silverlight only works on Browsers that use the Netscape plugin
system, IE and a few Mac & Linux browsers.
http://www.microsoft.com/silverlight/resources/faq/#sys-req
Silverlight will support all major browsers on both Mac OS X, Linux
and on Windows. Particular care is being taken to account for
differences in platform and browser capabilities to ensure a
consistent experience including experiences on Firefox, Safari, and
Internet Explorer.
midrange.com
