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



Check out www.drupal.org - my preferred CMS
another strong contender is www.Joomla.org - which is arguably simpler to
install.

Both are fantastic, free, opensource PHP based website management systems -
which are also simple to install on your IBMi if you wish.


Cheers,
Nick

projex <http://www.projex.com/> | email <nick.litten@xxxxxxxxxx> |
profile<http://www.projex.com/nick.litten>|
skype <http://www.skype.com/nick.litten> |
facebook<http://www.facebook.com/Nick.Litten>|
linkedin <http://www.linkedin.com/in/nicklitten> |
twitter<http://twitter.com/finkpad>


On 19 February 2010 11:18, Bryce Martin <BMartin@xxxxxxxxxxxx> wrote:

You could go with a content management system that can be custom themed.
This is an easy way to go usually. If you want to discuss options and
requirements email me off-list. brycekmartin@xxxxxxxxx


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



BT Consulting <btconsulting@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/19/2010 09:39 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
What is best forum regarding building web sites?






Gang,

Long time, no write on my part. Greetings to all.

I'm trying to find the best forum for creating web sites of a simple
nature
for a museum. Any recommendations?

Thanks in advance,

David Odom
Casa Grande, AZ


-----Original Message-----
From: midrange-l-request@xxxxxxxxxxxx
Sent: Feb 18, 2010 9:11 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 9, Issue 307

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: Finding CPW for iseries (Dan)
2. Re: STRPCCMD - MAIL TO (Jerry Draper)
3. Retrieve Email Address From SMTP Table (Taylor iSeries)
4. Re: Retrieve Email Address From SMTP Table (Mark S. Waterbury)
5. RE: Retrieve Email Address From SMTP Table (Musselman, Paul)
6. Re: Retrieve Email Address From SMTP Table (Scott Klement)
7. Re: STRPCCMD - MAIL TO (Gqcy)
8. Re: Quality time to Software Development (Mike)
9. Re: Ranking results (Vern Hamberg)


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

message: 1
date: Thu, 18 Feb 2010 17:13:47 -0500
from: Dan <drothman@xxxxxxxxxx>
subject: Re: Finding CPW for iseries

Rhishabh Srivastava wrote:
Using server feature code and processor feature code and model i can
find
the min and max value that can be supported by the particular model but
the
current value is less and i am not getting a clue from system to find
it .

Rhishabh, is your customer's system partitioned?
And do you know how many processors are activated?

I like to use the Performance Capabilities Reference found at
http://www-03.ibm.com/systems/i/advantages/perfmgmt/resource.html to
look up CPW ratings (see Appendix C) and find lots of other useful
information. This reference has just been updated for POWER7.

However we would still need to know how many CPUs are active in the
customer's LPAR, if partitioned.

I'm happiest when customers take advantage of the free IBM service
"PM for Power Systems" (see:
http://www-03.ibm.com/systems/power/support/perfmgmt/activation.html to
activate it.) This collects and summarizes performance data from your
iSeries by LPAR. It will tell you how many CPUs are allocated to the
LPAR and how many CPW are available and are being consumed. I can't
remember which reports are free and which are fee but
http://www-03.ibm.com/systems/power/support/perfmgmt/index.html will
show you sample reports.

-Dan R.


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

message: 2
date: Thu, 18 Feb 2010 14:29:31 -0800
from: Jerry Draper <midrangel@xxxxxxxxxxxxx>
subject: Re: STRPCCMD - MAIL TO

Check out the no chare MMAIL service from Giavonni Perotti at
EASY400.net.

It will email convert spool file to .pdf files and email them to a list
of addresses.

http://www.easy400.net/mmail/start

Jerry

rob@xxxxxxxxx wrote:
Thanks for the explanation. I guess I would wonder why the PDF was on
a
client and not on a server of some kind that the i could attach to and
retrieve. Technically they could get if off the PC from a share on the

PC, but I'd prefer a server to use QNTC or some alternative.


Rob Berendt


--
Jerome Draper, Trilobyte Software Systems, since 1976
iSeries, Network, and Connectivity Specialists -- iSeries, LAN/WAN/VPN
Representing WinTronix, Synapse, Netopia, HiT, and others .....
(415) 457-3431; www.trilosoft.com



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

