Re: What is best forum regarding building web sites?

[Bryce Martin <BMartin@xxxxxxxxxxxx>]

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