SupportConnect - Advantage VISION Newsletter, Version 05.01
  

NOTE: E-News technical information is dynamic and links in archived copies of these technical newsletters may eventually become invalid as the products evolve. Please check the support web page for your product to get the latest technical information.


Computer Associates
E-News
Advantage™ VISION Newsletter
Version 05.01
July 13, 2005

In This Newsletter
Product News
> Searching for Advantage™ VISION:Report® r17.0 for z/OS Beta Testers

General Information
> Advantage™ VISION:Builder® and DB2 Database Access
> The Advantage™ VISION:Inform® Password Exit Facility
> Frequency Distributions Reporting Using Advantage™ VISION:Excel®
> Advantage™ VISION:Inquiry® - Native SQL Syntax Support
> Advantage™ VISION:Results® - Simplifying Coding Requirements for the CSV Function

Special Events
> CA Education Opportunities

Product News
Searching for Advantage™ VISION:Report® r17.0 for z/OS Beta Testers
We are pleased to announce that Advantage VISION:Report r17.0 for z/OS is in Beta status. Beta participants have the unique opportunity to gain early access to new features and enhancements, and contribute directly to the success of the release. We measure our success on customer satisfaction and active input from Beta sites is a key requirement in the product release cycle. If you are interested, click here to visit our Beta Home page for more information on features, benefits, prerequisites, and registration.

Some of the exciting new features of this beta release are:
  • DB2 Connect command - This enables a single program to connect to multiple DB2 servers running in another region or machine.
  • DB2 Stored Procedures - New functions for the optional interface to DB2 include Allocate Cursor, Associate Locators, Describe Procedure, Free Locator, and Hold Locator.
  • New Data Types - New data types now supported include binary characters and double byte large objects and row IDs.
  • QUIKPDS Update Directory - When using the expanded Directory option, QUIKPDScan now performs updates to the directory for create date, changed date, and time of update.
  • Support to access IMS/DB or DL/I databases - With the IMS Interface optional feature, user-coded subroutines can access directly IMS databases.

Top
General Information
Advantage™ VISION:Builder® and DB2 Database Access
Extracting, reporting, or analyzing data residing in DB2 databases is a recurring requirement for business information users. Advantage VISION:Builder and Advantage™ VISION:Two are easy-to-use tools that can assist you in accessing the relevant data residing in your DB2 databases. For more information about accessing DB2 data using Advantage VISION:Builder, click here.

Top
The Advantage™ VISION:Inform® Password Exit Facility
Advantage VISION:Inform Release 4.0 introduced new functionality to its Profile Exit facility that allows user control of userid and password validation. This exit allows the user code to invoke shop standard security calls to such Security packages as ACF2, Top Secret, and RACF. To learn more about this facility and to see an example of Profile Exit code, click here.

Top
Frequency Distributions Reporting Using Advantage™ VISION:Excel®
Frequency Distribution is a method used to summarize and organize a set of data. In tabular form, a simple Frequency Distribution consist of two columns; one column listing a value and the other column listing the count of that value. Click here to learn more about how Advantage VISION:Excel can produce Frequency distributions tables, histograms, and the formulas with relative ease.

Top
Advantage™ VISION:Inquiry® - Native SQL Syntax Support
The native SQL syntax support allows you to use embedded SQL SELECT statements in your inquiries. System Administrators and users who know SQL can use and take advantage of the full functionality of the SQL SELECT statement to access DB2 tables. The DB2 tables accessed through this facility are not required to be defined in the Advantage VISION:Inquiry system database. They are accessed directly from the DB2 catalog.

This facility can only be used if you have the DB2 option of the product installed on your system.

For more information on how to use the native Syntax support, click here.

Top
Advantage™ VISION:Results® - Simplifying Coding Requirements for the CSV Function
Included among the many formats of data supported by Advantage VISION:Results are CSV files. CSV (Comma-separated values) is a tabular data format that has fields separated by the comma character and quoted by the double quote character.

As you may be aware, a call to CSVRSLT is required for each field you desire to add to your CSV file; as a result, a requirement for many fields could result in a somewhat long and verbose program. Do not, however, write off using CSVRSLT just yet. The use of CSV copy support routines, CSVWORK and CSVCALL, has made CSV conversion easier.

For more information on simplifying coding requirements on the CSV function, click here.

Top
Special Events
CA Education Opportunities
CA Education offers hundreds of instructor-led and computer-based training courses on the management software that runs your business. Get trained in one of our state-of-the-art North American Learning Centers, on the Web or via CD-ROM, or arrange for onsite training at the location of your choice.

For information on all CA Education opportunities, please visit our website or call us
at 1-800-237-9273.

Top


You are subscribed as &*TO;.

To subscribe, unsubscribe, or change the format for this or other newsletters, please go to our E-News subscription page. You can also unsubscribe by sending an email to: editor_enews@ca.com with "Unsubscribe enews_vision" (without the quotes) in the message body. You must include the exact email address that you wish to unsubscribe.
Feedback? Comments? Suggestions?
Send an email to: editor_enews@ca.com. All submissions become the property of the publisher and may or may not be reprinted.
NOTE: This address should be used only for feedback on this newsletter. Requests for technical support should be submitted through normal channels.

Computer Associates
 
 
 
Page Tools
printPrint