scottklement.com

Hello everyone, this is my problem. I have a program that writes a physical file. The physical file has 4 char fields. The file must be downloaded in pure ascii txt format and then uploaded via ftp to our IRS systems. In one of the 4 fields it can sometimes happen that there are accented capital vow...

Scott, thanks for your reply and suggestion.
I think you were being ironic about pivot tables

Hi everybody, I am in the need to build a pivot table from a bunch of different tables (tables non pf-dta since they are generated via ddl and not by dds). To reach my gol i was thinking to build a UDTFs recycling some already existing rpg routine we use on such tables. In the example provided by Sc...

I've already posted this message in other forums but without too much luck getting any response, I'm posting it again here hoping someone can give me some help on how to proceed with this issue. I have a system that always has as system values QCCSID equal to 65535 and as a QCHRID value: - Font IDs....

I had a problem like your in the past, my solution was to fill the array of all the values coming from the json, also the null, and then "clear" (simply setting up to the default allowed for the data type) the nulls before inserting the values in the db table.

Thanks Jon e Scott for your reply. @Jonboy49, i gave a quick look to the swagger inspector, it might work but requires the time to test all the methods within the api, and has not the capability to understand if a method is get or post or whatever, the user must tell which verb is used by a given me...

Don't know if this is the right forum to ask for assistance, if i chose the wrong one i ask your pardon. Few years ago I built up a rest api on my IBM i box to provide few services for my company website. Requesting customer info and order status and other stuff like that, very simple to do since i ...