documentation
.HELP!
LANSA Client Documentation
LANSA Client User Guide
LANSA Client
previous page
next page
LANSA Client User Guide
LANSA Client User Guide
About this Guide
Introduction
Getting Started
Creating and Running Queries
Working with Query Results
Creating Charts
Generating Applications
Automating Query Execution
Commands
Troubleshooting
Tutorials
Set Up the Tutorial Files
Appendix A. Error Message Codes
Edition Date October 22, 2014
© LANSA
previous page
start
next page
Menu
Homepage
Table of contents
LANSA Client User Guide
About this Guide
1. Introduction
1.1 LANSA Client - Discovering Information
1.2 What Can You Do with LANSA Client?
1.3 How Does LANSA Client Work?
1.4 What are the LANSA Client components?
1.5 The LANSA Object Repository
2. Getting Started
2.1 Start LANSA Client
2.2 Host Selection
2.3 LANSA Client Main Window
2.3.1 What LANSA Client Help is available?
2.4 LANSA Client Alternate Window
2.4.1 Refresh the Local Data Dictionary
3. Create and Run Queries
3.1 Steps to Create a Query
3.1.1 Enhance your Query
3.2 What is in the Query Window?
3.3 The Files to Select From
3.3.1 Display the Object Names
3.3.2 Ordering the Files
3.3.3 Limit the Files Displayed
3.3.4 Select Fields
3.3.5 Help for Your Fields
3.4 The Selected Files and Fields Area
3.5 The Defined Links to Queries Area
3.5.1 Rename Linked Queries
3.6 Sort Your Data
3.7 Select Only Specific Data
3.7.1 The Operation Area
3.7.2 The Prompting Area
3.7.3 The Conditions Area
3.7.4 Add a Search Condition
3.7.5 Change a Search Condition
3.7.6 Delete a Search Condition
3.8 Select Date & Time Format
3.9 Group Your Data
3.10 Summarize Your Data
3.11 Performance Considerations
3.12 Open an Existing Query
3.13 Run a Query
3.14 Save a Query
3.15 Cancel a Query
3.16 Delete a Query
4. Work with Query Results
4.1 About the Results Window
4.2 Enhance Your Results
4.2.1 Use Edit Codes to Format your Output
4.3 Date Time formatting
4.4 Collapse and Expand Your Results
4.5 Copy from the Results Window
4.6 Chart Results
4.7 Save the Results
4.8 Convert the Results to a Report
4.8.1 Create a New Report
4.8.2 Attach an Existing Report to a Query
4.9 Print the Results
4.10 Execute a Linked Query
4.11 Edit/Insert/Delete Facilities
4.11.1 Edit Data
DateTime Selection
4.11.2 Insert Data
4.11.3 Delete Data
5. Create Charts
5.1 Create a New Chart
5.2 Select the Chart Type
5.3 Customize a Chart
5.4 Multiple Chart Windows
5.5 Interactive Hot Charts
5.6 Special Effects with Pie Charts
5.7 Copy a Chart into Another Application
5.8 Print a Chart
5.9 Save a Chart
6. Generate Applications
6.1 Overview
6.2 Design Your Application
6.2.1 Generate Application Dialog Box
6.3 The Menu Bar
6.3.1 Add to the Menu Bar
6.3.2 Add a New Menu
6.3.3 Select a Query and Add Commands
6.3.4 Change a Command
6.3.5 Delete a Command
6.3.6 Re-organize the Commands on the Menu Bar
6.4 Run the Generated Application
6.5 Application Maintenance
7. Automate Query Execution
7.1 How It Works
7.1.1 Run a Query in Batch Mode
7.1.2 Run a Query Interactively
7.1.3 Specify the Host
7.1.4 What if You Have a Prompt?
7.1.5 Control Report Options
7.1.6 Specify Parameters via an Input File
7.1.7 Batch Mode Troubleshooting
8. Commands
8.1 The Menu Bar
8.2 File Menu
8.2.1 New
8.2.2 Open
8.2.3 Run
8.2.4 File Overrides
8.2.5 Save
8.2.6 Save As
8.2.7 Close
8.2.8 Print
8.2.9 Printer Setup
8.2.10 Generate
8.2.11 Disconnect
8.2.12 Exit
8.3 Edit Menu
8.3.1 Copy
8.4 Options Menu
8.4.1 Group By
8.4.2 Sort Options
8.4.3 Summary Options
8.4.4 Join Type Options
8.4.5 Field Conditions
8.4.6 Date Time Formats
8.4.7 File Filter
8.4.8 Order Files by
8.4.9 Display Object Name
8.4.10 Display Logical Files (Views)
8.4.11 Display Physical Files
8.4.12 Set Language
8.4.13 View
8.5 Query Menu
8.5.1 Execute
8.5.2 Cancel Query
8.5.3 Output To
8.5.4 Output Options
8.5.5 Output to Report Options
8.5.6 Linked Query Option
8.6 Results Menu
8.6.1 Chart
8.6.2 Linked Queries
8.6.3 Edit Row
8.6.4 Insert Row
8.6.5 Delete Row
8.6.6 Expand Group & Collapse Group
8.6.7 Report
8.6.8 Report Designer
8.7 Chart Menu
8.7.1 Options
8.7.2 Chart Types...
8.8 Window Menu
8.8.1 New Window
8.8.2 Tile
8.8.3 Cascade
8.8.4 Freeze
8.8.5 Arrange Icons
8.9 Help Menu
8.9.1 Help Topics
8.9.2 About LANSA Client...
9. Troubleshooting
9.1 Getting Started
9.2 LANSA Client
9.3 Error Messages
9.4 Crystal Reports
LANSA Client Tutorials
Before you Begin
LCL001 - Start LANSA Client
LCL002 - Run a Simple Shipped Query
Step 1. Open an Existing Query
Step 2. Attach Selection Conditions to the Query
Step 3. Execute the Query
LCL003 - Enhance Query Results, Report and Chart
Step 1. Add Summaries
Step 2. Group your Results
Step 3. Contract and Expand your Results
Step 4. Display the Results using a Report Format
Step 5. Chart Results
Step 6. Customize the Chart
Step 7. Use the Hot Chart Facility
What I should know
LCL004 - Edit Data
LCL005 - Build, Execute and Save a Join Query
Save the Query
LCL006 - Build, Execute and Save a Linked Query
Step 1. Create the first query
Step 2. Select the fields for the query
Step 3. Define the link for the second query
Step 4. Select the fields for the linked or secondary query
Step 5. Save the Linked Query
Step 6. Run the Linked Query
LCL007 - Generate an Application
Step 1. Create a New Generated Application
Step 2. Define your Application
Step 3. Add a new menu to the application's menu bar
Step 4. Add Commands to the new Queries Menu
Step 5. Add more Commands to the new Menu
Step 6. Run the Generated Application
Step 7. Distribute a Generated Application
LCL008 - Create a LANSA Client Environment
Define the Host & its Options
Set up the Tutorial files
IBM i Host
Step 1. Create a New Library
Step 2. Create the New Partition
Step 3. Use other Languages
Step 4. Add the LANSA Client Tutorial files
Windows Host
Step 1. Create the New Partition
Step 2. Add the LANSA Client Tutorial files
Appendix A. Error Message Codes
LANSA Open Error Codes
Error Code 3 - Internal Error Reason Codes
Error Code 23 - CPI-C Return Codes
Get in touch
Submit feedback about this site to:
[email protected]