scottklement.com

Hi all
The problem was in RPGLE ctl-opt "ACTGRP(*NEW) "
Runnig dspjob from 5250 i have found :


"Message ID . . . . . : CPF426A
Sent Date . . . . . . : 07/04/26 Sent Time . . . . . . : 12:16:36 PM Message . . . : The user-defined function ZGIACART_Z cannot be called.
Cause . . . . : An external ...

Hi all
I'm plyaing with UDFx
I have registered ths UDF

CREATE OR REPLACE FUNCTION mylib.ZGIACART_Z (
CODART VARCHAR(17) ,
DATARIF decimal(8, 0)
)
RETURNS TABLE (
mag char ( 2),
art char ( 17),
cau decimal ( 3 , 0),
GIACENZA DECIMAL( 15 , 3)
)
LANGUAGE RPGLE
PARAMETER STYLE DB2SQL ...

Hi all
In a job, sometimes I have a problem with a record that remain locked and so i get CPF5032 "Record already locked to this job ;
how i could find the program that take locked the record ??
Keep in mimd that this file is under commitment control ..
Thank in advance

Hi all
i'm try to use exectp to access to sFTP server
i wrote this script to list content folder, but it seems that the "cd" command don't work
this my script

#!/usr/local/bin/expect -f
set REMOTE_DIR "/cert_xxxx_name/in"
spawn sftp cert_xxxx_name@111.22.333.xx
expect "Password:"
send "mypsw\n ...

hi all
until today in our Web Server config, we have insert thsese directives:

ScriptAliasMatch ^/rest/(.*) /QSYS.LIB/MYLIB.LIB/$1.PGM
<Directory /QSYS.LIB/MYLIB.LIB/>
Order allow,deny
Allow from all
SetEnv QIBM_CGI_LIBRARY_LIST "QTEMP;TESTLIB;MYLIB"
</Directory>

doing some test/debug, we have ...

Hi all
i would need to execute SQL statement (in RPGLE program) that join a IBM i Table with a MySql table that is stored in a external data base (windows server) ...
in your opinion is it possbile ??
Thanks in advance

I have configured an http SERVER and deployed a web service for test; it
works fine.

Now i would like to learn and test how use "Basic Authentication"; can some
one suggest some links how to do that, i found this documet
https://www.itjungle.com/2024/08/12/guru-creating-a-web-service-with-basic-a ...

Hi
solved .. the Json was wrong
in postman i tried with this Json and now it works
Thanks
Gio

Hi all
i'm try to play with example at page 178 of https://www.scottklement.com/presentations/REST%20APIs%20and%20RPG.pdf;
i configured HTTP Server
i have created a simple progam the try to read a JSON Input Message


dcl-s loaded ind inz(*off);
// dcl-ds cust qualified template;
dcl-ds cust ...

Hi all

I'm looking for a way to remove from a string some characters : Ex.

String = "A.b-,c%d'" i would be get "Abcd"

Thanks in advance

Gio