Search found 7 matches
- Wed Mar 13, 2024 10:04 am
- Forum: General
- Topic: Trouble exporting text data to pc file in pure ascii (CCSID issue?)
- Replies: 1
- Views: 790
Trouble exporting text data to pc file in pure ascii (CCSID issue?)
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...
- Thu Sep 21, 2023 8:23 am
- Forum: RPG IV
- Topic: UDTFs based on sqlrpgle programs performance issues
- Replies: 3
- Views: 6813
Re: UDTFs based on sqlrpgle programs performance issues
Scott, thanks for your reply and suggestion.
I think you were being ironic about pivot tables
I think you were being ironic about pivot tables
- Wed Sep 20, 2023 3:59 pm
- Forum: RPG IV
- Topic: UDTFs based on sqlrpgle programs performance issues
- Replies: 3
- Views: 6813
UDTFs based on sqlrpgle programs performance issues
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...
- Wed Apr 19, 2023 9:10 am
- Forum: General
- Topic: Change CCSID system value from 65535 to 1208 (UTF-8)
- Replies: 2
- Views: 8239
Change CCSID system value from 65535 to 1208 (UTF-8)
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....
- Mon Apr 03, 2023 9:00 am
- Forum: YAJL-ILE
- Topic: YAJLINTO with object array throwing reason code 9 error
- Replies: 8
- Views: 9364
Re: YAJLINTO with object array throwing reason code 9 error
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.
- Wed Mar 29, 2023 9:48 am
- Forum: YAJL-ILE
- Topic: Providing a swagger for a rest service
- Replies: 3
- Views: 6920
Re: Providing a swagger for a rest service
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...
- Tue Mar 28, 2023 9:15 am
- Forum: YAJL-ILE
- Topic: Providing a swagger for a rest service
- Replies: 3
- Views: 6920
Providing a swagger for a rest service
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 ...