message: 3
date: Thu, 18 Feb 2010 14:11:06 -0800 (PST)
from: Taylor iSeries <tayloriseries@xxxxxxxxx>
subject: Retrieve Email Address From SMTP Table

Hi
You can set up a user's email address in the SMTP table using WRKDIRE.
Is there an API to retrieve the email address?

Thank you




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

message: 4
date: Thu, 18 Feb 2010 17:52:55 -0500
from: "Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>
subject: Re: Retrieve Email Address From SMTP Table

Hi, Taylor:

Not quite an "API", but you can do a DSPDIRE to an *OUTFILE and then
read the contents of the output file.

All the best,

Mark S. Waterbury

Taylor iSeries wrote:
Hi
You can set up a user's email address in the SMTP table using WRKDIRE.
Is there an API to retrieve the email address?

Thank you






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

message: 5
date: Thu, 18 Feb 2010 18:06:05 -0500
from: "Musselman, Paul" <pmusselman@xxxxxxxxxxxxxxxx>
subject: RE: Retrieve Email Address From SMTP Table

You can just use these standard data files:

QATMSMTPA-- index is by the directory entry
QATMSMTPL1-- index by Email Name

QAOFENR2-- Index by User Profile to find Directory Entry
QAOFENRB-- Logical over QAOFENR2 by Directory Entry to find User Profile

Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx


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

message: 6
date: Thu, 18 Feb 2010 17:08:39 -0600
from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
subject: Re: Retrieve Email Address From SMTP Table

Yes, the API is QOKSCHD. I wrote an article that demonstrated using
that API to get the SMTP name here:
http://systeminetwork.com/article/get-smtp-name-programmatically


On 2/18/2010 4:11 PM, Taylor iSeries wrote:
Hi
You can set up a user's email address in the SMTP table using WRKDIRE.
Is there an API to retrieve the email address?

Thank you






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

message: 7
date: Thu, 18 Feb 2010 17:31:08 -0600
from: Gqcy <gmufasa01@xxxxxxxxx>
subject: Re: STRPCCMD - MAIL TO

We use MMAIL here, but it will only hold 50 recipients.

Our old system would convert the spool files to PDF's and mail them (or
fax them), but we have evolved to where the users are creating their
mailings in various methods, outside the system i (DAMN THEM TO H...!)
Really, all I have on the system i is the list. I thought about just
mailing a .csv to the user, with instructions to copy and paste.

Thanks for your reply!
-gerald




Jerry Draper wrote:
Check out the no chare MMAIL service from Giavonni Perotti at
EASY400.net.

It will email convert spool file to .pdf files and email them to a list

of addresses.

http://www.easy400.net/mmail/start

Jerry

rob@xxxxxxxxx wrote:
Thanks for the explanation. I guess I would wonder why the PDF was on

a client and not on a server of some kind that the i could attach to
and retrieve. Technically they could get if off the PC from a share
on the PC, but I'd prefer a server to use QNTC or some alternative.


Rob Berendt




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

message: 8
date: Thu, 18 Feb 2010 19:25:17 -0600
from: Mike <koldark@xxxxxxxxx>
subject: Re: Quality time to Software Development

Of course we all have been there... Knee deep in some complicated
logic then someone knocks on your "door" and asks a question. Now not
only do you have to talk to them (maybe even help them) but now you
lost your train of thought. You have to recollect your train of
thought and maybe redo a large debug because you lost your place. That
is time wasted.

There is a simple solution, no interuptions faster development times.
The problem is that for 99% of the shops out there this isn't feasible
or possible.

I like Joel's idea of every developer has their own office with a
door. If you need to concentrate, you shut the door.

My only problem with working from home is distractions. However, if
it were to become a full-time office, I would make changes to cut out
some of the distactions.

--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark

Sent from my iPod

On Feb 18, 2010, at 10:05 AM, rob@xxxxxxxxx wrote:

