× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2005

Re: MIDRANGE-L Digest, Vol 4, Issue 1722

Loyd,

You can use Query Analyzer if you can set up your 400 as a linked 
server in SQL Server. Requires iSeries Access ODBC driver loaded on the 
SQL Server box. Then you can select over your 400 files from Query 
Analyzer with a 4-part qualification like so:

select  * from LinkedServerName.MachineSerialNumber.LibraryName.FileName

Jeff

date: Mon, 12 Sep 2005 13:13:31 -0500
from: "Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
subject: RE: Data access for non-AS400 devs?

Thanks Rob. As I said to Vern, I may have mis-phrased my request. I'm
looking for non-5250 tools to allow a non-AS/400 developer access SQL 
data
on the iSeries, a la Query manager. Thankfully this is an actual SQL
database with relationships.

I'm trying to avoid command line training if possible

> 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..."
> 
> 
> Today's Topics:
> 
>    1. Re: Print overlay (Mike Wills)
>    2. RE: Midrange News (LOL!) (Bill Rice)
>    3. Re:  Data access for non-AS400 devs? (Mitch Davidson)
>    4. Re: Print overlay (Mike Wills)
>    5. RE: Print overlay (Bob Anderson)
>    6. Re: Print overlay (Mike Wills)
>    7. RE: IPDS printing "off" (Chuck Lewis)
>    8. Re: Print overlay (Pat Barber)
>    9. Re: Print overlay (rob@xxxxxxxxx)
>   10. RE: Data access for non-AS400 devs?
>       (Goodbar, Loyd (ETS - Water Valley))
>   11. RE: Data access for non-AS400 devs?
>       (Goodbar, Loyd (ETS - Water Valley))
> 
> 
> ----------------------------------------------------------------------
> 
> message: 1
> date: Mon, 12 Sep 2005 11:25:16 -0500
> from: Mike Wills <koldark@xxxxxxxxx>
> subject: Re: Print overlay
> 
> I thought I had some documention on my site, but I can't seem to find 
it 
> right now. Contact me offline. I believe I have some good 
documenation on 
> overlays.
> 
> On 9/12/05, Trevor Perry <tperry@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > 
> > Can anyone give me guidance on how to create (and use) an overlay 
on a
> > spooled file? I need to print a box in the top right corner on 
every page.
> > 
> > Thanks,
> > Trevor
> > tperry@xxxxxxxxxxxxxxxxxxxxx
> > 
> > --
> > 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.
> > 
> > 
> 
> 
> -- 
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> 
> 
> ------------------------------
> 
> message: 2
> date: Mon, 12 Sep 2005 11:23:56 -0600
> from: "Bill Rice" <bill.rice@xxxxxxxxxxxx>
> subject: RE: Midrange News (LOL!)
> 
> They also advertise regularly in the IT Jungle publications. Latest 
one:
> http://www.itjungle.com/tfh/tfh090605.html
> 
> Bill Rice
> iTera, Inc.
> 
> >
> > Yes page 23 and 81 of this months issue of iSeries News.
> >
> > Hoss
> >
> 
> 
> 
> 
> ------------------------------
> 
> message: 3
> date: Mon, 12 Sep 2005 13:23:59 -0400
> from: "Mitch Davidson" <DAVIDSON_L@xxxxxxxxxxxxxxxx>
> subject: Re:  Data access for non-AS400 devs?
> 
> ... In a pinch, you can also use the SQL Wizard in iSeries
> Access for Web.  
> It's not 5250, it's your browser.
>   
> > But, for ad hoc, iSeries Navigator isn't bad.
> > 
> > Rob Berendt
> > -- 
>  
> 
> 
> 
> ------------------------------
> 
> message: 4
> date: Mon, 12 Sep 2005 12:33:54 -0500
> from: Mike Wills <koldark@xxxxxxxxx>
> subject: Re: Print overlay
> 
> While I can't seem to find the documentation I origonally used, I did 
put on 
> the Wiki a really good description on what to do from another 
Midrange 
> person from here. I don't rember who wrote it up, but here is the 
wiki page: 
> http://wiki.midrange.com/index.php/Creating_an_Overlay. 
> 
> Hey David, not sure where this should be placed and I can't seem to 
be able 
> to edit the FAQ either. Could you add it for me?
> 
> On 9/12/05, Trevor Perry <tperry@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > 
> > Can anyone give me guidance on how to create (and use) an overlay 
on a
> > spooled file? I need to print a box in the top right corner on 
every page.
> > 
> > Thanks,
> > Trevor
> > tperry@xxxxxxxxxxxxxxxxxxxxx
> > 
> > --
> > 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.
> > 
> > 
> 
> 
> -- 
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> 
> 
> ------------------------------
> 
> message: 5
> date: Mon, 12 Sep 2005 13:58:56 -0400
> from: "Bob Anderson" <banderson@xxxxxxxxxxxxxxxxxxx>
> subject: RE: Print overlay
> 
> Mike,
>       The links on the wiki don't work
> 
> 
> Bob Anderson
> IT Guy
> Kent Sporting Goods Inc.
> New London OH
> Ph: 419-929-7021 x315 
> Fax: 419-929-1380 
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Wills
> Sent: Monday, September 12, 2005 1:34 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Print overlay
> 
> While I can't seem to find the documentation I origonally used, I did 
put on
> the Wiki a really good description on what to do from another Midrange
> person from here. I don't rember who wrote it up, but here is the 
wiki page:
> 
> http://wiki.midrange.com/index.php/Creating_an_Overlay. 
> 
> Hey David, not sure where this should be placed and I can't seem to 
be able
> to edit the FAQ either. Could you add it for me?
> 
> On 9/12/05, Trevor Perry <tperry@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > 
> > Can anyone give me guidance on how to create (and use) an overlay 
on a 
> > spooled file? I need to print a box in the top right corner on 
every page.
> > 
> > Thanks,
> > Trevor
> > tperry@xxxxxxxxxxxxxxxxxxxxx
> > 
> > --
> > 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.
> > 
> > 
> 
> 
> --
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> --
> 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.
> 
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.10.21/96 - Release Date: 
9/10/2005
>  
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.10.21/96 - Release Date: 
9/10/2005
>  
> 
> 
> 
> ------------------------------
> 
> message: 6
> date: Mon, 12 Sep 2005 13:02:39 -0500
> from: Mike Wills <koldark@xxxxxxxxx>
> subject: Re: Print overlay
> 
> I will have a make a note to clean it up later. Thanks for letting me 
know.
> 
> On 9/12/05, Bob Anderson <banderson@xxxxxxxxxxxxxxxxxxx> wrote:
> > 
> > Mike,
> > The links on the wiki don't work
> > 
> > 
> > Bob Anderson
> > IT Guy
> > Kent Sporting Goods Inc.
> > New London OH
> > Ph: 419-929-7021 x315
> > Fax: 419-929-1380
> > 
> > 
> > 
> 
> 
> -- 
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> 
> 
> ------------------------------
> 
> message: 7
> date: Mon, 12 Sep 2005 13:07:26 -0500
> from: "Chuck Lewis" <chuck.lewis@xxxxxxxxxxxxx>
> subject: RE: IPDS printing "off"
> 
> Paul/Wayne,
> 
> You guys ROCK - that was it. EDGE=ON on the IPDS config. Weird 
because that
> is what a config sheet from a while back shows (ON) but now I'm not 
sure I
> trust it because it printed FINE now :-)
> 
> Thanks guys !
> 
> Chuck
> 
> -----Original Message-----
> From: midrange-l-bounces+chuck.lewis=leesupply.net@xxxxxxxxxxxx
> [mailto:midrange-l-bounces+chuck.lewis=leesupply.net@xxxxxxxxxxxx] On 
Behalf
> Of Wayne McAlpine
> Sent: Friday, September 09, 2005 3:42 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: IPDS printing "off"
> 
> Is there a setting in the printer's configuration menu for edge-to-
edge 
> printing vs. an unprintable border?  Usually the default is an 
> unprintable border, but it's much easier to do the print layout for a 
> form if you set the printer to print edge-to-edge.  A mismatch 
between 
> what the print file expects and the setting of the printer would 
> certainly cause registration problems.
> 
> 
> 
> 
> 
> 
> ------------------------------
> 
> message: 8
> date: Mon, 12 Sep 2005 14:05:28 -0700
> from: Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>
> subject: Re: Print overlay
> 
> A simple box does not require a overlay. This can be done "if"
> you are using an externally described print file and compile
> the DDS as AFPDS. It can be printed on practically any laser
> printer, although a IPDS printer would be a "tad" faster.
> 
> If you are using a pc printer with none native attach,
> use HPT which handles AFPDS data streams just fine.
> 
> Drag out that DDS manual and start reading up on boxes, lines,
> and all that other stuff you can do but most people never bother
> to learn.
> 
> I have created some quite complex forms with lots of lines,boxes
> and various fonts using DDS and lots of practice.
> 
> 
> Trevor Perry wrote:
> 
> > Can anyone give me guidance on how to create (and use) an overlay 
on a 
> > spooled file? I need to print a box in the top right corner on 
every page.
> > 
> > Thanks,
> > Trevor
> > tperry@xxxxxxxxxxxxxxxxxxxxx
> 
> 
> ------------------------------
> 
> message: 9
> date: Mon, 12 Sep 2005 13:06:20 -0500
> from: rob@xxxxxxxxx
> subject: Re: Print overlay
> 
> Thanks.
> 
> On the FAQ, did you first click on "Appearance"?
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> Mike Wills <koldark@xxxxxxxxx> 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 09/12/2005 12:33 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> Re: Print overlay
> 
> 
> 
> 
> 
> 
> While I can't seem to find the documentation I origonally used, I did 
put 
> on 
> the Wiki a really good description on what to do from another 
Midrange 
> person from here. I don't rember who wrote it up, but here is the 
wiki 
> page: 
> http://wiki.midrange.com/index.php/Creating_an_Overlay. 
> 
> Hey David, not sure where this should be placed and I can't seem to 
be 
> able 
> to edit the FAQ either. Could you add it for me?
> 
> On 9/12/05, Trevor Perry <tperry@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > 
> > Can anyone give me guidance on how to create (and use) an overlay 
on a
> > spooled file? I need to print a box in the top right corner on 
every 
> page.
> > 
> > Thanks,
> > Trevor
> > tperry@xxxxxxxxxxxxxxxxxxxxx
> > 
> > --
> > 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.
> > 
> > 
> 
> 
> -- 
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> -- 
> 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: 10
> date: Mon, 12 Sep 2005 13:09:51 -0500
> from: "Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
> subject: RE: Data access for non-AS400 devs?
> 
> Thanks, Vern. I didn't mean to imply I didn't know SQL; I meant the 
only
> graphical tool I'm aware of to use iSeries SQL was Navigator. The 
command
> line certainly is my friend. :)
> 
> Loyd Goodbar
> Senior programmer/analyst
> BorgWarner
> E/TS Water Valley
> 662-473-5713
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
vhamberg@xxxxxxxxxxx
> Sent: Monday, September 12, 2005 11:01
> To: Midrange Systems Technical Discussion
> Subject: RE: Data access for non-AS400 devs?
> 
> I actually prefer STRSQL on the iSeries for learning SQL and trying 
things
> out. It will give you results faster, in my experience. F4 is your 
friend
> here, as well as on the command line. The drawback is, it has not 
kept up
> with some of the modern additions to SQL on iSeries. E.g., it does not
> prompt for JOIN syntax, although it will process it. You CAN create 
stored
> procedures in it, so it's not too bad.
> 
> When creating SPs, BTW, be sure to use VARCHARs, not CHARs - literals 
are
> passed as VARCHARs and will not match is the parameter is a CHAR.
> 
> HTH
> Vern
> 
> 
> 
> ------------------------------
> 
> message: 11
> date: Mon, 12 Sep 2005 13:13:31 -0500
> from: "Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
> subject: RE: Data access for non-AS400 devs?
> 
> Thanks Rob. As I said to Vern, I may have mis-phrased my request. I'm
> looking for non-5250 tools to allow a non-AS/400 developer access SQL 
data
> on the iSeries, a la Query manager. Thankfully this is an actual SQL
> database with relationships.
> 
> I'm trying to avoid command line training if possible.
> 
> Loyd Goodbar
> Senior programmer/analyst
> BorgWarner
> E/TS Water Valley
> 662-473-5713
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Monday, September 12, 2005 11:47
> To: Midrange Systems Technical Discussion
> Subject: RE: Data access for non-AS400 devs?
> 
> 5250 supports:
> 
> STRSQL.  (as others have commented)  Providing you have 57##ST1 
loaded on 
> your system.
> 
> RUNSQLSTM (store your SQL source, like CREATE PROCEDURE, in a source 
> member and execute it with RUNSQLSTM).  I use this for where I used 
to use 
> QDDSSRC.  No additional program products needed.
> 
> STRQMQRY.  Store your SQL source in a source member.  Run CRTQMQRY on 
it 
> to "compile" it.  Execute it with STRQMQRY.  No additional software 
> needed.
> 
> STRQM.  Provides a method to do prompted (like Query/400) or SQL 
method. 
> If you had a choice between purchasing Query/400 or 57##ST1, buy 
57##ST1 
> to also get the imbedded SQL capability.
> 
> Imbedded SQL.  Needs 57##ST1 loaded on your system.  And some HLL 
> compiler.  Allows you to imbed SQL in a HLL program.  For instance, 
if you 
> wanted to write a RPG program and have it return a result set as a 
SQL 
> stored procedure, comes in mighty handy.
> 
> SQL CLI.  Compiler of choice needed.  Much more work than imbedded 
SQL. 
> Has some minor capabilities not available to imbedded SQL.  Only 
people 
> who use it are:
> - Those who get a testosterone rush out of doing things the hard way.
> - Those who will not upgrade to V5R3 which fixed many of the 
limitations 
> of the imbedded SQL precompiler
> - Those who do not have the means to purchase 57##ST1.
> - Those who need that one or two obscure little feature not supported 
by 
> imbedded SQL.
> (See the sorcerers guide for more information.)
> 
> But, for ad hoc, iSeries Navigator isn't bad.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> ------------------------------
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 
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.
> 
> 
> 
> End of MIDRANGE-L Digest, Vol 4, Issue 1722
> *******************************************
> 
>

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.