Skip to Content
0
Former Member
Feb 18, 2014 at 10:53 AM

Reference Table Queries

77 Views

Hello,

I have created a project with a reference table query. I have installed HANA ODBC client and it works perfectly with another project which has HANA Output Adapter.

The CCL file contains :

CREATE INPUT STREAM reciever

SCHEMA (id integer, pos integer, datatype string);

CREATE REFERENCE maptabRef

SCHEMA (id integer, pos integer, datatype string)

PROPERTIES service='ND7ODBCService',source='maptaba', sourceSchema='M2M';

CREATE OUTPUT STREAM outputStream

SCHEMA (id integer, pos integer, datatype string)

AS SELECT maptabRef.id, maptabRef.pos, maptabRef.datatype

FROM reciever, maptabRef

WHERE reciever.pos = maptabRef.pos;

But when I am trying to run the same it gives following error:

Failed call to:http://localhost:56105/RPC2 (Failed to read server's response: Connection refused: connect)

Can somebody tell what could be the reason for this.

Thanks,

Gaurav Singh