topic Re: table from sqlserver to maxdb in Application Development and Automation Discussions

table from sqlserver to maxdb

Former Member — Wed, 11 Jun 2008 03:15:36 GMT

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

Former Member — Wed, 11 Jun 2008 03:22:12 GMT

Hi,

See the theards, it may help u

Regards

Kiran Sure

Former Member — Wed, 11 Jun 2008 03:33:09 GMT

more information

Database error text........: "POS(338) Too complicated SQL statement (too much data)"

Former Member — Wed, 11 Jun 2008 05:03:21 GMT

SAP Note No. 1001257