https://code400.com/forum/ vBulletin Forums en Sun, 25 Oct 2026 05:06:47 GMT vBulletin 60 images/misc/rss.png https://code400.com/forum/ https://code400.com/forum/forum/iseries-programming-languages/sql/159553-a-most-grave-grievance-concerning-the-absence-of-weeks-in-db2 Fri, 23 Oct 2026 16:53:33 GMT Unto the Esteemed Sirs Scott Klement and Bob Cozzi, Defenders of the IBM i Realm, Keepers of the Sacred RPG, and Scholars of the Ancient SQL Scrolls, Hear ye! Hear ye! I, Lord of the House of Db2, Master of the Query, and Rightful Keeper of the Royal SYSDUMMY1, do hereby lodge a most grievous... Unto the Esteemed Sirs Scott Klement and Bob Cozzi, Defenders of the IBM i Realm, Keepers of the Sacred RPG, and Scholars of the Ancient SQL Scrolls,

Hear ye! Hear ye!

I, Lord of the House of Db2, Master of the Query, and Rightful Keeper of the Royal SYSDUMMY1, do hereby lodge a most grievous complaint against the dark sorcery that hath befallen our noble kingdom.

For lo, upon this very morn, I sought to subtract eight WEEKS from the CURRENT_DATE, a task so humble that even the lowliest stable boy could reckon it upon his fingers.

Yet the mighty Db2, in all its supposed wisdom, did cast mine query into the abyss!

EIGHT WEEKS, GOOD SIRS! EIGHT WEEKS!

Forsooth! The wretched engine doth gladly accept 56 DAYS, yet trembles before the mere utterance of 8 WEEKS!

What manner of witchcraft is this?!

Hath the scholars of Rochester forgotten the existence of the seven-day week? Must I summon the royal mathematician to multiply eight by seven, as though we still dwell in the age of the abacus?!

I say thee NAY!

I have commanded my finest scribes to examine the sacred manuals, yet nowhere do they find salvation from this most ridiculous affliction.

Therefore, I demand that ye petition the High Council of IBM forthwith, that WEEKS be restored to their rightful place among the noble units of time.

Should this injustice remain unanswered, I shall have no recourse but to summon my knights, raise the banners of rebellion, and lay siege to the gates of Rochester itself!

And let it be known throughout the land:

I SHALL NOT BE FORCED TO MULTIPLY BY SEVEN LIKE SOME COMMON PEASANT!

May thy compilers be merciful, thy job queues forever empty, and thy PTFs never require an IPL.

By mine own hand and royal decree,

His Lordship, Baron von Queryshire
Duke of Date Arithmetic
Protector of the Seven-Day Week
Keeper of the Green Screen
First of His Name, Breaker of Queries
Defender of the AS/400 Realm

Given under mine seal, this sixteenth day of October, in the Year of Our Lord Two Thousand and Twenty-Six.

P.S. Should either of thee dare suggest that I write an RPG subprocedure to resolve this matter, I shall consider it an act of WAR.
​]]> SQL BaronVonQueryshire https://code400.com/forum/forum/iseries-programming-languages/sql/159553-a-most-grave-grievance-concerning-the-absence-of-weeks-in-db2 https://code400.com/forum/forum/iseries-programming-languages/ifs/159552-rpgle-program-that-converts-a-spool-file-to-pdf-and-puts-on-the-ifs Thu, 22 Oct 2026 14:18:27 GMT I have a spool file and I convert it to a pdf. I then drop it on the IFS. Majority of files are fine, but every now and then it creates a file with 0 bytes and I have to run it again. Anyone have any idea why? I have a spool file and I convert it to a pdf. I then drop it on the IFS. Majority of files are fine, but every now and then it creates a file with 0 bytes and I have to run it again. Anyone have any idea why? IFS Danba https://code400.com/forum/forum/iseries-programming-languages/ifs/159552-rpgle-program-that-converts-a-spool-file-to-pdf-and-puts-on-the-ifs https://code400.com/forum/forum/iseries-programming-languages/rpg-rpgle/159551-httpapi-http_req-error-mch1210-receiver-value-too-small-to-hold-result Mon, 21 Sep 2026 21:39:06 GMT We are storing the result as a string into same parameter size len(16000000) varying.
MCH1210 Receiver value too small to hold result.

I'm assuming the endpoint we are calling the route is getting lost, and causing large data to be returned. The result should never approach something that size.

This seems to be an intermittent issue and unable to reproduce.
Anyone have a good way to trap and log this error?
Are there other functions within HTTAPI that we should be using instead?

]]> RPG/RPGLE AnthonyO https://code400.com/forum/forum/iseries-programming-languages/rpg-rpgle/159551-httpapi-http_req-error-mch1210-receiver-value-too-small-to-hold-result