Life, the Internet, and Everything!

SQL

A Handy ‘Quick Query’ Command on the iSeries

Here’s a fun- and useful – little command you can create on the iSeries (or IBMi, AS400) in about 2 minutes. I usually create some version of this on every system I work on because I use it constantly. I’ll explain how below. First, the basics. The RUNQRY command can be used to run a […]

Continue Reading

Tips for Using Time Stamps in ILE RPG

Some notes regarding timestamps. Defining a Timestamp A timestamp is stored as a 26 character field. But, the system looks at it as a special data type and enforces the rules it has set up for timestamps. The format for a timestamp is is YYYY-MM-DD-HH.MM.SS.XXXXXX (Year-Month-Day-Hour.Minute.Second.Milliseconds). An example would be ‘2011-09-14-22.06.48.592000’ (Year: 2011 / Month: 09 […]

Continue Reading