Query/400 and Record Selection by Date

Hey, Ted:

I was asked to create a Query/400 query that would take the current date and determine yesterday's date, last week's date, and three months from the current date, and select records using these dates. This can be done within Query/400, but only it requires you to define a lot of clunky result fields needed to determine relative dates, especially when you're looking at numbers in CYYMMDD format to represent dates. I have a more simple (and portable) solution.

READ MORE >

Object Authorities and Stored Procedure Calls

Hey, Howard:

Just a minor "enhancement" to your discussion of stored procedures ["Restoring Procedures to a Development Machine"]. Technically, it isn't always necessary to declare a stored procedure before you call a program as a stored procedure. For this discussion, it seems the declaration (CREATE PROCEDURE) is only required if return parameters are needed. If you aren't concerned about returning values, you can use the program as if it had been declared. I think you demonstrate this when you issue a call to QCMDEXC in your article.

READ MORE >

Reader Feedback and Insights: He Uses SQL to Define Databases

Hey, Ted:

Here in our department, we don't use DDS anymore. We keep all of our tables, indexes, and views in a database model (ERwin) and generate them directly from the model.