subject: Re: OVERLAY with PDF problem -- MIDRANGE-L

I have a print job where I am printing a front and back overlay using
duplex. When I print, it looks fine, everything prints where it should.

Probably the PDF device has a page definition (*LETTER / *A4 ... ) not
matching the other one.

I can see the page size on the PDF is a letter when I create the PRN file.

Where else do I set a page size? I do not see anything in OVRPRTF where you can select *LETTER or such.

Thanks
Tom Deskevich

--------------------------------------------------
From: <midrange-l-request@xxxxxxxxxxxx>
Sent: Thursday, May 13, 2010 9:02 AM
To: <midrange-l@xxxxxxxxxxxx>
Subject: MIDRANGE-L Digest, Vol 9, Issue 796

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: Duplicate key error on file with no key
(Gundermann, Glenn / Kuehne + Nagel / Tor ZI-A)
2. RE: IBM i hosting "in the cloud (Richard Schoen)
3. Microsoft Office 2010 (Richard Schoen)
4. RE: Microsoft Office 2010 (Mike Cunningham)
5. Re: Microsoft Office 2010 (Lukas Beeler)
6. AW: Calling CL program to delete .ZIP file in IFS as part of
an SQL Delete (Birgitta Hauser)
7. Re: OVERLAY with PDF problem (Marco Facchinetti)
8. Re: Change source file name from QRPGSRC to QRPGLESRC
(Jeff Crosby)
9. Re: Microsoft Office 2010 (David Gibbs)

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

message: 1
date: Wed, 12 May 2010 19:55:14 -0400
from: "Gundermann, Glenn / Kuehne + Nagel / Tor ZI-A"
<Glenn.Gundermann@xxxxxxxxxxxxxxxx>
subject: Re: Duplicate key error on file with no key

double-check for a key using dspfd.
Is it possible there is an override to another file that has a key?

_________________________
To learn more about Kuehne + Nagel Ltd, please visit our website at: www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit: http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf

Visitez le site internet de Kuehne + Nagel Lt?e: www.kuehne-nagel.com Notre d?charge de responsabilit? est disponible comme suit: http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf

To learn more about Kuehne + Nagel Ltd, please visit our website at: www.kuehne-nagel.com For the Kuehne + Nagel email disclaimer, visit: http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf

Visitez le site internet de Kuehne + Nagel Lt?e: www.kuehne-nagel.com Notre d?charge de responsabilit? est disponible comme suit: http://www.kn-portal.com/material/Electronic_Email_Disclaimer_English_French.pdf

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

message: 2
date: Wed, 12 May 2010 18:23:28 -0600
from: "Richard Schoen" <richard@xxxxxxxxxxxxxxx>
subject: RE: IBM i hosting "in the cloud

If there's a handful of people on this list who are developers and would
like to go together to offset the cost of a box and can commit to a 2yr
option, would be happy to work with you and be the front end to the
process.

We're in the process of specing a box for V7R1 and could go for a bigger
leased box with multiple partitions with some shared cost commitments
from others.

Contact me directly offline if you're interested in more discussion.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------------------------------------------------
---
message: 1
date: Wed, 12 May 2010 11:34:53 -0400
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: IBM i hosting "in the cloud"

My requirements are similar to that stated by others here. I have need
of a reliable, _current_, system to develop education, run classes and
also to run both my own business and that of System i Developer. I
would be more than happy to invest in any sensible cloud-based
solution that met my needs. I keep hoping that IBM, who let's face it
are in the best position and should have a vested interest, will offer
something but so far nothing.

Unlike Aaron the ISV route is not an option for me unless I am
prepared to "fake" having a product - which at this time I am not
prepared to do.

I have tried working with IBM over the years via a number of avenues:
The Business Partner program - which removed us from the membership
level that allows discounted hardware purchase because we don't sell
hardware; The ISV program which as stated above requires you be
developing a software product; The Education Partner program - which
has so many silly rules and enforced pricing restrictions that it
would cost me money to run classes; and many other avenues that have
been explored over the years.

