| ESL DB/Assist |
| Getting Started with DB/Assist |
| Introduction to DB/Assist |
 | What is DB/Assist? |
| What Do You Need to Know to Use DB/Assist? |
| What Do You Need to Run DB/Assist? |
| How Do You Use DB/Assist to Build An ESL Application? |
| How Can You Learn to Use DB/Assist? |
| Starting DB/Assist |
| Familiarizing Yourself with the Main Window |
| Title Bar |
| Menu Bar |
| SQL Access Module Button Bar |
| SQL Statement Button Bar |
| SQL Editor Window and Push Buttons |
| Status Area |
| Using Online Help |
| Getting Help for Menu Bars and Menu Choices |
| Getting Help for Dialog Boxes |
| Help Index |
| HelpContents |
| HelpSearch |
| Changing Your Working Directory |
| Exiting DB/Assist |
| Sample Session |
| Building a Client/Server Application |
| Before You Start |
| Running the Admin Application |
| Overview of the Sample Session |
| Lesson 1: Connecting to the SAMPLE Database |
| Lesson 2: Building a SELECT Statement |
| Lesson 3: Adding a New Employee to the SAMPLE Database |
| Lesson 4: Updating and Deleting Employees from the SAMPLE Database |
| Lesson 5: Creating a Join Clause Between Two SAMPLE Database Tables |
| Managing SQL Access Modules |
| Introduction to SQL Access Modules |
| Creating a New SAM |
| Opening an Existing SAM |
| Changing SAM Settings |
| Saving SAMs |
| Using Save |
| Using Save As |
| Opening Another SAM Without Saving the Current SAM |
| Getting Started with SQL Statements |
| Steps for Building SQL Statements |
| Creating a New SQL Statement |
| Opening an Existing SQL Statement |
| Using the Open SQL Statement Dialog Box |
| Using the Statement Drop-Down List |
| Methods for Building SQL Statements |
| Importing a Statement into DB/Assist |
| Typing a Statement in the SQL Editor Window |
| Completing the Statement Construction Dialog Boxes |
| Using Different Methods to Build SQL Statements |
| Setting Statement Options |
| Setting the Word Wrap Option |
| Setting Table and Result Options |
| Viewing Your Database |
| Examining Column Attributes |
| Examining Indexes |
| Examining Primary/Foreign Key Relationships |
| Building SQL Statements |
| Selecting Tables and Columns for SELECT, UPDATE, and INSERT Statements |
| Steps for Selecting Tables and Columns |
| Removing Columns from the Selected Columns List Box |
| Rearranging Columns in the Selected Columns List Box |
| Deselecting Columns |
| Setting Options for the Table List |
| Building a SELECT Statement |
| Building a Basic SELECT Statement |
| Adding a Computed Column |
| Adding a WHERE Clause |
| Adding a Join Clause |
| Adding a GROUP BY Clause |
| Adding an ORDER BY Clause |
| Building a Single-Row SELECT Statement |
| Building an UPDATE Statement |
| Building a Searched UPDATE Statement |
| Building a Positioned UPDATE Statement |
| Building a DELETE Statement |
| Building a Searched DELETE Statement |
| Building a Positioned DELETE Statement |
| Building an INSERT Statement |
| Building an Other Type Statement |
| Validating Statement Syntax |
| Managing SQL Statements |
| Running a SQL Statement |
| Overview of Run Procedures |
| Using the Result Set Window |
| Using the Input Values Dialog Box |
| Using the Run Complete Dialog Box |
| Displaying SQL Statements |
| Changing a SQL Statement |
| Changing the Name and Description |
| Changing the Syntax |
| Deleting the Statement |
| Exporting SQL Statements |
| Exporting a Statement to the Clipboard |
| Exporting a Statement to a File |
| Linking Variables to SQL Statements |
| Introduction to Linking Variables |
| Linking Variables |
| Using the Link Variables Dialog Box |
| Automatically Creating a Variable |
| Creating a New Variable |
| Linking Columns with Predefined Variables |
| Creating a Variable File |
| Typing Variables in the SQL Editor Window |
| Compiling SQL Access Modules |
| Introduction to Compiling SAMs |
| Before You Start |
| Setting Compile Options |
| Compiling a SAM |
| Using the Generated Code in Your Application |
| Steps for Compiling SAMs |
| Setting Compile Options |
| Setting Bind Options |
| Setting Code Generation Options for a SAM |
| Setting Code Generation Options for a Statement |
| Understanding the Compile Process |
| What Happens During a Compile |
| Required Include Files |
| Verifying the SAM |
| Handling Compile Errors |
| Compiling |
| Displaying the Log |
| Displaying the Log in DB/Assist |
| Displaying the VIEWLOG.TXT File |
| Examples of Generated ESL Code |
| Overview of Generated Code |
| Sample Code for SELECT |
| Sample Code for UPDATE |
| Sample Code for EDB2WheneverError |
| Developing Applications with DB/Assist |
| Benefits of Using DB/Assist |
| Cursor-Based SQL Statements |
| Static SQL |
| Planning the Application and Database |
| Organizing the Application |
| Using SAMs |
| Creating a File Structure |
| Building Applications with DB/Assist |
| Building the Variable File |
| Running DB/Assist |
| Guidelines for Using DB/Assist |
| Avoiding Duplicate Action Routine Names |
| SAMs and Bind Files |
| Distributing the Application |
| Sample Program for Positioned SQL |
| Overview of the Sample Program |
| Creating the Program with DB/Assist |
| Sample ESL Code |
| DB/Assist Main Window |
| Main Window |
| DB/Assist Menu Bar |
| SQL Access Module Button Bar |
| SQL Statement Button Bar |
| SQL Editor Window |
| SQL Editor Window Push Buttons |
| Status Area |
| Menu Choices |
| SQL Access Module Menu |
| SQL Statement Menu |
| Database Menu |
| Options Menu |
| Help Menu |
| Dialog Boxes (SQL Access Module) |
| New SQL Access Module Dialog Box |
| SQL Access Module Settings Dialog |
| Bind Options Dialog Box |
| Code Generation Options Dialog Box |
| Dialog Boxes (SQL Statement) |
| New SQL Statement Dialog Box |
| Open SQL Statement Dialog Box |
| SQL Statement Description Dialog Box |
| SELECT/FROM Clause Dialog |
| UPDATE/SET Clause Dialog Box |
| INSERT/INTO Clause Dialog Box |
| DELETE/FROM Clause Dialog Box |
| Computed Column Dialog Box |
| WHERE Clause Dialog Box |
| Join Clause Dialog Box |
| GROUP BY Clause Dialog Box |
| Having Clause Dialog Box |
| ORDER BY Clause Dialog Box |
| Input Values Dialog Box |
| Run Complete Dialog Box |
| View Table Window |
| Result Set Window |
| Link Variable Dialog Box |
| New Variable Dialog Box |
| Assign Variable Types Dialog Box |
| Code Generation-Statement Options Dialog Box |
| Ambiguous Statement Dialog Box |
| Dialog Boxes (Database) |
| Database Schema Dialog Box |
| Primary Keys Dialog Box |
| Foreign Keys Dialog Box |
| Table and Result Options Dialog Box |
| Keys Help, DB/Assist |
| FAQs |
| Q1 Why should I use a prototype of the production database? |
| Q2 Why are there no tables accessible by DB/Assist? |
| Q3 What does DB/Assist create? |
| Q4 How do I Connect and Disconnect from the DB/2 Database? |
| Q5 What action routines are generated by DB/Assist ? |
| Q6 What Application Logic is needed to surround the SQL Statements ? |
| Q7 How do I manage errors when using the EDB2 facilities? |
| Q8 What does a negative SQLCODE mean? |
| Q9 What does a positive SQLCODE mean? |
| Q10 What does an SQLCODE of 100 mean? |
| Q11 What does an SQLCODE of 0 mean? |
| Q12 What happens when the Compile option is used? |
| Q13 How will I know that the SQL Statements have been compiled successfully? |
| Q14 What is Binding? |
| Q15 What does an SQL Access Module (.SAM file) contain? |
| Q16 What does a Bind file (.BND file) contain? |
| Q17 What is an Access plan (access package) ? |
| Q18 How do I correct an Out of date .BND file ERROR? |
| Q19 Should I Distribute the .BND file with the ESL Applications? |
| Q20 What are the Options for Binding? |
| Q21 Can I use Outer join statements? |
| Q22 Why can't I set a null indicator for a host variable? |
© 2011 ESL Syndetic Ltd.