RE: What is best forum regarding building web sites? -- MIDRANGE-L

I shall be looking at drupal, as I never heard of it before. What makes you prefer it to Joomla!?

As a beginner, I have tried a simple personal site with Joomla!, but I found it so hard to personalize that I gave up and started my own site from scratch. I didn't want my site to look like someone else's. I wonder if there are any tools for modifying the templates?

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Nick Litten
Envoyé : dimanche 21 février 2010 16:28
À : Midrange Systems Technical Discussion
Objet : Re: What is best forum regarding building web sites?

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/activati

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

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