% comments & ISQL operator * metacharacter *= left outer join + concatenation - metacharacter -- comments . metacharacter .dbg file .RTF /* comment */ /* comments */ // comments /p library 1998 conference 3-valued logic = versus *= =* right outer join > ISQL operator >= versus > >> ISQL operator >> Java qualifier @@identity @@procid @@servername @@spid @@version [ ] metacharacters \ metacharacter abstraction AcceptText() access violation accidental polymorphism activate Adaptive Server Anywhere Adaptive Server Enterprise address ADDRESS adhoc tool alias name ALTER DBSPACE ALTER TABLE alternate key any data type argument arithmetic array array function array subscript artificial key ASA ASAConnection ASC ASCII value assignment attribute auto incrementing auto load painter Auto-Creep AutoCommit = true AUTOEXEC.BAT AutoIncrement AUTOINCREMENT AutoIncrement AutoInstantiate AutoSize backup banish NULLs! batch batch mode begin transaction blind key BLOb blocked connection BlockedOn property Breck Carter business column cache CALL cartesian product cascaded delete cascaded keys cascading key change case expression case sensitivity cast cast() catalog char char ( 8 ) char_length() character code characteristic error checkpoint urgency class ClassName() clicked client server clipboard() code table Coleman Sisson collate column column name column number column number is not valid command line parameter comments COMMIT commit commit transaction CommLink property compareTo complexity COMPUTE compute_nnnn computed column computed field concatenation concurrency conference confirm_received confirm_sent ConnCount property connect Connection connection Connection_Property() ConnectOption consistency consolidated database constructor consultant consulting contention context ID context number contract contractor convert() convert_date_time function convert_fraction function convert_volume function copies correlated sub-select correlated subquery correlated subselect COUNT(*) counting CPP create CREATE DBSPACE CREATE FUNCTION CREATE INDEX CREATE PUBLICATION CREATE REMOTE MESSAGE TYPE CREATE REMOTE TYPE CREATE SUBSCRIPTION CREATE TABLE CREATE VARIABLE creator cross-server query CumulativeSum() CURRENT DATE CURRENT PUBLISHER CURRENT REMOTE USER current row CURRENT TIME CURRENT TIMESTAMP current user CURRENT USER CurrentRow() cursor cursor fetch loop custom class d_dictionary d_prof_trace data dictionary data type DataObject DataSource() DataStore DataWindow date date arithmetic date datatype date() dateadd() DateFormat() datetime DateTime() day() DaysAfter() DB_name() DB_Property() DBCLIENT DBDemo.java dbeng50w.hlp DBError DBErrorCode() DBErrorMessage() DBINFO DBINIT DBINIT -p DBINITW DBISQL DBLIB DBLOG DBParm DBREMOTE DBREMOTW DBSRV50 DBSRV50 -gp DBSRV50 -x DBSRV6 DBWATCH DBXTRACT DDDW DDL DebugOutFile decimal declare cursor declare procedure deep copy DEFAULT DEFAULT AUTOINCREMENT DEFAULT CURRENT PUBLISHER default printer DEFAULT TIMESTAMP default timestamp DEFAULT TIMESTAMP defer until commit delete delete from from DeleteRow() denormalization DESC Describe() destroy dialog box dictionary DisableBind disaster disconnect disk fragmentation DiskRead property DiskWrite property distinct documentation() DOS environment dot notation DriverManager drives DROP DBSPACE DROP INDEX DROP TABLE DropDownDataWindow DropDownListBox dump transaction dwObject DWObject DWobject dwsyn40.exe DWSyntax dynamic SQL DynamicStagingArea Dynamo eDict EI embedded SQL employee EN_CHANGE enabled entity environment variable error error checking error code error message ERwin EVALUATE evaluate() event argument event id event name execute immediate execution profiler exists EXISTS exists versus count(*) expecting NUMBER export expression is not valid f_check_for_block() f_clipboard() f_data_error() f_get_environment_variable f_get_next_surrogate_id f_last_date_in_month f_prof_xxx f_prompt_before_printing f_sum_arrays() fan-out fetch fields FILE filter() find-and-scroll FirstRowOnPage fishhook fixed-format text file flag, row flat file floating point font, script painter font, Wingdings footer band foreign key forensic programming Format 3 SQL Format 4 SQL fragmentation frame from clause from dummy Full Compares/sec. FullCompare property function function, SQL gateway ip GDI, % free GetChild() GetClickedColumn() GetClickedRow() GetColumnName() getdate() GetDOSEnvironment GetFreeSpace() GetItemNumber GetProfileStringA GetRow() GetSelectedRow() GetSQLPreview() GetText() global variable grant GRANT CONNECT GRANT CONSOLIDATE GRANT PUBLISH GRANT REMOTE GRANT REMOTE DBA group GROUP BY guo_app header header band HelloWorld HelloWorld.java help file help topic hexadecimal hidden window hierarchy highlighting hosts file HP Laserjet HTML HTMLTable! HWND_BROADCAST identity identity column IF EXISTS IF EXISTS...DROP if expression if-then-else-endif IfNull() import ImportFile() income tax independent contractor index index column placement IndexDemo insert INSERT INSERT SELECT InsertDocument() InsertRow() INSTALL JAVA integer integrity constraint intelligent key Intersolv invisible ip address IsNumber() ISQL ISQL batch mode ISQL PLAN> ISQLW IsValid() ItemChanged ItemFocusChanged Java JAVAC JavaScript jConnect JDBC JDK join join operator K.I.S.S. keyword krnl386.exe label Laserjet last date in month last user LAST USER LastRowOnPage leak left outer join left() Left() length() LibAll library library painter LIKE LIKE versus SUBSTR line number load load table LOAD TABLE localhost locate() lock locks log log file log_received log_sent logic, 3-valued long binary long varchar long() LookupDisplay() Los Angeles lower() LowerBound() lparam ltrim() machine maintenance match() max() Max() max() and min() MaxBPs MDI memory memory requirements memory usage memory, % free menu message log MessageBox() metacharacter method Min() minimalist connect modify() MONITOR.NLM multi-key N-Up natural join natural key nested class NestedWorld nesting quotes NetBIOS NetImpact Dynamo NEW newsgroups Next_Connection() noexec non-visual Norton Speed Disk NOT EXISTS not, avoid NT 3.51 NT Performance Monitor NULL null object object assignment object browser objects ODBC ODBC text driver of_check_lock() of_get_lock() of_refresh_if_necessary() of_release_lock() on clause on condition Online Books OpenSheet() optimization OR or versus union ORCA ORCACALL.DLL ORDER BY OSUG other event outer join page size page.range parameter pass by reference pass by value PASSTHROUGH START PASSTHROUGH STOP password PatIndex() pattern matching PB.INI pb040.exe /p PBC_FIX.SQL PBCATCOL PBDebug PBDJ pbhlp040.hlp pbm_customxx pbm_dwnprocessenter pbm_enchange PBORC050.DLL PBTrace pbtrace.log file pbwat040.hlp performance Phoenix pipeline plan PLAN plan pointer pointer arithmetic polymorph table polymorphism port position PowerBuilder 5 PowerDynamo PowerScript Powersoft pre-loading precision prefix match prepare cursor PreparedStatement presentation style primary key print preview print() PrintClose() PrintDataWindow() printer PrintOpen() PrintSetup() private procedure profiler programmer prompt before print prompt before printing Properties property Property() protocols publication PUBLICATION publish publish subscribe QTEXT.INI query tool quiz quote quote character RangeInclude real() record oriented recovery urgency ref reference variable referential integrity regenerate regenerating PBCATCOL registry regular expression RelativeDate() RELOAD.SQL remote database REMOTE DBA remote user id REMOVE JAVA repeat() replicate() replication replication conflict replication status REPSTAT.EXE reset() RESOLVE UPDATE restore result set ResultSet resume retrieval argument Retrieve() return return code Revenue Canada RichTextEdit right outer join Right() rollback rollback transaction route print row flag ROWCOUNT option RowFocusChanged RTDSK50.EXE RTF rtrim() run_dbisql.bat run_dbsrv6.bat run_dbsrv6_tcpip_95.bat run_dbsrv6_tcpip_NT.bat run_java.bat run_javac.bat runtime properties SaveAs() SaveAsType scalar function scope script font scroll-while-you-type scrollbar scrolling ScrollToRow() ScrollVertical searching secondary index select SELECT select SELECT select select distinct SelectBlob() SelectRow() send() serialization ServerPort session lock SET set noexec on SET OPTION REPLICATION_ERROR set oriented SET ROWCOUNT set showplan on SetDynamicParm() SetFilter() SetItemStatus() SetNull() SetRedraw() SetRow() SetTransObject() shallow copy ShareData() sharing data sheet shift over/down showplan sign() signature field simplicity SingleLineEdit singleton select slide sort() sp_lock sp_monitor sp_sysmon sp_who specify retrieval arguments SPF/PC SQL SQL Anywhere SQL Anywhere 5 SQL Central SQL function SQL Remote SQL Server SQL_DRIVER_CONNECT SQL_DRIVER_NOPROMPT SQLCA SQLCode SQLREMOTE START SUBSCRIPTION Statement Steve Benfield stored function stored procedure string() structure subnet mask subquery subscribe SUBSCRIBE BY subscription SUBSCRIPTION subscription id subselect, correlated substr versus like substr() Substr() substring() suffix _1 sum() summary band suppress repeating surrogate key surrogate_id table Suser_id() suser_name() Suser_name() Sybase Sybase SQL Server synch point SYNCHRONIZE SUBSCRIPTION syntax mode SYS.DUMMY sysremoteuser sysremoteusers SYSTEM ADD system tables SystemError tab ~t table table scan TabSequence taxes TCP/IP Team Powersoft text text file THREAD_COUNT tilde ~ time component time() time_received time_sent timestamp TIMESTAMP timing trace too few rows too many rows toString trace TRACE in DBMS trailer Transact SQL transaction transaction object TRANSLOG ADD tree walking trigger trim() tuning type checking u_cc_app u_sle_find u_sle_find_string ucase() ue_post_activate UNION UNION ALL union versus or UNIQUE constraint unknown value unload UPDATE update UPDATE update update() updateable column upper() UpperBound() url useful index USER user defined event user defined function user groups user id user ids user object user, % free user-defined function User_id() User_name() UserId property validation expression varchar version vertical scrollbar visible visual w_prof_trace wait_for_commit Watcom date Watcom help Watcom SQL web WHERE where clause where for update wide indexes WIN.INI window Wingdings font WINHELP.EXE parameters WM_WININICHANGE wparam wrapper WRITE.EXE WriteProfileStringA Y2K zero terminator byte || concatenation ~ tilde ~hnn hexadecimal ~nnn decimal ~t tab

