Re: Palm PDA <--> as/400

the DB2 everyplace software will let you run SQL interactively or in an
application on the palm. It's actually a subset of the standard SQL found in
DB2 beginning with V5. (Not the 400 V5, but DB2 UDB V5.)

it's connection to the 400 (unless its changed recently) is actually through
NT. The data can be staged on the NT in DB2 V7 or V6 (possibly V5) and then
replicated (bidirectionally) through NT to the palm. The replication can be
used with DPropR on the 400 to maintain the NT database.

When the planets are aligned, you should be able to get DB2 on NT to talk to
the 400 DB2 directly. (I hear anyway, it almost always tells me the version
is not supported. sigh.)

I have not looked at Satellite (in DB2) but it was for "occassionally
connected" users. Maybe they have something for palm there too???

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: Hatzenbeler, Tim <thatzenbeler@clinitech.net>
To: 'midrange-l@midrange.com' <midrange-l@midrange.com>
Date: Friday, September 07, 2001 12:55 PM
Subject: Palm PDA <--> as/400


>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>--
>[ Picked text/plain from multipart/alternative ]
>
>I was asked to create a small portable version of an applications that I
>have on our as/400, but for a palm pda...
>
>I was wondering if anybody has tried it... Writing the app, doesn't look
too
>hard, but transferring the database or a subset of the data ie: select *
>from ..... where user = 'tim' or being able to push the changed data back
to
>the as/400 to be resynced into the master files, is where I'm stuck...
>
>Any help, ideas or code would be tremendously appreciated...
>
>p.s.  if this is off (list) topic, please e-mail me directly...  Thanks,
>again...tim
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>