Problems with an INSERT with embedded SQL

[user13482104]

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...

[deep]

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....

[Carpiem]

Hello all,

I'm puzzled why REGEXP_COUNT returns weird results, for example take this query:

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...

[Luca Altmann]

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:

**free
Ctl-Opt BndDir('QICU/QXICUAPIBD');

...

[Luca Altmann]

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:

**free

...

[sri8707]

I have a DS defined as below -

D MyDSArr DS qualified dim(999)
D MyDsKey
D field1 10A overlay(MyDsKey:*next)
D field2 ...

[RPGnewbee]

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...

[Luigi Brito]

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...

[IBMiRookie]

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....

[sri8707]

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...

[RBlanco]

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]

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...

[jason.aleski]

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...

[KevinStaples]

I am needing a really simple way to convert an integer to ASCII hex in RPG.

[CaptainRon]

So I have a Data structure array. I can sort on one field using the SORTA command with %subarr. Can I add another field WITHOUT combining the two fields together in a one field sort? To basically sorting on two fields or three etc..... Again without combining into one field. If I can in SQL do you...