|
||||
|
This document presents a sample query that, when run using the SOS-supplied DBISQL utility, produces an EXCEL file that can be used as the data to produce a set of mailing labels in MS Word. There is a document on the SOS web site that describes how to run queries: http://www.sosoft.com/queries/how2010/ Specifically, it selects from […] Normally when you open the DBISQL query utility, you must provide your SOS User ID, your password, and select the data source: Because of the potential security risk, you would not want to default values for your ID and password, but it would be a convenience if there were a way to automatically select […] At times it is desirable to batch claims according to a particular payor or payors. Examples include: Generating a batch of Medicare paper claims using the Medicare-specific formats. Generating electronic claim submission files for just selected payors. The most efficient way to proceed is by using the Carrier Category setting on the Additional tab of […] A Microsoft Linked Server can be created that uses the SQL Anywhere OLE DB provider to obtain access to a SQL Anywhere database. SQL queries can be issued using either Microsoft’s 4-part table referencing syntax or Microsoft’s OPENQUERY SQL function. An example of the 4-part syntax follows. SELECT * FROM SOSDATA..SOS.Patients In this example, SOSDATA […] The following instructions are specifically for SOS Release 2010 and later. First, it is necessary to configure your user ID in the Admin Module (Users and Passwords) to allow access from 3rd party products (Access tab option “Grant read-only access from non-SOS products”). If you are not cleared for this type of access, you […] The upgrade to SOS 2010 is quite similar to previous SOS upgrades that you may have done. It does, however, replace your older Sybase database components with newer versions. In some cases that change will require a couple of post-installation steps, which are detailed below. All Installations, Including Network Workstations You may find that one […] The following recommendations should deliver adequate performance in each indicated category. If your implementation is particularly demanding, you want better than just “adequate” performance, or your database is large, you should increase both RAM and processor speed to compensate. Simultaneous usage of resource-hungry applications such as Microsoft Office also demand more RAM. Windows 32 […] The information in the Backing Up Your Data article is quite sufficient for most installations. The current document discusses advanced topics that will be of particular interest to those running the system in larger organizations with high data entry volume. The following topics include how to recover data entered since the most recent backup and […] Complete Sybase documentation for Sybase SQL Anywhere (SA) can be found by selecting Sybase Manuals on the Help menu in Office Manager (OM), Case Manager (CM), or Appointment Scheduler (AS). Alternatively, select Start > Programs > SOS Applications > Sybase Manuals. There are actually three SA guides: SQL Anywhere Server SQL Usage, which includes an […] Nothing that you do on your computer in the course of a day — or for that matter, a month — has anywhere near the significance of your backup procedure. A good backup will someday mean the difference between a minor inconvenience and a very costly disaster. It is only a matter of time before […] |
||||
Print Friendly