Programming


The API Corner: What Time Zone Do You Want That Date and Time In? PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 15 July 2015 00:00

Today, we'll look at more uses for the Convert Date and Time Format API.

bruce viningWritten by Bruce Vining

Last month, in How Do You Want That Date and Time?, we used the first five parameters of the Convert Date and Time Format (QWCCVTDT) API to format a date and time value stored in a *DTS format to a YYYYMMDDHHMMSS format that's much friendlier to work with. This month, we'll look at the two optional parameter groups of the API. But first some background.

Add a comment

Last Updated on Tuesday, 14 July 2015 13:38
Read more...
 
SQL 101: Writing More Complex Queries PDF Print E-mail
Programming - SQL
Written by Rafael Victoria-Pereira   
Friday, 10 July 2015 00:00

One-table queries are OK, but data is usually spread over different tables in the database. To write a query that uses data from more than one table, you need to join the tables. This article shows ways to do that.

rafael victoria preiraWritten by Rafael Victória-Pereira

Using one table in a Select statement won't get you very far: most databases are structured to avoid data repetition and use multiple tables to achieve that goal, which means that you'll probably have to use different tables for the actual data and its human-understandable descriptions.

 

Let me try to explain this with an example:

Add a comment
Last Updated on Friday, 10 July 2015 00:00
Read more...
 
Sending Messages on IBM i, Part 2 PDF Print E-mail
Programming - CL
Written by James Buck   
Wednesday, 08 July 2015 00:00

Part 1 investigated message queues and types of messages. Now we'll look at the CL commands that send messages.

Written by Jim Buck, Bryan Meyers, and Dan Riehl

Editor's note: This article is an excerpt from Chapter 16, "Advanced Message Handling," of Control Language Programming for IBM i. See Part 1 here.

 

Four major CL commands are used to send messages:

  • SNDMSG (Send Message)
  • SNDBRKMSG (Send Break Message)
  • SNDPGMMSG (Send Program Message)
  • SNDUSRMSG (Send User Message)
Add a comment
Last Updated on Wednesday, 08 July 2015 00:00
Read more...
 
User Rating: / 1
PoorBest 
Practical SQL: Partitions and MERGEs PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 01 July 2015 00:00

Updating one file from another in SQL has been messy in the past, but this technique makes it a lot easier.

joe plutaWritten by Joe Pluta

One of the big advantages of SQL is the fact that you can add columns to a table without worrying about the underlying access; columns that aren't used are simply ignored in the SQL client programs. However, once you have added that column, the next trick is to populate the column correctly.

Add a comment
Last Updated on Tuesday, 30 June 2015 10:15
Read more...
 
RPG Academy: BIF Up Your Code! More Excel-like Functions with %XLATE PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 01 July 2015 00:00

There's more to string operations than splitting and stitching. Curious? Keep reading.

rafael victoria preiraWritten by Rafael Victória-Pereira

Something as trivial as changing the case (from lowercase to UPPERCASE, for instance) of a string can be a challenge in RPG, because unlike SQL (and MS Excel), RPG doesn't have a change case function. So let's build one, using yet another BIF: %XLATE.

Add a comment

Last Updated on Tuesday, 30 June 2015 11:21
Read more...
 
User Rating: / 2
PoorBest 
RPG Academy: BIF Up Your Code! Building MS Excel-like LEFT and RIGHT Functions Using BIFs PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 17 June 2015 00:00

It's time to have a little fun! Let's build MS Excel-like LEFT and RIGHT functions using BIFs.

rafael victoria preiraWritten by Rafael Victória-Pereira

My guess is that you, dear reader, use MS Excel (or some sort of spreadsheet similar to it) to some extent. Even if you don't use it every day, it's possible that you've come across the LEFT, MID, and RIGHT functions. If you haven't, this article provides a nice overview. These are simple yet powerful text-handling functions. LEFT and RIGHT don't have a parallel in RPG. However, the MID function does: it's the %SUBST BIF that I presented two TechTips ago.

Add a comment
Last Updated on Wednesday, 17 June 2015 00:00
Read more...
 
User Rating: / 2
PoorBest 
The API Corner: How Do You Want That Date and Time? PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 17 June 2015 00:00

Have it the way you want it by using the Convert Date and Time Format API.

bruce viningWritten by Bruce Vining

Last month, in What's the Status of My Data Queue?, we used the Convert Date and Time Format (QWCCVTDT) API to format a date and time value stored in an internal format to a YYYYMMDDHHMMSS format much friendlier to work with, but we really didn't discuss how the API is used. This month, we'll look at some of the uses of QWCCVTDT.

 

The Convert Date and Time Format API converts date and time values from one format to another. For example, using the API you can:

Add a comment
Last Updated on Tuesday, 16 June 2015 12:37
Read more...
 
Continuous Delivery: What Is This Devilry from the Web Side? PDF Print E-mail
Programming - General
Written by David Shirey   
Wednesday, 10 June 2015 00:00

Everyone knows it takes forever to get something through the process and into production. Who are these CD folks trying to fool?

david shireyWritten by David Shirey

Let's start by asking ourselves one very important question: What is Continuous Delivery?

Thousands of years from now, when mankind has destroyed the Earth and reaped extinction as the reward, and birds, whose ancestors were the dinosaurs, have at last gained mastery over our world, they will determine that humans derived most of their information from two sources: Wikipedia and Entertainment Tonight.

Add a comment

Last Updated on Wednesday, 10 June 2015 08:12
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 218

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.

   MC-STORE.COM