06-11-2008 4:15 AM
hello expert
i met a strange issue about sql expression.
SELECT * FROM /smb/sb_t_004
INTO TABLE ldt_pa_hdr
FOR ALL ENTRIES IN ldt_filename
WHERE soluid = p_sol_source
AND filename = ldt_filename-filename.
the table /smb/sb_t_t004 is defined in development system, but the database server is sql sever.
the test is okey. but after transported into QA system , which is connected with MAXDB server. but the test is short dump.
i don'g why that occurs.
following is information
Short text
SQL error in the database when accessing a table.
Looking forward to your reply
Best Regards,
Kevin
06-11-2008 4:22 AM
Hi,
See the theards, it may help u
https://forums.sdn.sap.com/click.jspa?searchID=12748275&messageID=5464235
https://forums.sdn.sap.com/click.jspa?searchID=12748275&messageID=5464631
Regards
Kiran Sure
06-11-2008 4:33 AM
more information
Database error text........: "POS(338) Too complicated SQL statement (too much data)"
06-11-2008 6:03 AM