| Declare Table ....Semantics [message #338001] |
Sat, 02 August 2008 03:19  |
santosh.chalikwar
Messages: 6
Registered: July 2008
|
Junior Member |
|
|
Hi All,
I am trying to connect with a remote data base using PRO*C.
If I use
proc filename.pc in make file..I am getting no error and code is working fine.
but If I use
proc sqlcheck=semantics userid=abc/lmn@xyz filename.pc
I am getting undefined identifier remoteschema.remotetable name.
user id mentioned in my make file describes my local data base.
At first glance I thought I have to declare this table in my .pc
file.
so I use EXEC DECLARE tablename TABLE
(col name type null,
*******
);
But still I am getting the same error.
Please Help Me.
|
|
|
|
|
|
| Re: Declare Table ....Semantics [message #338005 is a reply to message #338004] |
Sat, 02 August 2008 03:55  |
santosh.chalikwar
Messages: 6
Registered: July 2008
|
Junior Member |
|
|
Thanks for your reply,
But I would like to know whether there is any other way ....
Coz I dont want to change my make file(not passible for some reasons) ..but I can change my .pc file.
One more thing I am using declare table statement but actually it is a synonym (view) created on a remote database table.
So Do I need to change my EXEC SQL DECLARE TABLE statement?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
