Skip to Content
0
Jan 03, 2023 at 06:49 PM

Internal session terminated with a runtime error DBIF_DSQL2_OBJ_UNKNOWN (see ST22)

523 Views

Dear All,

We are having a job which fails sometimes with error: "Internal session terminated with a runtime error DBIF_DSQL2_OBJ_UNKNOWN (see ST22)" and sometimes successful. On checking ST 22 the error is in select query written for fetching the data from People soft system using SQL query in ECC using direct connection tcode DB2.

EXEC SQL.
connect to 'PDR'
ENDEXEC.
EXEC SQL PERFORMING loop_output.
>>>>>>> SELECT
TO_CHAR(EMPLOYEE_KEY) ,
EMPLOYEEID ,
LASTNAME

Can somebody kindly guide how the issue can be resolved?

Regards.