From SQL Anywhere To SQL Server Run ISQL In Batch Mode The Dreaded Meta-Tilde (II) From SQL Anywhere To SQL Server Not Enough Rows? From SQL Anywhere To SQL Server The Dreaded Meta-Tilde (II) From SQL Anywhere To SQL Server The Dreaded Meta-Tilde (II) QuickTips Save As RTF Better Column Names From SQL Anywhere To SQL Server From SQL Anywhere To SQL Server QuickTips L. A. Diary: Powersoft Conference '98 The Tip With No Name (Banish NULLs!) Not Enough Rows? From SQL Anywhere To SQL Server Run ISQL In Batch Mode Optimizing SQL Run ISQL In Batch Mode Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Replication Step By Step - Send Commands Via PASSTHROUGH Sybase Adaptive Server Anywhere Default Values Sybase Adaptive Server Anywhere Default Values Sybase Adaptive Server Anywhere Default Values Sybase Adaptive Server Anywhere Default Values The Dreaded Meta-Tilde (II) The Dreaded Meta-Tilde (II) Avoid The Polymorph Table Evaluating Validations ORCA Symptoms And Solutions Accidental Polymorphism Refreshing DataWindows Replication Overview From SQL Anywhere To SQL Server Pointer Arithmetic in PowerBuilder! Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Intelligent Versus Surrogate Keys Better Column Names Deal With Disk Fragmentation Beware Of Slow DDL A Simple Data Dictionary Array Functions Beware The Shallow Copy Deep Copies With AutoInstantiate Eschewing Annoyance User Defined Event Arguments Group By Peril Watcom 'Rithmetic Pre-Loading DataWindows Array Functions N-Up Computed Fields Generate Surrogate Keys Intelligent Versus Surrogate Keys Java In The Database - Getting Started with ASA 6 Java In The Database - OSUG Sybase Adaptive Server Anywhere Default Values Java In The Database (5) - Cross-Server Database I/O Consider An Explicit Primary Key Index Understand ASC And DESC QuickTips Beware The Shallow Copy A Simple Data Dictionary Beware The Shallow Copy Code For A Simple Data Dictionary Intelligent Versus Surrogate Keys QuickTips Flat Files In SQL Transaction Management With Sybase Replication Step By Step - Set Up The Remote Database Auto-Incrementing DataWindows Flat Files In SQL From SQL Anywhere To SQL Server Replication Step By Step - Send Commands Via PASSTHROUGH Sybase Adaptive Server Anywhere Default Values Understand DEFAULT AUTOINCREMENT Deep Copies With AutoInstantiate A Simple Data Dictionary Forensic Programming Replication Step By Step - Set Up The Consolidated Database The Tip With No Name (Banish NULLs!) Pattern Matching With SQL Run ISQL In Batch Mode The DataWindow As Pipeline Transaction Management With Sybase Generate Surrogate Keys Intelligent Versus Surrogate Keys Casting BLObs Find Blocked Connections With System Functions Find Blocked Connections With System Functions About Breck Carter Resume Intelligent Versus Surrogate Keys The Prime Directive: Increase The Cache Java In The Database (5) - Cross-Server Database I/O Group By Peril Too Many Rows? Wait_For_Commit Multi-Key DropDownDataWindows Intelligent Versus Surrogate Keys From SQL Anywhere To SQL Server QuickTips Flat Files In SQL Casting BLObs Group By Peril Timeless Dates Watcom 'Rithmetic Sybase SQL Anywhere 5.5 System Tables From SQL Anywhere To SQL Server Hiding The MDI Window List From SQL Anywhere To SQL Server QuickTips Beware The Shallow Copy Monitor Client And Server With DBWatch Java In The Database - Getting Started with ASA 6 To Check Or Not To Check (Error Codes) Multi-Key DropDownDataWindows Transaction Management With Sybase Accidental Polymorphism Avoid The Polymorph Table Forensic Programming Prompt Before Printing A Simple Data Dictionary Better Column Names N-Up Computed Fields N-Up Computed Fields QuickTips From SQL Anywhere To SQL Server Replication Step By Step - Set Up The Consolidated Database The DataWindow As Pipeline To Check Or Not To Check (Error Codes) Wait_For_Commit Transaction Management With Sybase Diagnose Problems With Runtime Properties Java In The Database (3) - Object Indexes Java In The Database - Getting Started with ASA 6 Avoid The Polymorph Table Java In The Database (3) - Object Indexes Java In The Database - Getting Started with ASA 6 Better Column Names Better Column Names A Simple Data Dictionary Better Column Names Code For A Simple Data Dictionary Describing Evaluate Distinct Sums Evaluating LookupDisplay N-Up Computed Fields The Dreaded Meta-Tilde (I) From SQL Anywhere To SQL Server Default Timestamp Transaction Management With Sybase L. A. Diary: Powersoft Conference '98 Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Consolidated Database Diagnose Problems With Runtime Properties QuickTips The ConnectOption DBParm Parameter Transaction Management With Sybase Java In The Database (4) - JDBC and jConnect Java In The Database (5) - Cross-Server Database I/O Transaction Management With Sybase Diagnose Problems With Runtime Properties Find Blocked Connections With System Functions The ConnectOption DBParm Parameter Default Timestamp Transaction Management With Sybase Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Set Up The Consolidated Database Java In The Database (2) - Nested Object Columns Java In The Database (3) - Object Indexes Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Y2K Disaster: Good News, Bad News Resume Intelligent Versus Surrogate Keys WINHELP.EXE Parameters WINHELP.EXE Parameters Y2K Disaster: Good News, Bad News Independent Contractor Questionnaire From SQL Anywhere To SQL Server Flat Files In SQL Flat Files In SQL Flat Files In SQL Prompt Before Printing Flat Files In SQL Java In The Database (5) - Cross-Server Database I/O Watch Out For Correlated Subqueries DELETE FROM FROM Optimizing SQL Exists Versus Count(*) Refreshing DataWindows Use EXISTS Instead Of COUNT(*) Counting With CumulativeSum() Independent Contractor Questionnaire Beware The Shallow Copy Deep Copies With AutoInstantiate Put Different Data On Different Drives Replication Step By Step - Send Commands Via PASSTHROUGH User-Defined SQL Functions Be Reasonable With The Indexes Beware Of Slow DDL Consider An Explicit Primary Key Index Create Indexes Java In The Database (3) - Object Indexes Pick The Right Time To Create An Index Put Different Data On Different Drives Understand ASC And DESC Understand Index Column Placement Use Indexes for Max() and Min() Use LIKE 'xx%' Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Send Commands Via PASSTHROUGH Always Define A Primary Key Beware Of Slow DDL Java In The Database - Getting Started with ASA 6 Put Different Data On Different Drives Replication Step By Step - Send Commands Via PASSTHROUGH Sybase Adaptive Server Anywhere Default Values Trust Your Keys Understand Primary Key Column Placement WINHELP.EXE Parameters Java In The Database (5) - Cross-Server Database I/O WINHELP.EXE Parameters Java In The Database (5) - Cross-Server Database I/O Counting With CumulativeSum() Sybase Adaptive Server Anywhere Default Values Replication Step By Step - Send Commands Via PASSTHROUGH Sybase Adaptive Server Anywhere Default Values Sybase Adaptive Server Anywhere Default Values ScrollToFirstRowOnPage Sybase Adaptive Server Anywhere Default Values Default Timestamp Refreshing DataWindows Sybase Adaptive Server Anywhere Default Values From SQL Anywhere To SQL Server Sybase Adaptive Server Anywhere Default Values Evaluating LookupDisplay Waving Dead Chickens Tuning PowerScript - A Case Study Pre-Loading DataWindows Deep Copies With AutoInstantiate Code For A Simple Data Dictionary A Rudimentary Execution Profiler A Simple Data Dictionary Code For A Simple Data Dictionary eDict: An HTML-Based Data Dictionary Sybase SQL Anywhere 5.5 System Tables A Simple Data Dictionary Waving Dead Chickens Save As RTF Pre-Loading DataWindows Accidental Polymorphism Auto-Incrementing DataWindows Code For Prompt Before Printing Encapsulated DataWindow Searching Eschewing Annoyance Evaluating LookupDisplay Forensic Programming Format 5 Dynamic SQL Moving The Unmovable Multi-Key DropDownDataWindows Pre-Loading DataWindows Prompt Before Printing Refreshing DataWindows Scroll-While-You-Type Program Code ScrollToFirstRowOnPage The DataWindow As Pipeline From SQL Anywhere To SQL Server Date Arithmetic in PowerBuilder! Timeless Dates Timeless Dates Sybase Adaptive Server Anywhere Default Values From SQL Anywhere To SQL Server From SQL Anywhere To SQL Server Refreshing DataWindows Date Arithmetic in PowerBuilder! Date Arithmetic in PowerBuilder! Sybase Adaptive Server Anywhere Default Values Diagnose Problems With Runtime Properties Monitor Client And Server With DBWatch Java In The Database (4) - JDBC and jConnect QuickTips WINHELP.EXE Parameters To Check Or Not To Check (Error Codes) To Check Or Not To Check (Error Codes) To Check Or Not To Check (Error Codes) Use A Large Page Size Java In The Database - Getting Started with ASA 6 Replication Step By Step - Set Up The Consolidated Database Use A Large Page Size Replication Step By Step - Set Up The Remote Database Java In The Database (2) - Nested Object Columns Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Transaction Management With Sybase Put Different Data On Different Drives Use A Log File The ConnectOption DBParm Parameter Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Use A Large Page Size Use -x To Limit Protocols Java In The Database (2) - Nested Object Columns Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Monitor Client And Server With DBWatch Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Remote Database Intelligent Versus Surrogate Keys Beware Of Slow DDL PBDebug and DebugOutFile Group By Peril Watcom 'Rithmetic Tuning PowerScript - A Case Study Dealing With Hierarchies Beware The Shallow Copy Deep Copies With AutoInstantiate Tracking The Elusive DWObject Sybase Adaptive Server Anywhere Default Values Auto-Incrementing DataWindows Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Understand DEFAULT AUTOINCREMENT Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Switching NT Printers Default Timestamp From SQL Anywhere To SQL Server Refreshing DataWindows Wait_For_Commit Flat Files In SQL DELETE FROM FROM Waving Dead Chickens Dealing With Hierarchies Understand ASC And DESC Describing Evaluate Evaluating LookupDisplay Evaluating Validations Moving The Unmovable Prompt Before Printing ScrollToFirstRowOnPage To Check Or Not To Check (Error Codes) Waving Dead Chickens Beware The Shallow Copy Deep Copies With AutoInstantiate Tracking The Elusive DWObject II Eschewing Annoyance A Simple Data Dictionary Code For A Simple Data Dictionary Sybase SQL Anywhere 5.5 System Tables QuickTips Y2K Disaster: Good News, Bad News Monitor Client And Server With DBWatch To Check Or Not To Check (Error Codes) Transaction Management With Sybase Deal With Disk Fragmentation Diagnose Problems With Runtime Properties Diagnose Problems With Runtime Properties Distinct Sums Profiler Code Pointer Arithmetic in PowerBuilder! Tracking The Elusive DWObject Java In The Database (4) - JDBC and jConnect Put Different Data On Different Drives Beware Of Slow DDL Beware Of Slow DDL Beware Of Slow DDL Eschewing Annoyance Evaluating LookupDisplay Multi-Key DropDownDataWindows Pre-Loading DataWindows Waving Dead Chickens The Dreaded Meta-Tilde (I) Transaction Management With Sybase Evaluating LookupDisplay Tracking The Elusive DWObject Tracking The Elusive DWObject II QuickTips QuickTips Format 5 Dynamic SQL Tuning PowerScript - A Case Study Getting Started with NetImpact Dynamo eDict: An HTML-Based Data Dictionary Sybase SQL Anywhere 5.5 System Tables Independent Contractor Questionnaire Tuning PowerScript - A Case Study Independent Contractor Questionnaire Encapsulated DataWindow Searching Hiding The MDI Window List A Simple Data Dictionary Code For A Simple Data Dictionary Pointer Arithmetic in PowerBuilder! Beware The Shallow Copy Group By Peril Watcom 'Rithmetic Array Functions To Check Or Not To Check (Error Codes) Wait_For_Commit A Simple Data Dictionary Code For A Simple Data Dictionary Java In The Database (4) - JDBC and jConnect Describing Evaluate Evaluating LookupDisplay Evaluating Validations User Defined Event Arguments User Defined Event Arguments User Defined Event Arguments Format 5 Dynamic SQL Transaction Management With Sybase A Rudimentary Execution Profiler Profiler Code Profiler Feedback DELETE FROM FROM Exists Versus Count(*) Use EXISTS Instead Of COUNT(*) Optimizing SQL The Dreaded Meta-Tilde (I) A Simple Data Dictionary Code For A Simple Data Dictionary Forensic Programming N-Up Computed Fields The Dreaded Meta-Tilde (I) Find Blocked Connections With System Functions Accidental Polymorphism To Check Or Not To Check (Error Codes) Pointer Arithmetic in PowerBuilder! Generate Surrogate Keys Date Arithmetic in PowerBuilder! A Rudimentary Execution Profiler Code For Prompt Before Printing Prompt Before Printing Array Functions Consider An Explicit Primary Key Index Tuning PowerScript - A Case Study Java In The Database - Getting Started with ASA 6 Replication Step By Step Multi-Key DropDownDataWindows The Dreaded Meta-Tilde (I) Waving Dead Chickens Encapsulated DataWindow Searching Scroll-While-You-Type Program Code Moving The Unmovable ScrollToFirstRowOnPage Dealing With Hierarchies Importing Text Files The DataWindow As Pipeline Flat Files In SQL Group By Peril Watcom 'Rithmetic QuickTips QuickTips Moving The Unmovable A Simple Data Dictionary Avoid The Polymorph Table Consider An Explicit Primary Key Index Dealing With Hierarchies Intelligent Versus Surrogate Keys Replication Step By Step - Send Commands Via PASSTHROUGH The Tip With No Name (Banish NULLs!) Trust Your Keys Wait_For_Commit Forensic Programming Tuning PowerScript - A Case Study Tuning PowerScript - A Case Study Deal With Disk Fragmentation Hiding The MDI Window List DELETE FROM FROM From SQL Anywhere To SQL Server Use The NT Performance Monitor Use The SQL Central Performance Monitor Watch Out For Wide Indexes Array Functions Deep Copies With AutoInstantiate Flat Files In SQL Format 5 Dynamic SQL User-Defined SQL Functions Java In The Database (4) - JDBC and jConnect Profiler Code Eschewing Annoyance Waving Dead Chickens Waving Dead Chickens Evaluating Validations From SQL Anywhere To SQL Server Sybase Adaptive Server Anywhere Default Values Pointer Arithmetic in PowerBuilder! Tracking The Elusive DWObject Auto-Incrementing DataWindows Switching NT Printers Counting With CumulativeSum() Describing Evaluate Evaluating LookupDisplay Evaluating Validations Waving Dead Chickens Waving Dead Chickens To Check Or Not To Check (Error Codes) Evaluating Validations Pre-Loading DataWindows A Simple Data Dictionary WINHELP.EXE Parameters Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Distinct Sums Create Indexes Group By Peril Use Indexes for Max() and Min() Watcom 'Rithmetic Local Session Locks Pattern Matching With SQL The Dreaded Meta-Tilde (I) Java In The Database (2) - Nested Object Columns Java In The Database - Getting Started with ASA 6 Java In The Database (4) - JDBC and jConnect QuickTips WINHELP.EXE Parameters From SQL Anywhere To SQL Server QuickTips Pre-Loading DataWindows Dealing With Hierarchies Waving Dead Chickens Java In The Database (4) - JDBC and jConnect Prompt Before Printing eDict: An HTML-Based Data Dictionary Getting Started with NetImpact Dynamo Sybase SQL Anywhere 5.5 System Tables Save As RTF Switching NT Printers From SQL Anywhere To SQL Server Intelligent Versus Surrogate Keys Auto-Incrementing DataWindows Use EXISTS Instead Of COUNT(*) Replication Step By Step - Send Commands Via PASSTHROUGH From SQL Anywhere To SQL Server Exists Versus Count(*) Watch Out For Correlated Subqueries A Simple Data Dictionary Code For A Simple Data Dictionary Importing Text Files Independent Contractor Questionnaire Independent Contractor Questionnaire Always Define A Primary Key Be Reasonable With The Indexes Consider An Explicit Primary Key Index Create Indexes Flat Files In SQL Intelligent Versus Surrogate Keys Java In The Database (3) - Object Indexes Optimizing SQL Pick The Right Time To Create An Index Trust Your Keys Understand ASC And DESC Use EXISTS Instead Of COUNT(*) Use Indexes for Max() and Min() Use LIKE 'xx%' Watch Out For Wide Indexes Understand Index Column Placement Java In The Database (3) - Object Indexes Flat Files In SQL Replication Step By Step - Send Commands Via PASSTHROUGH Sybase Adaptive Server Anywhere Default Values Understand DEFAULT AUTOINCREMENT Pick The Right Time To Create An Index Save As RTF Auto-Incrementing DataWindows Eschewing Annoyance Java In The Database - Getting Started with ASA 6 Group By Peril Watcom 'Rithmetic Wait_For_Commit Generate Surrogate Keys Intelligent Versus Surrogate Keys Multi-Key DropDownDataWindows Importing Text Files Pre-Loading DataWindows Java In The Database (4) - JDBC and jConnect Evaluating Validations Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Set Up The Consolidated Database Run ISQL In Batch Mode Learn To Read The Plan Replication Step By Step - Set Up The Remote Database A Rudimentary Execution Profiler Pre-Loading DataWindows The Tip With No Name (Banish NULLs!) Multi-Key DropDownDataWindows Waving Dead Chickens Multi-Key DropDownDataWindows Java In The Database (2) - Nested Object Columns Java In The Database (3) - Object Indexes Java In The Database (4) - JDBC and jConnect Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Java In The Database - OSUG Java In The Database (2) - Nested Object Columns Java In The Database - Getting Started with ASA 6 Getting Started with NetImpact Dynamo Java In The Database (4) - JDBC and jConnect Java In The Database (5) - Cross-Server Database I/O Java In The Database (4) - JDBC and jConnect Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Intelligent Versus Surrogate Keys Too Many Rows? From SQL Anywhere To SQL Server Avoid The Polymorph Table WINHELP.EXE Parameters Pointer Arithmetic in PowerBuilder! Pattern Matching With SQL Prompt Before Printing Date Arithmetic in PowerBuilder! From SQL Anywhere To SQL Server Sybase Adaptive Server Anywhere Default Values Moving The Unmovable Tracking The Elusive DWObject II From SQL Anywhere To SQL Server From SQL Anywhere To SQL Server Use LIKE 'xx%' From SQL Anywhere To SQL Server Forensic Programming ORCA Symptoms And Solutions Forensic Programming Optimizing SQL Use LIKE 'xx%' Optimizing SQL Profiler Feedback A Simple Data Dictionary Can SQL Anywhere Handle Your Load? Flat Files In SQL Replication Step By Step - Set Up The Remote Database Java In The Database (4) - JDBC and jConnect Pattern Matching With SQL Find Blocked Connections With System Functions Intelligent Versus Surrogate Keys Local Session Locks SQL Server Performance Tips Transaction Management With Sybase Use A Log File Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Consolidated Database The Tip With No Name (Banish NULLs!) From SQL Anywhere To SQL Server From SQL Anywhere To SQL Server Describing Evaluate Evaluating LookupDisplay Waving Dead Chickens L. A. Diary: Powersoft Conference '98 From SQL Anywhere To SQL Server The Dreaded Meta-Tilde (I) The Dreaded Meta-Tilde (II) Array Functions User Defined Event Arguments From SQL Anywhere To SQL Server Java In The Database (4) - JDBC and jConnect Forensic Programming The Dreaded Meta-Tilde (II) Refreshing DataWindows Use Indexes for Max() and Min() Optimizing SQL QuickTips Hiding The MDI Window List Local Session Locks Tracking The Elusive DWObject II Pre-Loading DataWindows Tracking The Elusive DWObject Profiler Code Hiding The MDI Window List Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Set Up The Remote Database Refreshing DataWindows Transaction Management With Sybase The Dreaded Meta-Tilde (I) The Dreaded Meta-Tilde (II) Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Use Indexes for Max() and Min() QuickTips Moving The Unmovable QuickTips The Prime Directive: Increase The Cache Multi-Key DropDownDataWindows N-Up Computed Fields Avoid The Polymorph Table Intelligent Versus Surrogate Keys Java In The Database (2) - Nested Object Columns Java In The Database (2) - Nested Object Columns The Dreaded Meta-Tilde (II) Use TCP/IP Getting Started with NetImpact Dynamo Java In The Database (2) - Nested Object Columns Java In The Database (3) - Object Indexes Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Getting Started With Powersoft and Sybase News Groups Find Blocked Connections With System Functions SQL Server Performance Tips Deep Copies With AutoInstantiate Pre-Loading DataWindows Deal With Disk Fragmentation Watch Out For Correlated Subqueries Optimizing SQL Switching NT Printers Use The NT Performance Monitor The Tip With No Name (Banish NULLs!) Profiler Feedback Beware The Shallow Copy Tracking The Elusive DWObject Java In The Database - Getting Started with ASA 6 Replication Step By Step - Set Up The Consolidated Database The ConnectOption DBParm Parameter Importing Text Files Local Session Locks Local Session Locks Refreshing DataWindows Local Session Locks From SQL Anywhere To SQL Server Not Enough Rows? Deep Copies With AutoInstantiate Hiding The MDI Window List A Rudimentary Execution Profiler Array Functions Exists Versus Count(*) Optimizing SQL Profiler Code Profiler Feedback SQL Server Performance Tips Sybase SQL Anywhere Performance Tips & Techniques - A Final Word Tuning PowerScript - A Case Study Replace OR With UNION Optimizing SQL ORCA Symptoms And Solutions ORCA Symptoms And Solutions Create Indexes Java In The Database - Getting Started with ASA 6 Understand ASC And DESC Java In The Database - OSUG Encapsulated DataWindow Searching Not Enough Rows? Watch Out For Correlated Subqueries Use A Large Page Size Prompt Before Printing Deep Copies With AutoInstantiate QuickTips Deep Copies With AutoInstantiate Deep Copies With AutoInstantiate Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Send Commands Via PASSTHROUGH The ConnectOption DBParm Parameter Pattern Matching With SQL Pattern Matching With SQL PBDebug and DebugOutFile QuickTips Pattern Matching With SQL Pattern Matching With SQL PBDebug and DebugOutFile QuickTips An Open Letter To Steve Benfield WINHELP.EXE Parameters User Defined Event Arguments QuickTips Encapsulated DataWindow Searching QuickTips ORCA Symptoms And Solutions QuickTips QuickTips QuickTips WINHELP.EXE Parameters A Rudimentary Execution Profiler Array Functions Exists Versus Count(*) Optimizing SQL Pre-Loading DataWindows Profiler Code Profiler Feedback SQL Server Performance Tips Sybase SQL Anywhere Performance Tips & Techniques Sybase SQL Anywhere Performance Tips & Techniques - A Final Word Sybase SQL Anywhere Performance Tips & Techniques - Introduction Sybase SQL Anywhere Performance Tips & Techniques - Overview Tuning PowerScript - A Case Study Resume The DataWindow As Pipeline Java In The Database (3) - Object Indexes Learn To Read The Plan Optimizing SQL SQL Server Performance Tips Beware The Shallow Copy Deep Copies With AutoInstantiate Pointer Arithmetic in PowerBuilder! Avoid The Polymorph Table Accidental Polymorphism Java In The Database (4) - JDBC and jConnect Hiding The MDI Window List Array Functions Tracking The Elusive DWObject Getting Started with NetImpact Dynamo Pre-Loading DataWindows Getting Started With Powersoft and Sybase News Groups Pre-Loading DataWindows Group By Peril Watcom 'Rithmetic The Dreaded Meta-Tilde (II) Tuning PowerScript - A Case Study Java In The Database (4) - JDBC and jConnect Save As RTF A Simple Data Dictionary Always Define A Primary Key Auto-Incrementing DataWindows Consider An Explicit Primary Key Index Flat Files In SQL Generate Surrogate Keys Intelligent Versus Surrogate Keys Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Trust Your Keys Understand DEFAULT AUTOINCREMENT Understand Primary Key Column Placement Moving The Unmovable Code For Prompt Before Printing Prompt Before Printing Switching NT Printers Switching NT Printers Switching NT Printers Switching NT Printers Switching NT Printers Java In The Database (5) - Cross-Server Database I/O Dealing With Hierarchies Format 5 Dynamic SQL A Rudimentary Execution Profiler Optimizing SQL Profiler Code Profiler Feedback Y2K Disaster: Good News, Bad News Code For Prompt Before Printing Prompt Before Printing Java In The Database (4) - JDBC and jConnect Tracking The Elusive DWObject Diagnose Problems With Runtime Properties Watch Out For Wide Indexes Use -x To Limit Protocols Replication Overview Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step Replication Step By Step - Conclusion Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Introduction Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Overview Importing Text Files Avoid The Polymorph Table Not Enough Rows? Too Many Rows? The Dreaded Meta-Tilde (II) The Dreaded Meta-Tilde (I) Prompt Before Printing Evaluating Validations Think Sets Monitor Client And Server With DBWatch Beware The Shallow Copy Beware The Shallow Copy Deep Copies With AutoInstantiate Avoid The Polymorph Table Wait_For_Commit Forensic Programming Pattern Matching With SQL Switching NT Printers The Dreaded Meta-Tilde (II) Date Arithmetic in PowerBuilder! Replication Step By Step - Set Up The Remote Database Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Consolidated Database Java In The Database - Getting Started with ASA 6 From SQL Anywhere To SQL Server From SQL Anywhere To SQL Server Replication Overview Replication Step By Step Replication Step By Step - Conclusion Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Introduction Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database The DataWindow As Pipeline Sybase Adaptive Server Anywhere Default Values Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Consolidated Database Waving Dead Chickens Sybase Adaptive Server Anywhere Default Values Replication Step By Step - Set Up The Consolidated Database Too Many Rows? Tuning PowerScript - A Case Study Java In The Database (4) - JDBC and jConnect Resume Eschewing Annoyance Eschewing Annoyance Importing Text Files Limit Result Sets With SET ROWCOUNT Refreshing DataWindows The DataWindow As Pipeline Transaction Management With Sybase Waving Dead Chickens Array Functions To Check Or Not To Check (Error Codes) Independent Contractor Questionnaire Save As RTF From SQL Anywhere To SQL Server Use LIKE 'xx%' To Check Or Not To Check (Error Codes) Transaction Management With Sybase Java In The Database (4) - JDBC and jConnect The DataWindow As Pipeline Interrupt Processing With SET ROWCOUNT Limit Result Sets With SET ROWCOUNT Multi-Key DropDownDataWindows Waving Dead Chickens Use A Log File Save As RTF From SQL Anywhere To SQL Server Java In The Database (2) - Nested Object Columns Java In The Database (2) - Nested Object Columns Java In The Database (4) - JDBC and jConnect Java In The Database (4) - JDBC and jConnect Java In The Database (4) - JDBC and jConnect Java In The Database (2) - Nested Object Columns Diagnose Problems With Runtime Properties Save As RTF Save As RTF User-Defined SQL Functions Deep Copies With AutoInstantiate QuickTips Encapsulated DataWindow Searching Scroll-While-You-Type Program Code ScrollToFirstRowOnPage Encapsulated DataWindow Searching Scroll-While-You-Type Program Code Save As RTF ScrollToFirstRowOnPage Waving Dead Chickens ScrollToFirstRowOnPage Encapsulated DataWindow Searching Scroll-While-You-Type Program Code Intelligent Versus Surrogate Keys Format 5 Dynamic SQL From SQL Anywhere To SQL Server Java In The Database (4) - JDBC and jConnect Java In The Database (5) - Cross-Server Database I/O Java In The Database - Getting Started with ASA 6 Not Enough Rows? SQL Server Performance Tips Too Many Rows? Timeless Dates Casting BLObs Waving Dead Chickens Switching NT Printers Java In The Database (4) - JDBC and jConnect Java In The Database (4) - JDBC and jConnect Local Session Locks Java In The Database (5) - Cross-Server Database I/O SQL Server Performance Tips Sybase Adaptive Server Anywhere Default Values Think Sets Interrupt Processing With SET ROWCOUNT Limit Result Sets With SET ROWCOUNT SQL Server Performance Tips Tuning PowerScript - A Case Study Multi-Key DropDownDataWindows The Dreaded Meta-Tilde (I) The Dreaded Meta-Tilde (II) Waving Dead Chickens The DataWindow As Pipeline The Tip With No Name (Banish NULLs!) Waving Dead Chickens ScrollToFirstRowOnPage Eschewing Annoyance The DataWindow As Pipeline Transaction Management With Sybase Beware The Shallow Copy Pre-Loading DataWindows Save As RTF Hiding The MDI Window List Local Session Locks Hiding The MDI Window List Optimizing SQL SQL Server Performance Tips From SQL Anywhere To SQL Server Moving The Unmovable Avoid The Polymorph Table Encapsulated DataWindow Searching Scroll-While-You-Type Program Code Tuning PowerScript - A Case Study A Simple Data Dictionary Waving Dead Chickens SQL Server Performance Tips SQL Server Performance Tips SQL Server Performance Tips SQL Server Performance Tips Eschewing Annoyance Forensic Programming Java In The Database - Getting Started with ASA 6 Sybase Adaptive Server Anywhere Default Values Sybase SQL Anywhere 5.5 System Tables From SQL Anywhere To SQL Server Getting Started with NetImpact Dynamo Java In The Database - OSUG Replication Overview Replication Step By Step Replication Step By Step - Conclusion Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Introduction Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Sybase SQL Anywhere Performance Tips & Techniques Sybase SQL Anywhere Performance Tips & Techniques - Introduction Sybase SQL Anywhere Performance Tips & Techniques - Overview A Simple Data Dictionary Default Timestamp DELETE FROM FROM Format 5 Dynamic SQL Refreshing DataWindows Use The SQL Central Performance Monitor User-Defined SQL Functions Replication Overview SQL Server Performance Tips The ConnectOption DBParm Parameter The ConnectOption DBParm Parameter Beware The Shallow Copy The ConnectOption DBParm Parameter Transaction Management With Sybase To Check Or Not To Check (Error Codes) Replication Step By Step - Set Up The Remote Database Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Remote Database Java In The Database (4) - JDBC and jConnect An Open Letter To Steve Benfield Format 5 Dynamic SQL Dealing With Hierarchies Format 5 Dynamic SQL Optimizing SQL Use Stored Procedures And Triggers Describing Evaluate Pointer Arithmetic in PowerBuilder! Beware The Shallow Copy Java In The Database (4) - JDBC and jConnect DELETE FROM FROM Java In The Database (5) - Cross-Server Database I/O Watch Out For Correlated Subqueries Replication Step By Step Replication Step By Step - Conclusion Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Introduction Replication Step By Step - Replicate Changes Among The Databases Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Remote Database Replication Step By Step - Set Up The Consolidated Database Replication Overview Replication Step By Step - Send Commands Via PASSTHROUGH Replication Step By Step - Set Up The Consolidated Database DELETE FROM FROM Optimizing SQL Optimizing SQL From SQL Anywhere To SQL Server Use LIKE 'xx%' From SQL Anywhere To SQL Server N-Up Computed Fields Describing Evaluate Distinct Sums Group By Peril Watcom 'Rithmetic Moving The Unmovable Counting With CumulativeSum() Distinct Sums Generate Surrogate Keys Intelligent Versus Surrogate Keys Multi-Key DropDownDataWindows Generate Surrogate Keys Intelligent Versus Surrogate Keys Sybase Adaptive Server Anywhere Default Values From SQL Anywhere To SQL Server Sybase Adaptive Server Anywhere Default Values Getting Started With Powersoft and Sybase News Groups Transaction Management With Sybase Transaction Management With Sybase Replication Step By Step - Force Consistency Via SYNCHRONIZE SUBSCRIPTION Replication Step By Step - Send Commands Via PASSTHROUGH Format 5 Dynamic SQL Exists Versus Count(*) Use EXISTS Instead Of COUNT(*) Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Replicate Changes Among The Databases Deal With Disk Fragmentation Sybase SQL Anywhere 5.5 System Tables Profiler Feedback To Check Or Not To Check (Error Codes) Transaction Management With Sybase The Dreaded Meta-Tilde (II) A Simple Data Dictionary Learn To Read The Plan Waving Dead Chickens Independent Contractor Questionnaire Java In The Database (4) - JDBC and jConnect Use -x To Limit Protocols Use TCP/IP About Breck Carter From SQL Anywhere To SQL Server Flat Files In SQL Importing Text Files Can SQL Anywhere Handle Your Load? The Dreaded Meta-Tilde (I) The Dreaded Meta-Tilde (II) Timeless Dates The Dreaded Meta-Tilde (I) Replication Step By Step - Set Up The Consolidated Database Replication Step By Step - Set Up The Consolidated Database Default Timestamp From SQL Anywhere To SQL Server Refreshing DataWindows Sybase Adaptive Server Anywhere Default Values A Rudimentary Execution Profiler Profiler Code Profiler Feedback Not Enough Rows? Too Many Rows? Java In The Database (2) - Nested Object Columns Java In The Database (3) - Object Indexes Java In The Database - Getting Started with ASA 6 PBDebug and DebugOutFile QuickTips Distinct Sums From SQL Anywhere To SQL Server The DataWindow As Pipeline Transaction Management With Sybase Beware The Shallow Copy Deal With Disk Fragmentation Dealing With Hierarchies Use Stored Procedures And Triggers From SQL Anywhere To SQL Server The Dreaded Meta-Tilde (II) Sybase SQL Anywhere Performance Tips & Techniques - A Final Word Tuning PowerScript - A Case Study Evaluating Validations Local Session Locks Scroll-While-You-Type Program Code Encapsulated DataWindow Searching From SQL Anywhere To SQL Server Refreshing DataWindows A Simple Data Dictionary Replace OR With UNION Use UNION ALL Optimizing SQL Always Define A Primary Key Trust Your Keys Understand DEFAULT AUTOINCREMENT The Tip With No Name (Banish NULLs!) A Simple Data Dictionary Java In The Database (4) - JDBC and jConnect Pattern Matching With SQL Sybase Adaptive Server Anywhere Default Values Transaction Management With Sybase Auto-Incrementing DataWindows The DataWindow As Pipeline Default Timestamp From SQL Anywhere To SQL Server Array Functions Java In The Database (4) - JDBC and jConnect Understand Index Column Placement Sybase Adaptive Server Anywhere Default Values User Defined Event Arguments User-Defined SQL Functions WINHELP.EXE Parameters Replication Step By Step - Set Up The Consolidated Database The ConnectOption DBParm Parameter WINHELP.EXE Parameters Deep Copies With AutoInstantiate Profiler Code Flat Files In SQL Sybase Adaptive Server Anywhere Default Values Sybase Adaptive Server Anywhere Default Values Find Blocked Connections With System Functions Evaluating Validations From SQL Anywhere To SQL Server Use The Latest Version ScrollToFirstRowOnPage Moving The Unmovable Pre-Loading DataWindows Pre-Loading DataWindows A Rudimentary Execution Profiler Profiler Code The DataWindow As Pipeline Wait_For_Commit Timeless Dates QuickTips Group By Peril Watcom 'Rithmetic Getting Started with NetImpact Dynamo Create Indexes Java In The Database (3) - Object Indexes Java In The Database - Getting Started with ASA 6 Replace OR With UNION Replication Step By Step - Set Up The Consolidated Database Use EXISTS Instead Of COUNT(*) Use Indexes for Max() and Min() Not Enough Rows? Default Timestamp Use The NT Performance Monitor Use The SQL Central Performance Monitor Watch Out For Wide Indexes Switching NT Printers Local Session Locks QuickTips WINHELP.EXE Parameters Switching NT Printers User Defined Event Arguments ORCA Symptoms And Solutions Forensic Programming Switching NT Printers Y2K Disaster: Good News, Bad News Pointer Arithmetic in PowerBuilder! From SQL Anywhere To SQL Server The Dreaded Meta-Tilde (I) The Dreaded Meta-Tilde (II) QuickTips QuickTips The Dreaded Meta-Tilde (II)

[Home]

[mail to: bcarter@bcarter.com]