Education and Open Source software, both of which are vital to the IBM
i community just don't have a place on IBM's radar it seems. If
currency wasn't important I could purchase a used machine - but since
many (most?) of those no longer seem to carry their license keys even
that avenue is closing.

There really are days when becoming a Windows or Unix developer sounds
like a really good idea. Quick someone - slap me before I become
completely incoherent!

Jon Paris

www.Partner400.com

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

message: 3
date: Wed, 12 May 2010 20:29:24 -0600
from: "Richard Schoen" <richard@xxxxxxxxxxxxxxx>
subject: Microsoft Office 2010

I just upgraded to Office 2010 on one of my test PCs.

Looks like the ribbon bar and general look and feel has been tweaked
again.

Anyone know any benefits to Office 2010 other than looks ? :-)

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

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

message: 4
date: Wed, 12 May 2010 22:41:30 -0400
from: Mike Cunningham <mike.cunningham@xxxxxxx>
subject: RE: Microsoft Office 2010

Revenue for Microsoft :) http://www.computerworld.com/s/article/9135364/Review_Office_2010_Technical_Preview_no_wow_just_solid_improvements

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Wednesday, May 12, 2010 10:29 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Microsoft Office 2010

I just upgraded to Office 2010 on one of my test PCs.

Looks like the ribbon bar and general look and feel has been tweaked
again.

Anyone know any benefits to Office 2010 other than looks ? :-)

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

--
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: Thu, 13 May 2010 09:52:32 +0200
from: Lukas Beeler <lukas.beeler@xxxxxxxxxxxxxxxx>
subject: Re: Microsoft Office 2010

On Thu, May 13, 2010 at 04:29, Richard Schoen <richard@xxxxxxxxxxxxxxx> wrote:
Anyone know any benefits to Office 2010 other than looks ? :-)

There are several solid improvements in regards to security (the
protected mode when opening files from unstrusted locations, like
email attachments or internet downloads), performance (Outlook now
works better with larger mailboxes on slow hard drives), collaboration
(there's the option to edit documents at the same time from two
different workstations - which can make it easier to work on a larger
document together, requires sharepoint, though).

But in general, you're right - Office 2010 is evolutionary, while
Office 2007 was revolutionary in several regards. Luckily for me,
we're current on our software assurance and are already rolling out
Office 2010 internally - and it doesn't cost us a dime.

--
Read my blog at http://projectdream.org

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

message: 6
date: Thu, 13 May 2010 10:17:58 +0200
from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: AW: Calling CL program to delete .ZIP file in IFS as part of
an SQL Delete

Hi Charles;

But the compiler doesn't like me doing a SELECT instead of a SELECT

INTO...

If you want to access several rows (I assume why you are replacing SELECT
INTO with SELECT) you need to Declare a cursor, Open, Fetch rows (execute
your delete statement per row) and finally close the cursor (just like you'd
do it with embedded SQL).

Mit freundlichen Gr??en / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Urspr?ngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Charles Wilt
Gesendet: Wednesday, 12. May 2010 21:28
An: Midrange Systems Technical Discussion
Betreff: Calling CL program to delete .ZIP file in IFS as part of an SQL
Delete

All,

We've got an existing SQLRPGLE program that contains basically the
statement:

delete from mytable
where datefld <= CURRENT_DATE - 1 month;

Datefld is non-unique, so many records could have the same date.

One of the other developers came to me and asked if there was a way to
call a CL program that will delete a .ZIP file with a naming
convention that includes the date for any dates being deleted from the
table. Example: MY_ARCHIVE_yyyyy-mm-dd.ZIP

The developer already had a CL program that when passed the date,
would delete the .ZIP.

