Has anyone tried using a clob field inside of SQL?
I'm moving the data from the YAJL copyBufStr function into a clob variable.
Once I try to use the clob variable inside the SQL statement I get the error below.
Length in varying-length, LOB, or XML host variable...
29 results in 0.0027 seconds.
-
Using Clob Fields in SQL
-
deep started a topic Client Authentication at IWS- How do you do it ?? basic auth/mTLS/Trust token ??in RPG/RPGLEClient Authentication at IWS- How do you do it ?? basic auth/mTLS/Trust token ??
Hi ALL
How do you do client authentication at IWS ?? We use basic auth and mTLS. But, mTLS is quite slow and we are exploring moving to a E2E trust token(SAML3/JWT) based authentication.
However, for doing a trust token-based authentication, we will need to use Transport-C... -
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... -
Is IBMi IWS impacted due to log4J vulnerability
Hi
I could not find any information about IBM-I IWS vulnerability due to Log4J. We use IWS and wanted to know if it used apache Log4J logger and hence whether it is vulnerable. Appreciate any help.... -
Why REGEXP_COUNT returns a wrong value?
Hello all,
I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:
PHP Code:select regexp_count('1','[A-Z]')
from SYSIBM.SYSDUMMY1
Regular expression [A-Z] means it accepts a letter from A to Z. But 1 is no letter, and the result of... -
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 ... -
RPGnewbee started a topic Is there an API through which I can get a list of what program calls what?in CLP/CLLEIs there an API through which I can get a list of what program calls what?
I am trying to create my own impact analysis tool in order to get a command over CLLE and RPGLE. I have looked this up in forums but couldn't get an answer.
Is there a way, wherein I enter a full or partial program name and would get an outfile populated with the program name and what... -
Most common enterprise software to learn in IBM i?
6 yr IBM i (as400/powersystem) developer/analyst here.
Just a thought/question for senior members. Learning EDIs, RPGLE, and FTP/sFTP (anything under native IBM i) is one thing, learning the enterprise software that a company uses to achieve such things is another. BPCS and Infor LX just...Last edited by Luigi Brito; July 6, 2020, 04:26 AM. Reason: added tags so it's not a random post or anything -
SQL static View shows as a Logical File - recompile considerations
Hello,
I am a new IBMi programmer working in small shop with primarily legacy code. As part of our efforts to modernize, we want to take advantage of SQL static Views when creating reports that use sets of data. I created a SQL static View that uses fields from 4 different Physical Files.... -
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... -
TCP7531 unmonitored by YAJLR4
I need help to find out why YAJLR4 is producing the TCP7531 error "All data provided was not successfully written to STDOUT.".
The YAJLR4 statement line contains:
QtmhWrStout( %addr(Headers) + 2 : %len(Headers) : errorCode );
I created an IWS REST service... -
thebkline started a topic Vendor's Service Program Procedures Don't Work in My Service Program Procedurein RPG/RPGLEVendor's Service Program Procedures Don't Work in My Service Program Procedure
Yes, I'm sure that subject confused some of you. I don't know how else to sum up the issue I'm having. Here is the longer version:
Background: We use a third-party IBM i SDK that translates and makes a REST API call. By translate, I mean that we load up a bunch of data structures and... -
Too much input for one screen
I've been tasked with modifying a display file that is already jammed with input. Basically I have an asset with a ton of attributes (not a subfile). I've added the appropriate fields to the data file, but when working on the display file, I just don't have enough room. I think the best approach...