2,862 questions
1
vote
1
answer
51
views
Issue Using JSON_TABLE with CLOB in IBM i COBOL
I am encountering an issue when using JSON_TABLE in IBM i COBOL with CLOB data. Below is an example of the code I am using:
EXEC SQL
DECLARE C_EMP CURSOR FOR
SELECT U.FIRSTNAME, U.PHONETYPE
...
- 11
0
votes
0
answers
40
views
How do I wire up opening a text document in visual studio using Code for IBMi connection
From the following link https://codefori.github.io/docs/dev/api/
I am developing my own VS Code extension and want to interact with the active IBM i connection, so I can use the API provided by Code ...
- 89
2
votes
2
answers
135
views
AS400 - DB2 list all the dataq
Quite new to this AS400. I've tried this code and it works to list all the files:
SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE
FROM QSYS2.SYSTABLES
WHERE TABLE_SCHEMA = 'QGPL'
ORDER BY TABLE_NAME
...
1
vote
2
answers
98
views
SAX XML API program on IBM i ends prematurely after ~889570 records with no error — how to debug and trap errors?
I'm working with an RPGLE program on IBM i (AS/400) that uses the QxmlSAXParser_parse_systemid() API to parse large XML files stored in the IFS.
🔧 Environment:
IBM i v7.3
RPGLE (ILE), compiled with ...
- 21
1
vote
3
answers
265
views
Calling AS400 RPG program with complex Data Structure from a .NET 8 application
I'm working on a business application modernization project where I need to call existing AS400 programs (RPG, CLP ...) from a .NET 8 app.
These RPG programs have I/O parameters with complex Data ...
- 33
1
vote
2
answers
105
views
Why is SNDPGMMSG not showing messages in a subfile when called from a procedure instead of a subroutine in RPGLE?
I'm a beginner learning RPGLE and display files on IBM i. I’ve created a program that displays a message using a message subfile (SFLMSG) when calling a CL program (MSGSFLCL) via a subroutine, and it ...
- 34
0
votes
1
answer
95
views
Iseries, acs and external stored procedures. So where's my LDA?
On our Iseries machine we have a routine which returns some information regarding the status of a third party package, it tells us if it's up or down (it's Sage if you're really interested)
I've ...
- 1
-2
votes
1
answer
67
views
Is there a way to disassemble an IBM i RPG program or module to expose added cycle code? [closed]
I am trying to see what code the RPG compiler adds to cycle-enabled programs to do the implicit reading/writing of primary/secondary files. I tried various DBGVIEW options during compilations but so ...
- 1,274
0
votes
3
answers
366
views
CALL QSYS2.QCMDEXC AS400
I'm trying to run the command from .NET C# using non-query SQL commands on the AS400.
CALL QSYS2.QCMDEXC('CPYSPLF FILE(AUMENTO1) TOFILE(*TOSTMF) JOB(557767/RAB/AUMENTO1) SPLNBR(1) TOSTMF(/REPORTES/...
- 11
0
votes
1
answer
227
views
Change the length of source PF in AS400
I created a SRCPF in an AS/400. It shows the record length as 92. I think this is the default length. I want to increase the length to 112.
After I copied a CLLE program from record length 112 SRCPF ...
- 17
1
vote
1
answer
44
views
I'm trying to update the sequence no of the file after deleteing a record from it in SQL DB2
WITH RowNumbers AS
(
SELECT
ROW_NUMBER() OVER (ORDER BY G TLINE) AS row_num,
gtline, gttran
FROM
GPOTRSP
)
UPDATE b
SET b.gtline = a.row_num
FROM GPOTRSP b ...
- 11
1
vote
1
answer
190
views
Create Signature in Openssl for a JWT for the AS400/iSeries/IBM i
I am struggeling to make a working signature of a certificate which will be used later in a JWT in an RPG-program.
We use this version of openssl: "OpenSSL 3.0.10 1 Aug 2023 (Library: OpenSSL 3.0....
- 129
0
votes
1
answer
64
views
AS400 i5/OS - can a document allways be printed or "spooled"? CPYSPLF?
This is a strange and alien world to me, so please excuse my ignorance!
I have spent quite some time reading up on it, but I still don't really know how to even ask the right questions.
The naive ...
- 1,054
-1
votes
1
answer
138
views
How to display a subfile below a display file format and keep both active [closed]
I have a display file record which has an Identifier. Based on the identifier I am displaying a subfile with a few records. Now I want to accept another Identifier and show the additional records ...
- 21
0
votes
1
answer
147
views
Changing the focus of the cursor to the Subfile Control Option Not Subfile Data Option, While also using RCDNBR
I am a beginner learning RPGLE and working with subfiles. I have attached an image where the red highlighted area is designed using SFLCTL, and the blue highlighted area displays data fetched from the ...
- 34
1
vote
1
answer
164
views
RPGLE error "RNF3438 30 LIKE keyword is expected but not found; definition is ignored."
I am new to programming with RPGLE I was trying to write a simple code to read data from a file and displaying it in the screen. While doing it I get errors:
RNF3438 30 000600 LIKE keyword is ...
- 13
1
vote
1
answer
72
views
On IBM Power Systems / AS400 files are not found in library list when using dynamic SQL
Scenario:
Table 1 is in library lib1
Table 2 is in library lib2
Library List is set as lib1, lib2
When I use dynamic SQL like:
sqlcmd = 'select ''1'' from table1 a join table2 b on a.id = b.id';
...
- 21
0
votes
1
answer
129
views
CL Programming AS400: check fisical file members
Good morning,
with the STRSEU command I should query several physical files in a library and check if among the different fields in the various files there is the field beginning with DT. For each ...
1
vote
1
answer
110
views
Any tool or command to export meta-data from iBM DB2 Webquery to file eg. XML?
Would like to export ALL META-DATA from existing iBM-i DB2 Webquery to file eg. .xml type of file for a client as they want to have their webquery reports meta-data migrated to other solutions. They ...
- 13
1
vote
1
answer
98
views
JDBC ResultSet has more data than selected
I am selecting data from an AS/400 database from different tables using a change indicator. I then export the data to a file and mark the data as exported by updating this change indicator.
While this ...
- 3,038
0
votes
1
answer
179
views
AS400 SQL - Select records from a file where there are unique values based on the grouping of multiple columns
I run an SQL for a user and it work perfect! The code is pretty straight forward delete a table, create a table where we examine coulmn1 & group by coulmn1. Write out to the table any all data ...
- 33
1
vote
1
answer
144
views
Get a message during a submitted job
Hello everyone (first thing sorry for my english, it's not my native language),
I have a basic clle program, the purpose is to count the file total size in a library. At the end the programm should ...
- 11
0
votes
3
answers
181
views
System Power / AS400 - Embedded sql Cursor initial Fetch is slow
On my System Power / AS400,
i'm using embedded sql in an RPGLE Program to write a Subfile.
On a large selection the initial fetch is to slow.
When i scroll the speed is good.
Even though i only select ...
- 21
0
votes
1
answer
116
views
Is there a way to simultaneously change password for numerous user account simultaneously in IBM AS/400?
I am new to IBM AS400. Recently there is a need in my company to implement a 90 days password change for all users. The problem is some users won't change their password even if we already notify them ...
- 315
0
votes
1
answer
190
views
Provide full data on DSPJRN output file
I'm using the command DSPJRN having the parameter OUTPUT(*OUTFILE). One of the output file column is JOESD which contains the specific data for the journal. But the field length is only 100. Is there ...
- 49