My first thought, sure we can create a user defined function to call
the CL during the execution of the SQL statement...
delete from mytable
where datefld <= CURRENT_DATE - 1 month
and Delete_Zip_File(char(datefld,ISO)) = '0';

Anybody see a problem with this? (hint consider non short circuit
evaluations ;)

Then I thought well we'll just run two statements:
with tbl as (select distinct datefld
from mytable
where datefld <= CURRENT_DATE - 1 month
)
select Delete_Zip_File(char(datefld,ISO))
from tbl;

delete from mytable
where datefld <= CURRENT_DATE - 1 month;

But the compiler doesn't like me doing a SELECT instead of a SELECT INTO...

Anyway, the developer is looking at just using RPG RLA to delete the
rows, calling the CL program normally when the date changes.

But I thought it's an interesting issue and I figured I thought it out
here to see if anybody had any better ideas.

Thanks!
Charles Wilt
--
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: Thu, 13 May 2010 12:08:15 +0200
from: Marco Facchinetti <marco.facchinetti@xxxxxxxxx>
subject: Re: OVERLAY with PDF problem

Hi Tom,

2010/5/12 Tom Deskevich <thomas.l.deskevich@xxxxxxxxxxxxx>

I have a print job where I am printing a front and back overlay using
duplex. When I print, it looks fine, everything prints where it should.

Probably the PDF device has a page definition (*LETTER / *A4 ... ) not
matching the other one.

Put when I do an OVRPRTF to a pdf, the overlay shifts, and the variable
information does not hit the overlay.

I do have DEVTYPE(*AFPDS) , TOSTMF('/image/parks.pdf') and WSCST(*PDF) .
I have tried to take off the DUPLEX, and the back OVERLAY.

Tried creating the overlay different ways. I start with a PDF to create the
overlay.
I have page scaling NONE. Print text as graphics off.
I have tried to print to an AFP 300 and 3812 printer to create the overlay.

I do not get any errors in the OVERLAY creation process.
I copy it from IFS to QDLS, do a CPYFRMPCD then CRTOVL.

You can easly create overlays via System i Navigator without using
intemediate files or docs:

AFP Manager > Resources > Overlay rigth click and Import...

HTH
MarcoF

Thanks.

Tom Deskevich
INFOCON Corporation
814-472-6066
Fax 472-5019

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

message: 8
date: Thu, 13 May 2010 07:40:44 -0400
from: Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>
subject: Re: Change source file name from QRPGSRC to QRPGLESRC

There's enough other stuff on my plate that I think I will just leave it as
is.

On Tue, May 11, 2010 at 10:45 PM, Robert Munday <rwmunday@xxxxxxxxxxxxx>wrote:

-----Original Message-----
Jeff,

<<< On 5/11/2010 3:07 PM, Jeff Crosby wrote:
<<< any pitfalls in renaming QRPGSRC to QRPGLESRC? >>>

I've been using the Charlie Massoglia method for the past twenty years. My
source resides in QSRC. No members have identical names (nor should they)
and I can globally display what I want in PDM. If I need to see all
SQLRPGLE programs, I can filter for that. If I'm working on program
xxxx120x, I can filter on *120* and I will see all of my elements in one
place. My only other source physical file is QCMD for commands... they
share the name with the CL.

Robert Munday
Munday Software Consultants
Montgomery, AL
on assignment in Jacksonville, FL

--
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.

--
Jeff Crosby
VP Information Systems
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my
company. Unless I say so.

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

message: 9
date: Thu, 13 May 2010 08:02:36 -0500
from: David Gibbs <david@xxxxxxxxxxxx>
subject: Re: Microsoft Office 2010

Richard Schoen wrote:

Anyone know any benefits to Office 2010 other than looks ? :-)

This question would be better suited in the PCTECH list (http://pctech.l.midrange.com).

Please post any responses to that list instead of here.

Thanks!

david

--
IBM i on Power Systems - For when you can't afford to be out of business

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

--
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 9, Issue 796
******************************************