Programming / APIs


The API Corner: Accessing a Command Line PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 18 April 2012 00:00

The Display Command Line Window (QUSCMDLN) API makes it easy!

bruce_viningWritten by Bruce Vining

When recently visiting a client, I overheard one of their developers mention the desire to get to a command line from within an application program. There is, of course, an API to do just that. And, as the API has been around since V1R3, I suspect there are quite a few developers who have had a similar need.

Add a comment
Last Updated on Wednesday, 18 April 2012 00:00
Read more...
 
User Rating: / 3
PoorBest 
The API Corner: More on UNIX-Type Time Values PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 21 March 2012 00:00

There are some things you need to consider when using epoch-based time values.

bruce_viningWritten by Bruce Vining

Last month, in the article "Understanding and Using UNIX-Type Time Values," we looked at how to answer the specific question, "Does anyone know how to convert the time values that are returned from the stat() IFS api for an IFS file?" Two possible solutions were reviewed: using RPG timestamp support and also using C run-time API support. Today, we'll look at bit deeper into the time values returned by many UNIX-type APIs and some considerations related to the use of these time values.

Add a comment
Last Updated on Wednesday, 21 March 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
Cool Things: A Simple Utility for Sending HTML Emails on the IBM i PDF Print E-mail
Programming - APIs
Written by Mike Faust   
Friday, 02 March 2012 00:00

Send a simple message to notify a user when a batch job completes, or send a detailed notification to a customer, or anything in between.

mike_faustWritten by Mike Faust

If you've used the SNDDST command on the IBM i to send email messages, you know that this is a very useful way to communicate things like job completions. The one big drawback is that you have very little control over the format of the messages sent using this command. While this command does give you the ability to embed line feed and new paragraph commands into your message body, that's about all of the formatting you can do. What if you could embed HTML statements into your email messages? Read on and discover how to do this with the help of a simple little command.

Add a comment
Last Updated on Friday, 02 March 2012 00:00
Read more...
 
User Rating: / 8
PoorBest 
The API Corner: Understanding and Using UNIX-Type Time Values PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 15 February 2012 00:00

Learn how to format a returned value such as 1,329,293,701 to a fixed definition of days, months, years, etc.

bruce_viningWritten by Bruce Vining

Earlier this month, over on the RPG Programming section of the IBM i mailing list rpg400-l@midrange.com, this question was posed: "Does anyone know how to convert the time values that are returned from the stat() IFS API for an IFS file?" The answer to the question of course is yes, and in this article, we'll look at some of the possible solutions.

Add a comment
Last Updated on Wednesday, 15 February 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
The API Corner: Renaming and Moving Objects Doesn't Have to Be Difficult PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 18 January 2012 00:00

The Rename Object API offers flexibility above and beyond just renaming.

bruce_viningWritten by Bruce Vining

In last month's article, Deleting Objects, we reviewed a rather general-purpose API: Delete Object (QLIDLTO). This month, we'll look at another general purpose API: the Rename Object (QLIRNMO) API, which is documented here and has been available since V2R3. The Rename Object API, as you might expect, allows you to rename an object. Not as obvious, the QLIRNMO API also allows you to move an object. As with QLIDLTO, using the Rename Object API allows you to directly operate on an object without having to run a CL command from your RPG application program under the covers.

Add a comment
Last Updated on Wednesday, 18 January 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
The API Corner: Deleting Objects PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 21 December 2011 00:00

The Delete Object API offers flexibility in terms of removing unneeded objects.

bruce_viningWritten by Bruce Vining

As a new year approaches, many of you may be looking at general house-cleaning of your i. This activity might include deleting those objects that have been created over the last 12 months and are no longer needed. In the past, if you wanted to automate such cleanup activities from, say, an RPG application program, you may have written various CL programs that were then called from the RPG program in order to run the appropriate DLTxxx CL command or, as an alternative, constructed the appropriate CL DLTxxx command within an RPG program variable and then run the command using an API such as Process Commands. If your system is at V6 or later, you now have another option, one that does not rely on running CL commands. This new technique, of course, is also available to your application programs whenever they need to delete an object, not just for general system maintenance.

Add a comment
Last Updated on Wednesday, 21 December 2011 00:00
Read more...
 
User Rating: / 1
PoorBest 
Curious About Finding Errors in SQL Statements? PDF Print E-mail
Programming - APIs
Written by Andrew Shelestov   
Wednesday, 16 November 2011 00:00

With the help of the QSQCHKS API, you can easily and quickly find where errors occur.

andrew_shelestovWritten by Andrew Shelestov

A lot of people run SQL statements often, but few of them can find the place where an error occurs in those statements. In this article, I'll show you how to detect the position of these errors by using the Syntax Check SQL Statement (QSQCHKS) API , which is documented here.

Add a comment
Last Updated on Monday, 14 November 2011 13:41
Read more...
 
User Rating: / 8
PoorBest 
The API Corner: The Case of the Missing Stream Files, Part II PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Thursday, 20 October 2011 00:00

Process the data returned by the QjoRetrieveJournalEntries API.

bruce_viningWritten by Bruce Vining

Last month, in "The Case of the Missing Stream Files," we saw how to call the QjoRetrieveJournalEntries API, documented here, in order to access all journal entries associated with the removal of an IFS link from a directory. The links removed might be *STMFs, *SYMLNKs, *DIRs, etc. As the goal of the project is to determine who removed the links, today we'll look at how to process the results of calling the QjoRetrieveJournalEntries API.

Add a comment
Last Updated on Thursday, 20 October 2011 15:55
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 4 of 19

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