• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • End of Year Miscellanea

    December 15, 2010 Hey, Distinguished Professional

    The year’s almost up, believe it or not. What’s even harder for me to believe is that we’ve been putting out this newsletter for almost 10 years. It’s been wonderful to hear how you’ve benefited from Four Hundred Guru. Let’s end 2010 with some feedback from readers of this august publication.

    –Ted


    Hey, Ted:

    Thank you very, very, very, very much for the extremely helpful tip showing how to edit spool files. Under big time pressure, I couldn’t fully test mandatory payroll changes before payroll ran them. In the middle of the check it would jump to the next check and continue on the correct line. Big Ooops!

    I thought I’d have to write a program to read the spooled file after it was copied to a database file. The program would figure out, based on the printer control characters, what line I had, and create a new output database file. Then I would download that and do a mail merge into Word. I figured this process would take me until at least 3 o’clock the next morning. Because of your great article, I went home at 9:45 p.m.

    Many, many thanks once again for making this available on the Web. Twenty minutes of research for a possible better solution paid off big-time!

    –Neil

    I’m glad it helped you, Neil. Feedback like yours is what makes putting this newsletter together so rewarding. You made my day.

    –Ted


    Hey, Ted:

    I used your article on global temporary tables to solve an SQL problem that was driving me nuts! The goal was to show containers that had hazardous materials first, then show containers without hazardous materials. I considered adding a field to the container table, but didn’t want to trust users to set it correctly (and you just don’t mess around with hazardous shipments). I easily solved the problem by creating a temporary table, joining it to other tables, and ordering by a coalesced count. Thanks for the help!!!

    –Tim

    I’m not sure which article Tim was referring to, and didn’t think to ask at the time. Here’s more about global temporary tables.

    –Ted

    Hey, Ted:

    You can skip the unnecessary step of dropping the temporary table by adding the WITH REPLACE clause.

        exec sql
           declare global temporary table Temp1 as
               (select *
                  from sales
                 where companyno  = :inCompany
                   and customerno = :inCustomer)
             with data WITH REPLACE;
    

    If the table already exists, the system will blow it away prior to creating it.

    –Robert

    Robert wrote in response to Global Temporary Tables and Host Variables. I had forgotten about WITH REPLACE and was thankful for the reminder.

    –Ted


    Hey, Ted:

    I saw Justin’s tip regarding updating spreadsheet data fed by SQL statements. There’s a much easier way to do things. MS Query will feed an SQL statement into the spreadsheet and will allow the user to refresh at any time. It also allows parameters in the statement (but the statement has to be in the graphical format, they’re not allowed in the SQL format). Parameters greatly expand the usability of this feature for the users.

    –Bill


    Hey, Ted:

    Using JDBC you can specify remarks=sql on the connection string and that will get you the SQL label instead of the field name. That can also be set in the GUI properties using iSeries Navigator.

    –Coy

    Coy’s comment is in response to Every Bucket Deserves a Descriptive Name.

    –Ted


    Hey, Ted:

    With every article I read about Qshell or Unix commands, I’m more convinced than ever that, though they were probably (partially) born out of the necessity of simplicity (in the sense of miserly use of resources–definitely not in the sense of making sense), they’ve stayed cryptic all these years for just one reason: By the time a person masters their use they’re too proud of their accomplishment to want to negate that accomplishment by upgrading the “language” to something that resembles a 21st century (or late 20th century) language. After all, why make it simpler for those who haven’t endured the learning curve themselves?

    –Jim

    You’re not the only person who’s unimpressed with Unix. Read the next correspondence.

    –Ted

    Hey, Ted:

    “There’s two things that came out of Berkley in the 60s: LSD and Unix and that’s not a coincidence.”

    -Bill

    I had never heard this quotation. I found out it’s attributed to Jeremy S. Anderson and is probably not true. Here’s one Web site that deals with it.

    -Ted


    Hey, Ted:

    We need something to help these one-man shops that don’t have the time and resources to get out and learn new things that apply to everyday programming. I know there are things I am doing today that could be done easier or faster, but having the time to learn them is not an option so I have to pick up pieces wherever I see them. The articles in the Four Hundred Guru are fantastic, and I have picked up many tips on how to do things in different and better ways. Thanks, Ted. There are a lot of us out here who really appreciate what you are doing.

    –Duane

    I’ve been a one-man shop too, Duane. I know where you’re coming from.

    –Ted


    Thanks to everybody who took time to write.

    That does it for this year. I plan to enjoy Christmas, and hope that you also enjoy the holidays. May 2011 be our best year ever.

    –Ted

    RELATED STORIES

    How Did I Do That?

    Every Bucket Deserves a Descriptive Name

    Global Temporary Tables and Host Variables

    Edit Spooled Files with SEU



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Maxava

    Migrating to New IBM i Hardware?

    Whether you are moving to POWER9, Power10, or a cloud hosted system MAXAVA HAS YOU COVERED!

    Learn More

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    VAULT400:  Which is right for you? Online back-up, DR, HA Webinar. Jan. 20
    Townsend Security:  FREE Podcast! Key management best practices: What new PCI regulations say
    Help/Systems:  Robot/SCHEDULE Enterprise, the job scheduling and server management tool

    IT Jungle Store Top Book Picks

    BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The iSeries Pocket Database Guide: List Price, $59
    The iSeries Pocket SQL Guide: List Price, $59
    The iSeries Pocket WebFacing Primer: List Price, $39
    Migrating to WebSphere Express for iSeries: List Price, $49
    Getting Started with WebSphere Express for iSeries: List Price, $49
    The All-Everything Operating System: List Price, $35
    The Best Joomla! Tutorial Ever!: List Price, $19.95

    Attachmate Updates Reflection Suites Oracle’s Withdrawal of JDE ‘Blue Stack’ Raises Questions

    Leave a Reply Cancel reply

Volume 10, Number 38 -- December 15, 2010
THIS ISSUE SPONSORED BY:

SEQUEL Software
neuObjects
inFORM Decisions

Table of Contents

  • Make SQL Edit the Way You Want It To
  • End of Year Miscellanea
  • Discovering Which Locked Object is Holding Up Your Job

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • LANSA Developing Business Intelligence Tool
  • Blazing The Trail For VTL In The Cloud
  • Data De-Dupe Gives VTL Customers More Options
  • Four Hundred Monitor, March 29
  • The Big Spending On IT Security Is Only Going To Get Bigger
  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle