I have a rpgle client trying to call DB2 JDBC procedures in a service program. None of my procedures are being found. I have a code example but no procedure is binding to the client.
For example: The getBytes is not found. I did a crtsrvpgm with export *all.
---------------------Client...
75 results in 0.0031 seconds.
-
Trouble with RPGLE Binding
-
Problems with an INSERT with embedded SQL
Hello dear community,
I'm currently having trouble with an insert. I can't get an insert. In the debug I saw that the SQLCOD was set to -7008 (object-name NOT VALID FOR
OPERATION (reason code)). I've attached an image. Can someone tell me what I'm doing wrong? I create the file in QTEMP... -
Decoding Base64 data does not return the original string value
What I'm supposed to do is read a base64 encoded value
eyJzb3VyY2UiOiJDQ0RWIiwidHJhY2VpZCI6IjNiM2MxZDZjZT U2Y2QxZTBkNThlNDA4NDY2YWVkZWE3In0=
from a field in a database file and decode it to obtain the original JSON statement
{"source":"CCDV","traceid":"3b3c1d6ce56cd1e0d58e40 8466aedea7"}... -
Getting a MCH6206 Return Code 4 error
I got a MCH6206 "Commitment control resource limit overflowed. Return code is X'04'." in one of my batch jobs today.
The batch program opens 2 files in commitment control. File1 is opened for update under commit and File2 is opened for addition under commit.
The flow of the program... -
Encode pdf file
I have to consume a fedex web service within an ILE RPG procedure, where I should indicate the commercial electronic document in binary format. The electronic document is available in pdf format on the IFS. How can I convert this file to a binary string to be included in the XML specification? A code... -
Vary Configuration User Exit Program
I am looking for some examples of a exit program for the QIBM_QDC_VRYEXIT. Specifically, I want to start/stop my applications running on an iASP when the iASP is varied on or off. Any input would be helpful. -
IFS Open - Authority Issue?
Hello, thanks in advance for any guidance. I am using the Open API in an RPGLE program (shown below), if the file is not in the IFS the open should create the empty file. We have 2 users where the FD returns as -1. Other users work correctly, FD returns as 0. All authorities appear to be identical... -
Calling ICU APIs from RPG
I'm trying to call an ICU APIs from RPG but can't get it running and i think its due to parameter mismatch.
https://unicode-org.github.io/icu-do.../uidna_8h.html - API "uidna_IDNToASCII()"
My code looks like following:
...Code:**free Ctl-Opt BndDir('QICU/QXICUAPIBD'); -
Calling ICU APIs from RPG
Hello *ALL,
I'm trying to call an ICU APIs from RPG but can't get it running and i think its due to parameter mismatch.
https://unicode-org.github.io/icu-do.../uidna_8h.html - API "uidna_IDNToASCII()"
My code looks like following:
...Code:**free
-
Sorting multiple DS fields
I have a DS defined as below -
D MyDSArr DS qualified dim(999)
D MyDsKey
D field1 10A overlay(MyDsKey:*next)
D field2 ... -
jason.aleski started a topic Prepared SQL for Single Row into Data Structure; without cursor. Possible?in RPG/RPGLEPrepared SQL for Single Row into Data Structure; without cursor. Possible?
I am attempting to use a prepared statement to fetch information (a single row) about a location; based on a given ID. The location ID is either passed via parameter, or directly entered and read from the display/user interface.
I have tried stepping through the RDi debugger. I see the... -
get first day of month and first day of prev month
I'm sure this is on here somewhere I just cant find it, I need to get first day of month which I think is firstDay = todayDate - %Days(%subdt( todayDate:*days)-1);
but if today is the first of month I need to get the prev month first day of month, the job I'm running uses previous day for its... -
How to compare 2 data structures field by field?
I would like to compare 2 DS field by field and capture the changed fields into an audit file. Below is the scenario -
User is provided with a display screen where he can change any of the 20 fields pertaining to a file. Say if the user changed 10 fields, I want to write 10 records into... -
Serialize data structure to JSON
Hello,
recently my company has been using web services to decouple our very very old legacy system into more modern micro-services linked by API's. We have created a our own JSON parser to to tokenise the input JSON message string and map it to a corresponding data structure using the new... -
CREATE FUNCTION (External) - Which Subprocedure?
Something I'm not clear on - In reviewing the syntax for CREATE FUNCTION (External), I know I can specify that the external procedure to be run is a subprocedure in a service program, and where to specify the service program.
However, I don't see where to specify the name of the actual...