Herman Miller is a huge customer of ours (along with many of the
other top
furniture makers). We supply cubicle wiring, lights, etc and molded
frames for chairs.
So, his advice on chairs, is outstanding!


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Bryce Martin <BMartin@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-
l@xxxxxxxxxxxx>
Date: 02/18/2010 09:10 AM
Subject: Re: Quality time to Software Development
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Just one of the articles related to what makes a programmer
productive....

http://www.joelonsoftware.com/articles/fieldguidetodevelopers.html


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



Bryce Martin <BMartin@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/17/2010 04:44 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Quality time to Software Development






check out this site. www.joelonsoftware.com he talks extensively
about
programmer's environments and what makes them good.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



"Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/17/2010 04:10 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Quality time to Software Development






Anyone have a link to any Professional or 'proof' articles regarding
the
'environment or setting' required for an IT Developer to get his work
done?

I now work one day from home each week, and that is the ONLY day I can
truly say I can get into the huge Analysis/Design/Programming part
of my
duties.

I am lobbying for more time telecommuting. When at work, and having
just
a cubicle, there is NO WAY I can ever get into these development
duties. I


am a one man show with 60 PC users, and the worst part is that my
boss is
scared to death about a PC being physically down - because my work
is 40
miles from my home.

TIA

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman



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



--- This message (including any attachments) is intended only for
the use
of the individual or entity to which it is addressed and may contain
information that is non-public, proprietary, privileged,
confidential, and

exempt from disclosure under applicable law. If you are not the
intended
recipient, you are hereby notified that any use, dissemination,
distribution, or copying of this communication is strictly
prohibited. If
you have received this communication in error, please notify us and
destroy this message immediately. ---
--
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.



--- This message (including any attachments) is intended only for
the use
of the individual or entity to which it is addressed and may contain
information that is non-public, proprietary, privileged,
confidential, and
exempt from disclosure under applicable law. If you are not the
intended
recipient, you are hereby notified that any use, dissemination,
distribution, or copying of this communication is strictly
prohibited. If
you have received this communication in error, please notify us and
destroy this message immediately. ---
--
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.


--
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: 9
date: Thu, 18 Feb 2010 22:10:38 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>
subject: Re: Ranking results

One should almost never use a logical file in a query - SQL has always
ignored it and had to go back to the PF, then figure out which index
(LF) to use, by its own wisdom.

SQE will never be used if you specify a logical file. The only time -
before 6.1 - to use a logical is if it were a select/omit that matched
your WHERE clause, maybe. In 6.1 there are better alternatives - like a
sparse index - I think that's the term.

HTH
Vern

ibm wrote:
Thanks for your help, it looks like I had to query against the physical
file. I will try to put together a CTE for the rank now.

This works:

SELECT CUSNO, CUSNM,
RANK() OVER(ORDER BY CUSNO DESC)
FROM AMFLIB.MBBFREP
FETCH FIRST 10 ROWS ONLY

This does NOT work:

SELECT CUSNO, CUSNM,
RANK() OVER(ORDER BY CUSNO DESC)
FROM AMFLIB.cusmas
FETCH FIRST 10 ROWS ONLY

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of ibm
Sent: Thursday, February 18, 2010 9:53 AM
To: Midrange Systems Technical Discussion
Subject: RE: Ranking results

Hmm, ok, let my try this again. Btw, I am using the Run SQL Scripts
and creating SQL Stored Procedures inside Navigator to test Rank().

How do I make sure that SQE is executing the query?

Thanks

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Thursday, February 18, 2010 9:34 AM
To: 'Midrange Systems Technical Discussion'
Subject: AW: Ranking results

The OLAP-Ranking Functions are supported under Release V5R4.
But AFAIK the query must be executed by the SQE (Queries that use the
CQE
cannot use the OLAP Ranking functions)

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 ibm
Gesendet: Thursday, 18. February 2010 15:24
An: Midrange Systems Technical Discussion
Betreff: RE: Ranking results

Is Rank() supported on iSeries 5.4?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Wednesday, February 17, 2010 11:22 PM
To: 'Midrange Systems Technical Discussion'
Subject: AW: Ranking results

Hi,

