2,857 questions
0
votes
1
answer
59
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
0
votes
1
answer
58
views
ISeries RPGLE simulate keystrokes
In a RPGLE I'm receiving information from a PC program, to prompt the program the user has to press Ctrl-Alt-A. Before that can be loaded they use F2 to clear the fields for the data to be entered ...
-1
votes
0
answers
57
views
Program keep hitting CPF5032 error in rpgle
I have to do a testing for this program(create by my senior). Basically this program is a patching program, the only thing this program do will check the record and then update the file with a new ...
- 1
-2
votes
1
answer
38
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,264
2
votes
4
answers
96
views
RPG: begsr vs dcl-proc
I made small change in program that sends program messages (SNDPGMMSG) to message subfile in RPG program. Change was converting subroutines to procedures.
I changed one subroutine to dcl-proc from sub-...
- 89
0
votes
3
answers
74
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
3
answers
59
views
RPG DDS screen - capture function key (F1, F05) value
I am having trouble capturing value of function key pressed in RPG screen.
Here is essential code...
dcl-f SF_04D workstn infds(infds1) sfile(SFL1:RRN) ;
dcl-c F1Key const(x'01');
...
- 89
0
votes
1
answer
82
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
0
votes
1
answer
77
views
Print 'NO RECORDS FOUND' for empty SQL table
I have a table I create via SQL on an AS400 and the SQL and table creation runs without error. The input files will always have data but after the SELECT is applied the output file could be empty/null/...
- 33
1
vote
1
answer
37
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
2
answers
95
views
QSYS2.HTTP_GET command, can't figure out Proxy and Headers configuration
The problem
I am trying to use SQL to do a GET request on the IBMi. The URL I am trying to query is the one that is in the documentation : 'https://www.ibm.com/support/pages/sites/default/files/inline-...
1
vote
1
answer
103
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....
- 111
0
votes
1
answer
44
views
Getting As400 Job Percent CPU Utilization using jt400
I am trying to fetch cpu % using jt400, however I am getting cpu % as zero for all the jobs? Can someone pls help here? Below is the code for reference.
JobList list = new JobList(as400);
list....
- 11
0
votes
1
answer
46
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,044
1
vote
0
answers
44
views
How can I detect use of a remote queue definition?
We have lots of old channels and queues that I suspect are not being used. In the case of remote queue definitions, how can I, from the MQ side, determine whether they are in use?
It seems that all ...
- 689