• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Reader Feedback and Insights: Printing Leading Zeros in Query/400, Another Look

    June 12, 2002 Timothy Prickett Morgan

    Hey, Ted:

    In response to your “Odds and Ends” article in the May 31 Midrange Guru, OS/400 Edition, specifically the tip that discusses Printing Leading Zeros in Query/400, Another Look, there’s another way to ‘skin a cat.’

    Use an edit word with an extra zero at the beginning of the field. For example, to edit a Social Security number, I use edit word 0nnn-nn-nnnn. It works just fine unless you need to print this field starting at print position 1.

    — Rich

    Sponsored By
    ADVANCED SYSTEMS CONCEPTS

    SEQUEL meets all your iSeries and AS/400 data access

    …

    Read more
  • String Parameters of Various Lengths, Take Two

    June 12, 2002 Timothy Prickett Morgan

    Dear Readers:

    Several people have written to point out errors in my solution to the reader who wanted to make an RPG subprocedure accept character parameters of any size. I need to correct the code that I provided in that issue of Midrange Guru, OS/400 Edition. (I plan to explore this topic more and to present the ideas of my respondents in the near future, so watch for more information in a future edition of Midrange Guru.)

    Here is the original question”

    “I have an RPG IV subprocedure that I call from several different programs. I use

    …

    Read more
  • Build SQL to Define Your Existing Files, Revisited

    June 12, 2002 Timothy Prickett Morgan

    Hey, Ted:

    In the June 5 issue of Midrange Guru, OS/400 Edition, you explained how to use the QSQGNDDL API to generate SQL to create SQL Data Definition Language (SQL DDL) for existing objects. I’m writing to mention that you can do the same thing without any programming through Operations Navigator (OpsNav).

    — John Valance

    Thanks for bringing it up, John.
    Here are the steps:

    When you open the connection to the iSeries machine, you’ll see a Database option in the navigation pane. When you click on Database, the tasks panel (across the bottom of the window) will be

    …

    Read more

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