Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

When using SAS/Access Interface to Sybase with SAS V8.2 and attempt to
update a table, you may receive the following errors:

ERROR: Error in results set for Update. Error Code: -556 The table
referenced in the UPDATE/DELETE WHERE CURRENT OF is not part of the
result set tables of cursor 'C2c21e78'.
ERROR: MEMBER level locking for UPDATE or RANDOM access is not supported
by this engine.
ERROR: PROC SQL could not undo this statement if an ERROR were to happen
as it could not obtain exclusive access to the data set. This statement
will not execute as the SQL option UNDO_POLICY=REQUIRED is in effect.

It appears that for update, the engine is not honoring the database=
option.  All works OK with no database= and the table being referenced
is in the user's "default" database.

The libname and dataset options dblink and schema, are used as a way to
point indirectly to another database and/or another schema's objects.
An example would be:

  libname x sybase user=joe pass=brown dblink=test schema=frank;

This will print out the table test.frank.foo.  User "frank" must have
given select permission to "joe" for this to be successful.

  proc print data=x.foo; run;

  libname y sybase user=joe pass=brown dblink=test;

This will print out the table test..foo2, which belongs to user "joe" in
the test database.  Assume that user "joe" has a default login database
other than "test".

  proc print data=y.foo2; run;

Use of the database option dictates that the connection actually connect
to the specified database name pointed to be the option, thus making all
objects to that connection local.  Use of schema will qualify the
objects referenced with the user level quali fier.  An example would be:

  libname z sybase user=joe pass=brown database=test schema=frank;

The table referenced will be frank.foo, because user "joe" is logged
into, (using) the "test' database.

  proc print data=z.foo; run;



A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#010317

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: