APAR FIX FOR LAN ACCESS 1.1.1 - IX77531:

PROBLEM:

THE SUPPLIED SCRIPT FROM LAN ACCESS 1.1.1 TO ENABLE INVENTORY SUPPORT
DOES NOT WORK WITH SYBASE. VIEW CANNOT BE CREATED.

SOLUTION:

Create a new script to be run for sybase databases. This script
called create_os_detail_view_sybase.sql is created by removing the ; and  
replacing them with go statements in the original script, create_os_detail_view.sql. 
The original script, create_os_detail_view.sql, is still required for other databases.  

1)Refer to the LAN Access 1.1.1 release notes to see when the script should be run.
2)The script create_os_detail_view_sybase.sql should be run for sybase TME 10
  Inventory RDBMS databases. The script create_os_detail_view.sql should
  be run for all others.