have you tried to use a CTE for your SQL-Statement and specify RANK in
the
final select?

With x as (YourSelect-Statement)
Select "Customer Name", "Rank 1", Rank() Over(Order By "Rank1) ....
From x

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 ibm
Gesendet: Wednesday, 17. February 2010 22:51
An: Midrange Systems Technical Discussion
Betreff: Ranking results

I am trying to figure out how to rank sales figures. The report would
return Q4 sales for 2009, 2009, 2007 with rankings varying for each
year
depending on sales. I was trying to use Rank() but " An OLAP function
is not supported for this query.".

SELECT
AMFLIB . CUSMAS . CUSNO AS "Customer Number" , AMFLIB .
CUSMAS .
CUSNM AS "Customer Name" ,
SUM ( CASE WHEN AMFLIB . MBF9REP . FEGHNB BETWEEN 1091001
AND
1091231 THEN AMFLIB . MBDDREP . DDDUVA ELSE 0 END ) AS "QE 12/31/09" ,
0 AS "RANK 1",
--RANK() OVER (ORDER BY SUM ( CASE WHEN AMFLIB . MBF9REP
.
FEGHNB BETWEEN 1091001 AND 1091231 THEN AMFLIB . MBDDREP . DDDUVA ELSE
0
END ) ) AS "RANK 1",
SUM ( CASE WHEN AMFLIB . MBF9REP . FEGHNB BETWEEN 1081001
AND
1081231 THEN AMFLIB . MBDDREP . DDDUVA ELSE 0 END ) AS "QE 12/31/08" ,
0 AS "RANK 2",
SUM ( CASE WHEN AMFLIB . MBF9REP . FEGHNB BETWEEN 1071001
AND
1071231 THEN AMFLIB . MBDDREP . DDDUVA ELSE 0 END ) AS "QE 12/31/07" ,
0 AS "RANK 3",
SUM ( CASE WHEN AMFLIB . MBF9REP . FEGHNB BETWEEN 1100101
AND
1100331 THEN AMFLIB . MBDDREP . DDDUVA ELSE 0 END ) AS "QE 03/31/10" ,
0 AS "RANK 4",
SUM ( CASE WHEN AMFLIB . MBF9REP . FEGHNB BETWEEN 1090101
AND
1090331 THEN AMFLIB . MBDDREP . DDDUVA ELSE 0 END ) AS "QE 03/31/09" ,
0 AS "RANK 5",
SUM ( CASE WHEN AMFLIB . MBF9REP . FEGHNB BETWEEN 1080101
AND
1080331 THEN AMFLIB . MBDDREP . DDDUVA ELSE 0 END ) AS "QE 03/31/08",
0 AS "RANK 6"
FROM
AMFLIB . CUSMAS
-- Shipment Header
JOIN AMFLIB . MBDHREP
ON AMFLIB . CUSMAS .
CUSNO = AMFLIB . MBDHREP .
DHCANB
-- Shipment Details
JOIN AMFLIB . MBDDREP
-- ON Shipment #
ON AMFLIB . MBDHREP .
DHZ969 = AMFLIB . MBDDREP
. DDZ969
-- Invoice Header
JOIN AMFLIB . MBF9REP
-- ON Invoice #
ON AMFLIB . MBF9REP .
FEGGNB = AMFLIB . MBDHREP
. DHGGNB
WHERE

AMFLIB . MBDDREP . DDAXNB = 1 OR AMFLIB . MBDDREP .
DDAAF4 = 1
GROUP BY
AMFLIB . CUSMAS . CUSNO ,
AMFLIB . CUSMAS . CUSNM
ORDER BY
"QE 12/31/09" DESC
FETCH FIRST 50 ROWS ONLY;



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

--
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 307
******************************************

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



--- This message (including any attachments) is intended only for the use
of the individual or entity to which it is addressed and may contain
information that is non-public, proprietary, privileged, confidential, and
exempt from disclosure under applicable law. If you are not the intended
recipient, you are hereby notified that any use, dissemination,
distribution, or copying of this communication is strictly prohibited. If
you have received this communication in error, please notify us and destroy
this message immediately. ---
--
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.