python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - ibm-midrange

How to process a SUBFILE using For Loop with a CHAIN rather than using READC and SFLNXTCHG

How to process a SUBFILE using For Loop with a CHAIN rather than using READC and SFLNXTCHG. Readc along with the Sflnxtchg option sometimes becomes a bit complex to understand , I have heard that inst...
test-img

Kunal Roy

ibm-midrange

rpgle

Votes: 0

Answers: 1

Latest Answer

A simple example of the declarations and loop you would use would be: FMYDSP CF E WORKSTN SFILE(SFLREC01:sflIndex) D sflIndex S 4S 0 D s...
test-img

Mike

iSeries SQL - Getting and updating directory entries

We are looking to change the address part of all the users directory entries. Has anyone accomplished anything similar? Looking to see if there are any tables that hold this information, along the l...
test-img

geojf3

sql

ibm-midrange

Votes: 0

Answers: 1

Latest Answer

You can read the directory entries in this table qaok102a. select * from qusrsys.qaokl02a; Do not update the table directly and use system commands to make changes as you suggest in your post.
test-img

Scott Mildenberger

Java 8 Time API - DB2/400 / JT400

I'm currently upgrading an application that uses DB2/400 database, and I'm migrating to the new java time api (LocalDate, LocalTime, ...), using the latest version of jt400.jar. However, when executin...
test-img

areal

jdbc

ibm-midrange

java-time

db2-400

jt400

Votes: 0

Answers: 1

Latest Answer

You must use java.sql.date with JDBC. Convert with : java.sql.Date.valueOf(LocalDate.now());
test-img

Dam

How to prevent IBM i from changing the library of an external stored-procedure when moving external program to a different library

I've noticed that the IBM i will automatically change the library of an external stored-procedure to match the library of the external program when the program is moved. Is there a way to stop that? ...
test-img

HockChai Lim

ibm-midrange

Votes: 0

Answers: 1

Latest Answer

You should open a support case with the vendor. I suspect there's a way to define the stored proc to your CMS, so that it manages it along with the external program.
test-img

Charles

Posts

Questions

Blogs

Jobs