Error DBIF_RSQL_INVALID_RSQL CX_SY_OPEN_SQL_DB in program
Good Morning Wise People,
I ask you for this type error. I saw by transaction ST22 for this error and I have these possible error causes:
|o The maximum size of an SQL statement was exceeded.|
|o The statement contains too many input variables.|
|o The input data requires more space than is available.|
and also it to point at this statements:
INTO TABLE tl_mtcd_acao
FOR ALL ENTRIES IN tl_perc_fae
WHERE pep IN rl_pep_ran
AND acao EQ tl_perc_fae-acao.
I think that could be the first cause, because:
-the table Z 'zistps_mtcd_acao' has 258 records
-the internal table 'tl_perc_fae' has 57.
-But, the 'Range' rl_pep_ran' has 5747 records. This is the problem I suppose.
My first idea is to separate the condition 'where'. First I'll take records by rl_pep_ran and then I'll take by tl_perc_fae_acao.
Would be correct to face this problem so?
I would appreciate your help.
Thanks in Advance.