Skip to content
This repository has been archived by the owner on May 31, 2021. It is now read-only.

Spool File List not working #111

Open
mhjbuit opened this issue Feb 25, 2019 · 1 comment
Open

Spool File List not working #111

mhjbuit opened this issue Feb 25, 2019 · 1 comment

Comments

@mhjbuit
Copy link

mhjbuit commented Feb 25, 2019

I receive message No spool files found while there are spoolfiles available.
In the session FTP Log the following is displayed:

Command:  RCMD RUNSQL SQL('CREATE TABLE QTEMP/SPOOL AS (SELECT Char(SPOOLED_FILE_NAME) as a, Char(COALESCE(USER_DATA, '''')) as b, Char(JOB_NAME) as c, Char(STATUS) as d, Char(FILE_NUMBER) as e FROM TABLE(QSYS2.OUTPUT_QUEUE_ENTRIES(''QUSRSYS'', ''MABU'', ''*NO'')) A WHERE USER_NAME = ''MABU'' ORDER BY CREATE_TIMESTAMP DESC FETCH FIRST 25 ROWS ONLY) WITH DATA') COMMIT(*NONE)
Response: 550 Cause code is SQL9010; message text not available.
Response: 550-Error occurred on command RUNSQL SQL('CREATE TABLE QTEMP/SPOOL AS (SELECT Char(SPOOLED_FILE_NAME.

@EwellBMyne
Copy link

I have the same issue with the newest version. I did not have a problem before the upgrade.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants