• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Retrieving Query Definitions

    July 31, 2002 Timothy Prickett Morgan

    Hey, Ted:

    You mentioned in your article, “Print Query Definitions from a Batch Job,” in the May 22 issue of Midrange Guru, OS/400 Edition, a way of getting print definitions of Query/400 queries by using a process of RUNQRY and PRTDEF(*YES). This method didn’t help me much; I had too many queries and that meant too much processing time. I had to resort to manually printing the query definitions to an output queue, typing option 6s while in WRKQRY for each library. I was about to do the same for Query Management queries but I found the

    …

    Read more
  • SQL Understands Microseconds

    July 31, 2002 Timothy Prickett Morgan

    Hey, Ted:

    I am writing regarding your article, “Using Timestamps as Unique Keys ,” which printed on July 17 in Midrange Guru, OS/400 Edition. I would like to add the following option for consideration.

    Although the timestamp microsecond value returned by the TIME operation code is only accurate to three positions, SQL’s current timestamp register returns a value accurate to six positions.

    To verify this assumption, I created the following simple SQLRPGLE program:

    D timestamp1      s               z
    D timestamp2      s               z
    
    C                   time                    timestamp1
    C/exec sql
    C+ set :timestamp2 = current timestamp
    C/end-exec
    C
    C                   eval      *inlr = 
    …

    Read more
  • Changing Languages on a 5250 Screen

    July 31, 2002 Timothy Prickett Morgan

    Hey, Joe:

    I do technical support for a country in South America, where the AS/400’s primary language is 2931 (Spanish). But when I telnet over to do tech support, I want my screens to display in language code 2924 (English), which is installed on the machine as a secondary language. Is it possible to change my PC5250 screens to display English?

    — Alex

    It’s possible to change a user session’s PC5250 screen to display in any installed secondary language by adding a language library to the first position in the system part of the user’s library list. By default, your

    …

    Read more

Content archive

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

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

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