Re: SQL Scripts in ACS

To get round this I was issuing DELETE in the SQL window then *ADD instead
of *REPLACE in the CPYF.

Had the idea to try CL:CLRPFM in the sql window, then the CPYF on the
green-screen failed with :
ID message . . . . . . : SQ99999 Gravité . . . . . . . : 30

Type de message . . . : Diagnostic

Date d'envoi . . . . . : 24/03/21 Heure d'envoi . . . . :
14:23:05


Message . . . . : Une erreur s'est produite dans l'interface CLI SQL.

Cause . . . . . : Erreur lors d'un appel de procédure. Le code
correspondant
est 10. Les codes d'erreur sont les suivants :

3 -- Type de programme hors de la plage admise.

4 -- Type de données SQL hors de la plage admise.

9 -- Valeur d'argument incorrecte.

* 10 -- Erreur de séquence de fonction. *


*In the end, I just did cl: cpyf in the sql window. I guess there is some
logic there as the green screen and sql windows are being run by 2
different jobs. *

Hi all,

I'm testing a program on an ACS 5250 emulator screen. I switch to a SQL
script window to view some results. When I go back to the green screen,

I

can't continue to test because my program is trying to do a CLRPFM and

the

job running the SQL scripts has locks on the files that I previously
consulted.
I would have thought this was a bug. Can anyone help?