× 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: Read Trigger Question

 
I believe an 'implied' read will be generated on a delete action.

Stan Fellers
Senior Programmer Analyst
Magellan Health Services
314-387-4243
314-387-4270 fax

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
midrange-l-request@xxxxxxxxxxxx
Sent: Monday, September 12, 2005 2:28 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 4, Issue 1723

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: XML question (Bryan Dietz)
   2. Read Trigger Question (bgreenfield@xxxxxxxxxxxxx)
   3. RE: XML question (vhamberg@xxxxxxxxxxx)
   4. Re: Read Trigger Question (vhamberg@xxxxxxxxxxx)
   5. RE: Data access for non-AS400 devs? (vhamberg@xxxxxxxxxxx)
   6. Re: MIDRANGE-L Digest, Vol 4, Issue 1722 (Jeff Glenn)


----------------------------------------------------------------------

message: 1
date: Mon, 12 Sep 2005 14:33:56 -0400
from: Bryan Dietz <BDietz@xxxxxxxxxx>
subject: RE: XML question

Not sure if you are trying to document your commands or just get some
other documentation.

If it is for extra documentation you may want to try the GENCMDDOC
command.
It generates HTML.



----------------------------
Bryan Dietz
Aktion Associates


midrange-l-bounces@xxxxxxxxxxxx wrote on 09/12/2005 12:26:19 PM:

> > Subject: Re: XML question
> >
> > No answer for you, but joining you in frustration. IBM's Retrieve 
> > Command Definition (QCDRCMDD) API generates XML that describe the 
> > command. I tried to use WDSC to work with it, to make a web page 
> > that'd

> > display the contents nicely. Unfortunately, in the XML perspective,
when
> > validating the SML, WDSC reports "Document is invalid: no grammar 
> > found". I find it silly and possibly stupid that IBM can't generate 
> > XML

> > that it's own tool can handle.
> >
> > 'Nuf said!
> > Vern



------------------------------

message: 2
date: Mon, 12 Sep 2005 11:32:00 -0400
from: bgreenfield@xxxxxxxxxxxxx
subject: Read Trigger Question

I would like to confirm something that was just discovered. I have a
trigger program (RPGILE) attached to a file that executes only when a
read event occurs. But it appears that a 'DELETE' operation on that file
causes the trigger to fire. This is not a situation where I read a
record then issue the 'Delete' operation. This is a 'delete' operation
where the key is specified. Can anyone confirm this? This particular
application has a series of program calls, that because of the 'read'
trigger being executed as a result of a 'delete' operation causes a
recursive call. 

Thanks for any input.


Bill Greenfield
Senior Technical Consultant
Computer Applications Specialists, Inc.
6201 Chevy Chase Drive
Laurel, MD 20707
Voice:  301 776 3400    Fax:  301 776 3444
BGreenfield@xxxxxxxxxxxxxx

------------------------------

message: 3
date: Mon, 12 Sep 2005 19:02:15 +0000
from: vhamberg@xxxxxxxxxxx
subject: RE: XML question

Yeah, GENCMDDOC is cool, but does not list all the settings on all the
parameters - the API is useful for reverse-engineering commands - one of
the formats even retrieves info on hidden (constant) parameters.

-------------- Original message -------------- 

> Not sure if you are trying to document your commands or just get some 
> other documentation.
> 
> If it is for extra documentation you may want to try the GENCMDDOC
command. 
> It generates HTML. 
> 
> 
> 
> ----------------------------
> Bryan Dietz
> Aktion Associates
> 
> 
> midrange-l-bounces@xxxxxxxxxxxx wrote on 09/12/2005 12:26:19 PM: 
> 
> > > Subject: Re: XML question 
> > > 
> > > No answer for you, but joining you in frustration. IBM's Retrieve 
> > > Command Definition (QCDRCMDD) API generates XML that describe the 
> > > command. I tried to use WDSC to work with it, to make a web page
that'd 
> 
> > > display the contents nicely. Unfortunately, in the XML
perspective, 
> when 
> > > validating the SML, WDSC reports "Document is invalid: no grammar 
> > > found". I find it silly and possibly stupid that IBM can't
generate XML 
> 
> > > that it's own tool can handle. 
> > > 
> > > 'Nuf said! 
> > > Vern 
> 
> -- 
> 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: 4
date: Mon, 12 Sep 2005 19:05:20 +0000
from: vhamberg@xxxxxxxxxxx
subject: Re: Read Trigger Question

Hmmm! Does a keyed DELETE "include" a CHAIN or SETLL, hence the read?
Would it behave differently if you SETLL by key and then DELETE without
key? Would that work? Been too long!

-------------- Original message -------------- 

> I would like to confirm something that was just discovered. I have a 
> trigger program (RPGILE) attached to a file that executes only when a
read 
> event occurs. But it appears that a 'DELETE' operation on that file
causes 
> the trigger to fire. This is not a situation where I read a record
then 
> issue the 'Delete' operation. This is a 'delete' operation where the
key 
> is specified. Can anyone confirm this? This particular application has
a 
> series of program calls, that because of the 'read' trigger being
executed 
> as a result of a 'delete' operation causes a recursive call. 
> 
> Thanks for any input. 
> 
> 
> Bill Greenfield 
> Senior Technical Consultant 
> Computer Applications Specialists, Inc. 
> 6201 Chevy Chase Drive 
> Laurel, MD 20707 
> Voice: 301 776 3400 Fax: 301 776 3444 
> BGreenfield@xxxxxxxxxxxxxx 
> -- 
> 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: Mon, 12 Sep 2005 19:10:37 +0000
from: vhamberg@xxxxxxxxxxx
subject: RE: Data access for non-AS400 devs?

I misstated myself, too, Loyd - sorry.

OpsNav is probably your best bet. There is a plugin for WDSC but it does
not handle everything. And setup is not for the faint of heart. Also,
you want to be sure to be careful about filters you set up. There's also
just the Database perspective of WDSC. My comments about filters may
apply to that directly. Maybe look in the archives for the WDSC list
here. There is also a client for DB2 generally that can work against the
iSeries. Again, IIRC, it misses some things. I think it's the
Administration client you get with DB2 on the PC.

Go with OpsNav.
-------------- Original message -------------- 

> 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) 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: Mon, 12 Sep 2005 15:27:05 -0400
from: "Jeff Glenn" <jeff.glenn@xxxxxxxxxxxxxxxxxxx>
subject: 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.