topic Re: Native SQL in Application Development and Automation Discussions

Native SQL

Former Member — Wed, 19 Apr 2006 16:51:36 GMT

Hi,

I am using Native SQL statements between the commands EXEC SQL and ENDEXEC to access the external MS SQL server.

I get short dump syaing that the table doen't exist.

The table does exist in the database and i am getting short dump.

I am connecting to MS SQL server using DBCON multiconnect.

I am getting the return code of 0 for the statements CONNECT TO and SET CONNECTION.

But I am getting short dump on SELECT statment for a table.

Can anyone help me?

Thanks,

Ashok.

Re: Native SQL

Former Member — Wed, 19 Apr 2006 17:02:03 GMT

Ashok,

Take a look here:

http://help.sap.com/saphelp_nw04/helpdata/en/2b/b7b339ff52ff3fe10000000a11402f/frameset.htm

Re: Native SQL

Former Member — Wed, 19 Apr 2006 17:08:11 GMT

Can we see the code - both the connect and the select?

Rob

Re: Native SQL

Former Member — Wed, 19 Apr 2006 19:48:40 GMT

Here is the code I am using.

EXEC SQL.

CONNECT TO

ENDEXEC.

EXEC SQL.

SET CONNECTION

ENDEXEC.

EXEC SQL.

SELECT CUSTOMERID, COMPANYNAME into :CID, :CNAME

FROM CUSTOMERS

WHERE CUSTOMERID = :F3

ENDEXEC.

write: / CID, CNAME.

Re: Native SQL

Former Member — Wed, 19 Apr 2006 19:54:27 GMT

Try a SELECT SINGLE (field list) INTO...

Re: Native SQL

Former Member — Wed, 19 Apr 2006 20:06:02 GMT

i AM STILL GETTING THE SHORT DUMP SAYING THAT TABLE DOESN'T EXIST

Re: Native SQL

Former Member — Tue, 14 Aug 2007 04:16:10 GMT

Hi Ashok Narra ,

I am facing the same problem here. If your proble is solved please help me out in this.

EXEC SQL.

CONNECT TO 'AAJ' AS 'V'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'V'

ENDEXEC.

The above statement is not giving any error when i activate it but when i execute it is giving me shortdump error .

I already maintan entries in DBCON table or DBCO t-code

Anees

9886358645