Using SoftBench with SQL | HP UX SoftBench Software specs

Using SoftBench with SQL

13 Using SoftBench with SQL

Relational Database Management System (RDBMS) products support embedded SQL statements in source code by using a preprocessor to translate the SQL into the source language. SoftBench assists developers using relational database embedded SQL in their software applications.

Chapter 13

313

Image 313

HP UX SoftBench Software manual Using SoftBench with SQL

Contents

Manufacturing Part Number B6454-97413 June C++ SoftBench Users Guide Legal Notices Page Printing History Boldface font Convention DescriptionPage Contents Using SoftBench Conﬁguration Manager Using SoftBench Editors Using SoftBench Class Graph/Editor Using SoftBench Debugger Contents Using SoftBench Debugger Data Graph Window Using Static Graphs Using SoftBench File Compare Using SoftBench Graph Windows Using Regular Expressions Contents Maximizing Your Results with Major Software Development Tasks Supported by SoftBench SoftBench Task Flow More sets of build instructions and dependencies Understanding ProjectsSoftBench Tools Interacting with Project and Files Building Targets Understanding Build Conﬁgurations and Packages Understanding Projects Simpliﬁed Build Conﬁguration, Package, and Transform Series Choosing Between Project Build and External Build Models Understanding Projects One Project, One Author Sharing Projects with a TeamOne Project, Many Authors Team Members Cloning the Project Deﬁnition One Project with Subprojects, Many Authors Team Members Using SubprojectsTeam Members Sharing the Project Deﬁnition Sharing Projects with a Team Chapter Planning Your Project Editors Using the SoftBench Integrated EnvironmentConﬁguration Management SoftBench Static Analyzer SoftBench Debugger Using SoftBench Tools Throughout Your Development CycleSoftBench File Compare SoftBench Message Monitor Using SoftBench Tools Together Tools That Can Directly Invoke Other Tools Using SoftBench Tools on Multiple Projects 10 Iconize and Normalize Project Buttons Using SoftBench Tools as Standalone Tools Copying Data between SoftBench Tools Reusing Tool Windows An Example SoftBench Session An Example SoftBench Session Learning SoftBench Using SoftBench Shell Syntax Prerequisites to Using SoftBench Starting SoftBench Unexpanded SoftBench Window Understanding SoftBench Window Areas Window Area Description Description of SoftBench Window Areas Static, and Optimized compiler Expanded SoftBench Window Displaying Builder Understanding the Builder Expanded SoftBench Window Displaying SoftBench Understanding the SoftBench CodeAdvisorCodeAdvisor Understanding SoftBench Window Areas Creating a Project Using Project Build Setting Up a Project Create Project Dialog Box Create Project Dialog Box for External Build Creating a Project Using External Build Cloning a Project from an Existing Project Repartitioning an Existing Project Creating a Subproject Modifying a Project Deﬁnition Creating Files within a Project Add Files to Project Dialog Box Adding Existing Files to a Project Adding Existing Files to a Project Creating a Target Deﬁning Targets for Project Build Specifying Dependency Relationships Manage Build Conﬁguration Dialog Box Customizing Build Conﬁgurations Using Build Packages Deﬁning Targets for External Build External Build Command Dialog Box Deﬁning Targets for External Build Build Model Operations in the Target Graph Using the Target Graph Operation Project Build External Build Understanding the Graph Graph Node States Displaying DependenciesColor Meaning Building a Selected Target Controlling Graph ComplexityStarting Your Conﬁgured Editor Building Projects and Targets Setting the Compile Mode Compile Mode Settings Default Compiler Flag Previewing the Build Using the External Build Command Dialog Box Compiling Instead of Building Handling ErrorsBuilding Subprojects Browsing and Correcting Build Errors Interpreting Error Messages Running the Build on a Remote System Checking Your Code Using SoftBench CodeAdvisor Running Other SoftBench Tools Managing Your SoftBench Environment Adding and Removing Tool Icons Registering New Tools with SoftBench Choosing Tool Preferences Accessing Distributed Data and Tools Customizing SoftBench by Setting Resources Integrating with CDE Running SoftBench on a Remote SystemStopping SoftBench Restoring Your Previous SoftBench Session 11 SoftBench Online Help Window Getting Help Accessing On Item Help Using the Help Menu Condition or Explanation Message If Something Goes Wrong For More Information For More Information Chapter Using SoftBench Conﬁguration Integration of SoftBench CM with SoftBench Understanding SoftBench CM Understanding SoftBench CM Getting Started a Brief Overview Choose Directory Create… Choose Actions Check Out to Local Directory Browsing Local Network Servers and Archives Managing the Archive System Viewing Local Servers and SoftBench CM Archives File or directory name Creating an Archive DirectorySoftBench CM Main Window Local Directory Creating a Mapping between an Archive DirectorySoftBench CM File Mapping Modifying Mappings between Local and Archive Directories 100 Show / Modify Mappings Dialog Box Chapter 101 Creating Initial Archive Files Managing Archive Files and DirectoriesChecking Out Archive Files 102 Updating a Local Directory Cancelling Archive File Check Out Viewing Contents of Archive Files Viewing an Archive File Locking an Archive File Deleting Archive Files and Directories106 Viewing the Revision History of Archive Files Breaking a Lock on an Archive FileBreak File Lock Dialog Box 108 Show Revision History Dialog Box for an Archive File Setting Archive Display Filters Modifying Local Source Files Managing Local FilesChecking In Modiﬁed Files 110 Chapter 111 Understanding Symbolic Names Creating a Default Symbolic Name for Archive Files112 Symbolic Name Example Deﬁning Symbolic Names Actions and Results After Setting Symbolic Name List Symbolic Names and Revision Numbers File File YAction Result 114 SoftBench CM Command Line Man Pages Using the SoftBench CM Command Line InterfaceMan Task Description 116 Using SoftBench Editors 118 Using Editors with Projects Conﬁguring SoftBench vi Editor Conﬁguring an EditorConﬁguring SoftBench Program Editor 120 Starting the Conﬁgured SoftBench Editor 122 Editing with SoftBench XEmacs Editor Using SoftBench XEmacs Editing Multiple Files Accessing HelpSoftBench XEmacs Main Window 124 Chapter 125 SoftBench vi Editor Window Editing with SoftBench vi Editor126 Using the Mouse Pointer Versus the Text Cursor If the vi autowrite SoftBench vi Editors behavior Option Reusing the Edit Window128 Selecting, Copying, and Pasting Text Calling Other SoftBench Tools from the Editors Accessing SoftBench Static Analyzer from the EditorCompiling a Program File Building a Project Using Conﬁguration Management Setting Breakpoints in a Program File 132 Using SoftBench Class Understanding the SoftBench Class Graph/Editor Use Model Editing C++ Structures with SoftBench Class Graph/Editor134 SoftBench Class Graph/Editor Use Model 136 Synchronizing Editor Views and the Static Database Chapter 137 Viewing the Existing Class Hierarchy Using SoftBench Class Graph/Editor in Your Work138 Modifying Existing Components Creating New Components 140 Deleting Existing Components Creating a New Program Sample Use ModelsModifying an Existing Program Working with Class Templates 142 Condition Explanation 144 Using SoftBench CodeAdvisor 146 Using SoftBench CodeAdvisor Chapter 147 148 Preparing Your Program with Project Build Performing the Check Code OperationPreparing Your Program with External Build Selecting Rule Groups Accessing SoftBench CodeAdvisorChecking Your Program 150 Violations Display Viewing Violations Filtering Rule Violations Terminating SoftBench CodeAdvisor152 Chapter 153 154 Using SoftBench Debugger 156 Understanding SoftBench Debugger Chapter 157 158 Preparing Your Program for Debugging SoftBench Debugger Window Using SoftBench Debugger Window Areas160 Chapter 161 162 Tear Apart Main Toolface Tearing Apart the Main Toolface 164 Specifying the Runtime Environment Loading or Rerunning an Executable Program 166 Load Executable Dialog Box Specifying the Working Directory and Program Arguments Setting Environment VariablesSpecifying Standard I/O 168 Specifying Source Locations Adding Source Directories for External Builds Debugging Executables in a Project 170 Add Source Directories Dialog Box Stepping through Your Program Interrupting in System or Non-debuggable Routines Interrupting a Running Program172 Chapter 173 Interacting with a Standard I/O Program Interacting with Your Program174 Interacting with a Window-Smart Program Interacting with a Terminal-Smart Program 176 Specifying Program Location Specifying Identiﬁer Locations 178 Specifying Variables Chapter 179 180 Examining and Changing Data in Your Program 182 Examining Data in Your Program Printing Hex or String Values Using Debugger VariablesChanging Data in Your Program 184 Using Expressions Using Constants Viewing the Call Stack Calling Functions186 Stack View Window Viewing Thread Stacks 188 Understanding the Operation of Your Program Debugging a Program Using Breakpoints Setting and Using Breakpoints Using the Editable Source Area Setting a Breakpoint190 Break Menu Using the Breakpoint Set/Change Dialog Box Using the Break Menu192 Breakpoint Set/Change Dialog Box Viewing and Modifying Breakpoints Changing Active / Suspend Status Clearing a BreakpointChanging Verbose / Silent Status 194 Executing DDE Commands at a Breakpoint 196 Setting Group Breakpoints Setting C++ BreakpointsViewing and Modifying Group Breakpoints 198 Setting and Using Watchpoints Using the Data Watchpoint Set/Change Dialog Box Using the Watch MenuCreating Watchpoints 200 Data Watchpoint Window Viewing and Modifying Watchpoints 202 Clearing a Watchpoint Chapter 203 Tracing Program Flow Using the Trace MenuCreating Traces 204 Viewing Traces Using the Trace Set/Change Dialog BoxTrace Set/Change Dialog Box 206 Clearing Traces Editing Source Code Correcting Errors in Your Program 208 Synchronizing Files Debugging Dynamic Libraries 210 10 Dynamic Images/Libraries Dialog Box Tracing Assembly Language Viewing Assembly Language and CPU Registers 212 Tracing Registers Chapter 213 Viewing and Editing Intercepts Handling Signals and Events214 Chapter 215 216 Handling Signals Debugging After a Program Fails Core Dump Signal Error Message Text NameDebugging with a Core File 218 Debugging Forked Processes Viewing and Manipulating Threads Debugging Threaded Applications220 Setting Breakpoints on Threads 222 Attaching the Debugger to a Running Program Debugging C++ Programs 224 Accessing Inherited C++ Values Using Breakpoints for Exception HandlingDebugging Static Constructors 226 Debugging Optimized Code Specifying Debugger Options Customizing SoftBench DebuggerCustomizing User Buttons 228 Chapter 229 230 Chapter 231 232 Offset argument. Chapter 233 234 Using SoftBench Debugger Data Beginning a Browsing Session Starting and Stopping the Data Graph WindowStopping a Browsing Session 236 Understanding the Layout Control Area Understanding Data Graph Window AreasData Graph Window Areas Understanding the Graph Area Understanding the Display Control Area238 Object Selected Actions Allowed Data Graph Window Action MenusReading Nodes Understanding the Window Control Area Using Dialog BoxesReading Arcs 240 Using the Node Values Dialog Box Using the Graph AreaDisplaying New Nodes 242 Node Values Dialog Box Node Values Dialog Box Action Menu Setting Data Member ValuesDisplaying Data Members Following Selected Pointers Deactivating the Graph Suspending Graph UpdatesStopping a Graph Process 244 Viewing btree Verifying Correct Data Structures Continuing Program Execution Binary Tree NodeBinary Tree Node with Children 246 Showing Nodes Viewing Values of Data MembersDereferencing Particular Data Members Viewing Embedded Arrays Viewing Values from Multiple NodesViewing Values from Embedded Arrays Showing Values On the Graph Viewing Data Members on The Graph Nodes 250 Using SoftBench Static 252 Starting SoftBench Static Analyzer Chapter 253 Generating Static Data Preparing to Make Queries254 Updating Static Data without Building Using the Default Analysis File SetSpecifying Static Data to Analyze Including Subprojects and Parent Projects Keeping Analysis Files Current Customizing the File Set in Non-Project Mode256 Determining the File Set Status Filtering Queries by File Set 258 Using SoftBench Static Analyzer Window Areas SoftBench Static Analyzer Window and Areas Making General Queries Making Textual Static QueriesMaking Queries Based on a Program Identiﬁer 260 Understanding the Types of References Selecting Text Determining Identiﬁer Classiﬁcation Relationships among Reference Queries262 Using Pattern Matching Troubleshooting Invalid Identiﬁers for Queries Browsing the Query Result Using Query ResultsEditing the Source File Updating the Database Performing a Query Command Description Filtering Results Using the File SetSimplifying Query Results SoftBench Static Analyzer Display Options Filtered Source File List Unﬁltered Source File List Filtering C++ Query Results Using Scoping268 Scoping Prerequisites and Constraints Troubleshooting Scoping InformationScoping Example 270 Redisplaying Query Results Redisplaying Past QueriesDeleting a Query Result Saving and Printing a Query Result 272 Generating Static Data from the Command Line Using SoftBench Static Analyzer in Standalone ModeSearching Subdirectories 274 Using the Staticﬁleset File Customizing SoftBench Static Analyzer Analysis ﬁle set choose F ile Condition or Message Explanation276 Chapter 277 278 Chapter 279 280 Staticrmﬁle1 Chapter 281 282 Using Static Graphs 284 Starting SoftBench Static Analyzer Graphs Making Graphical Static Queries General Static Graph Features286 Operating on Static Graph Nodes Finding Graph Nodes Displaying Nodes on Another Graph Switching between Static Graphs288 Function Description Dialog Box Using Description Boxes Saving Static Graph Images to Files Setting Breakpoints for SoftBench Debugger290 Chapter 291 Reducing Graph Complexity Simplifying Graph Displays292 Filtering Sourceless Nodes Removing the Graph Legend Viewing Multiple Graphs Customizing Static Graphs294 Using SoftBench File Compare Understanding the Menu Bar Understanding the SoftBench File Compare WindowUnderstanding the Working Directory Input Box 296 Using the Merge File Input Box Using the Left File and Right File Input BoxesUnderstanding the Text Areas Reading the Gutter Column Left Right Selection Column Selecting Lines for Merging298 Traversing by Single Line Highlighting Differences 300 Comparing Two Files Merging Compared Files 302 Chapter 303 304 Using SoftBench Message Monitor 306 Starting SoftBench Message Monitor Understanding Broadcast Messages Understanding the SoftBench Message Monitor Window Area 308 Clearing the Broadcast Message Area Send Message Dialog Box Composing and Sending a Message 310 For SoftBench XEmacs Specifying a Log File Logging MessagesStarting and Stopping Message Logging 312 Using SoftBench with SQL 314 Determining Supported Environments Using SQL with Project Build Using Default SQL File TypesConﬁguring SoftBench with SQL SQL File Extensions for C Language 316 Updating Rdbms Versions Using SQL with External Build 318 Using SQL Preprocessor Wrappers Using SQL with SoftBench ToolsDebugging with SQL 320 Debugging Expanded SQL Statements Editing and Rebuilding with SQL for SoftBench Debugger 322 Using SoftBench Graph Windows 324 Accessing SoftBench Graph Windows Appendix a 325 Using Popup Menus Using Graph Window AreasUsing Save Options for the Graph Image 326 Figure A-1 Save Image Dialog Box Table A-2 Graph Image File Formats Option Used for Saving HP-GL and PostScript Images Using Graph File Image Save Options328 Saving xwd Images 330 Using Vertical and Horizontal Scrolling Clearing the Graph Area Zooming In or Zooming Out Reading Graph Area Nodes Understanding Nodes and ArcsSelecting Nodes and Arcs 332 Appendix a 333 Moving Nodes Table A-4 Methods for Selecting Multiple Objects Procedure334 Appendix a 335 Customizing SoftBench Graphs Menu settingsControlling Graph Layout Controlling Graph Display Understanding Window Status Information 338 Customizing SoftBench CM Conﬁguration Table B-1 Server Conﬁguration Files File Name Description Modifying the Conﬁguration Files340 Figure B-1 File Mapping Between Local and Archive Files Conﬁguring Where Archive Files are Stored 342 Deﬁning User Access to the Server Appendix B 343 344 Format 1. Place user ﬁeld ﬁrst and permissions ﬁeld second Recommended Format for Permissions FileFormat 2. Place path ﬁeld ﬁrst and permissions ﬁeld second 346 Setting Logging and Debug Options Appendix B 347 Migrating Archive Files From RCS Performing SoftBench CM Administrator TasksMigrating Archive Files From Sccs 348 Modifying the Lockinfo File Creating Archive BackupsMoving Archive Storage Locations 350 Using the Archive Status and Error Log TroubleshootingUsing the Archive Activity Log 352 Using Regular Expressions 354 Pattern Matching Appendix C 355 356 Appendix C 357 358 Appendix C 359 360 Customizing SoftBench for Native Language Support NLS 362 Preparing to Use NLS in SoftBench Appendix D 363 Table D-1 To have Lang apply to Set Lang Setting the Lang Environment Variable364 Converting from One Encoding Method to Another 366 Rebinding Alt Changing or Removing Menu Mnemonics SoftBench Mnemonics and Non-USASCII Character Inputs 368 Customizing Keyboard Accelerators 370 Starting Your Localized SoftBench 372 Remote Execution Hosts and NLS Character Input Example Editing in SoftBench 374 375 Glossary 376 377 378 379 380 381 382 383 384 See also Project Root 385 386 387 388 Index Symbols389 390 391 CDE 392 393 394 395 396 397 398 399 400 401 402 403 Graph, 47, 66 404 405