In a very simple SQL SELECT run by DBSQLPR JCL:
SELECT *
FROM DIR_TABLE
;
the result is condition code 0020 due to a syntax error:
INPUT STATEMENT:
SELECT * 00520140
FROM DIR_TABLE 00520240
;
___________SQL ERROR SUMMARY START___________
SQLCODE = -20, SQLSTATE=42601
MESSAGE = BAD SYNTAX: <00520140>
WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED:
SELECT * SELECT * 00520140 00520140
FROM DIR_TABLE
____________SQL ERROR SUMMARY END____________
The SQLCODE = -20 error refers to some sort of syntax error in the submitted query.
The syntax error is due to the sequence numbers in the source. The clue is in the "00520140" which shows that the input has sequence numbers in positions 73-80.
There is no need to edit and remove the sequence numbers. You can provide the DBSQLPR parameter INPUTWIDTH=72. INPUTWITH is used to limit the length of the input of the DBSQLPR control cards that are processed.
For more information about using the batch DBSQLPR program, refer to the documentation topic "DBSQLPR Utility—Execute SQL through Datacom/DB."
As always, please contact Broadcom support for Datacom if you have further questions.