Results 1 to 2 of 2

Thread: Error 999?

  1. #1
    Join Date
    Jul 2003
    Location
    Italy
    Posts
    5

    Unanswered: Error 999?

    Hi to everybody!
    I have found a strange situation in my informix databases...
    I'm trying to do a simple select from a database using a table of another database.
    For example my current database is database1 and i want to do an operation like this:
    select * from database2@istance2:table1

    All i have is this result:

    -- Executing all SQL statements in Untitled.sql.
    select * from database2@istance2:table1;
    -- [Informix][Dynamic Server 2000][database1] SQL Error (-999) : Not implemented yet.

    It's not a problem of grant...
    The strange thing is that i have no problem using every other tables in database2. So i can do a select * from database2@istance2:table2...

    Is there anybody who know the reason of this strange situation?
    Thank you!
    Last edited by kioda; 08-06-04 at 06:28.

  2. #2
    Join Date
    Jul 2003
    Location
    Italy
    Posts
    5
    I have found the solution...
    When you have a column of lvarchar type you cannot do a remote select...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •