Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 
Support > Technical Documents > Document Types > Release Bulletin > Release Bulletin EDI Products 5.0

Release Bulletin EDI Products 5.0

Documents known problems and changes to installation, documentation and functionality for EDI Products version 5.0 on HP-UX, IBM AIX 5L + 5.3, Sun Solaris 2.10, and Windows.
 
RSS Feed
 
 
 

Release Bulletin EDI Products 5.0

 

Document ID: DC00191-01-0500-01

Last revised: February 13, 2007



Accessing current release bulletin information

A more recent version of this release bulletin may be available on the Web. To check for critical product or document information added after the product release, use the Sybase Product Manuals Web site.

Accessing release bulletins at the Sybase Product Manuals Web site
  1. Go to Product Manuals.

  2. Select a product and language and click Go.

  3. Select a product version from the Document Set list.

  4. Select the Release Bulletins link.

  5. From the list of individual documents, select the link to the release bulletin for your platform. You can either download the PDF version or browse the document online.



Product summary

Enclosed is Sybase® EDI Products 5.0. For the latest supported platforms and databases for EDI Products, see the Availability and Certification Reports Web site.


Supported platforms

Table 1 lists the supported operating systems for EDI Products 5.0:

Table 1: Supported operating systems for EDI Products 5.0

Platform

Operating system and version

UNIX

  • HP-UX 11i v2

  • IBM AIX 5L and 5.3

  • Sun Solaris 2.10

Windows

  • Windows 2003 with Service Pack 1

  • Windows XP Professional with Service Pack 2


Supported databases

These are the supported database systems for EDI Products 5.0:

  • Sybase Adaptive Server® Enterprise version 12.5 and 15.0 or later

  • IBM DB2 v8.2

    Note:If you plan to use IBM DB2, you must bind the ODBC driver to the database. MS MDAC does not include a DB2 driver. For more information about binding, see either the DataDirect ODBC driver documentation or the IBM ODBC driver documentation.

  • Oracle 10g release 2

  • Microsoft SQL Server 2005

  • Microsoft Access 2000 or later in a development environment only


Component-specific requirements

Components in EDI Products 5.0 have specific requirements. These component-specific requirements are described in detail in “Additional requirements,” in Chapter 1, “Before You Begin” in the EDI Products 5.0 Installation Guide.


Version contents

The Sybase EDI Products 5.0 product set consists of powerful components that meet the needs of any organization processing EDI:

  • ECMAP™ – a mapping tool for developing maps to validate or process EDI transactions.

  • ECMAP Network Client – client for the optional network installation of ECMAP.

  • ECMAP Debugger – an add-on product to ECMAP that enables developers to debug their maps by controlling the execution of maps, on a command-by-command basis, and monitor the data values of variables and record fields as the map runs.

  • EC Gateway™ – an EDI message management component for scripting, scheduling, data communications, and operations management.

  • EC Gateway Operations Viewer – used to monitor the operations of EC Gateway.

  • ECRTP™ – is both a data transformation engine that analyzes, transforms, and routes messages, and a compliance-verification engine that checks EDI data against the corresponding EDI standard.

  • ECRTP/TP – a customized version of ECRTP for OEMs that also provides for trading partner administration.

Sybase also distributes the Sybase EDI Server 5.0 product bundle which consists of:

  • ECMAP

  • EC Gateway

  • EC Gateway Operations Viewer

  • ECRTP

For information on selecting license types for the components within the EDI Server bundle, see “Selecting license types for EDI Server components”.


Sybase Software Asset Management

Sybase EDI Products version 5.0 and later uses Sybase Software Asset Management (SySAM) for license administration and asset management tasks.

SySAM-enabled components in EDI Products 5.0 use SySAM to perform runtime verification of licenses every time you start the product. If the required license is not available, the product does not run. This differs from the license verification in earlier versions, which was performed only during installation. See the EDI Products 5.0 Installation Guide for more information.


Installation grace periods

Most SySAM-enabled products work for an initial grace period without a license. If you do not install a valid license for your configuration within the installation grace period, the product ceases to function.

EDI Products for UNIX platforms does not currently support installation grace periods.

ECMAP Debugger does not support installation grace periods. To evaluate ECMAP Debugger, you can obtain a formal Trial License. Call 1-800-8-SYBASE.



Installation instructions

For installation instructions and information on system requirements, supported platforms, and supported databases, see the EDI Products 5.0 Installation Guide.


Selecting license types for EDI Server components

When you are installing the components within the EDI Server bundle, select the license type of the EDI Server bundle in the Product License Information window. Do not select the license type of the component you are installing.

For example, Table 2 shows the EDI Server bundle with the Production (CP) license type and its components:

Table 2: Components in EDI Server bundle with CP license

Component

Quantity

Authorized use

ECRTP

1

Production

ECRTP

3

Standby

ECMAP

2

Development/Test (not CPU-dependent)

ECRTP

2

Development/Test (not CPU-dependent)

EC Gateway

1

Production

EC Gateway

3

Standby

In this example, to install an ECRTP component in this bundle as a standby, select CP as the license type for the ECRTP component in the Product License Information window. For information on license types and components in the EDI Products product suite, and in the EDI Server bundle, see Appendix A, “Decoding EDI Licences” in the EDI Products 5.0 Installation Guide.

If you are installing an ECRTP component that is not part of an EDI Server bundle, select the license type for this individually-licensed ECRTP.



Changed functionality in this version

For detailed descriptions of the new features and functionality in EDI Products 5.0, see the EDI Products 5.0 New Features Guide.



ECMAP


Resolved CRs

Table 3: Resolved ECMAP CRs

CR#

Description

431507

Problem: Decimal Implicit field does not zero fill with binary nulls when the field length is larger than 15.

Resolution: Decimal Implicit field is zero filled by default, no matter which zero filling option is chosen. The null value has been removed.



EC Gateway


Updates and clarifications


Moving messages on and off queue

If your script includes multiple GetMessage statements, you must include explicit commands to move messages on and off the queue.

Each GetMessage statement gets a message from the queue; the message remains on the queue but is marked as having been read. To permanently remove the message from the queue, use a RemoveMessage command. To replace the message on the queue, as though it had not been read, use the RestoreMessage command.


Scheduling tasks at the end of the year

If you want Scheduler to run tasks from the end of one year to a next date in the upcoming year, check the End Date/Time values in Advanced Scheduling. Set the correct field values or disable them completely.

Scheduling year-end processing
  1. Start the Scheduler module.

  2. Click Task and choose Add, or right-click a task and choose Edit.

  3. Select the Scheduler tab. From the Frequency drop-down list, select Monthly.

  4. In the Properties group, select Run each month(s) using the next scheduled.

  5. Click Months, then select the months you want to schedule the run.

  6. Click Advance Scheduling. Either:

    • Verify the End Date/Time fields values are correct, or

    • Unselect the End Date/Time check box. You must unselect this value for monthly transactions to cross yearly boundaries.


Setting the polling intervals in UNIX

You can use the -r switch followed by the number of seconds to set the scheduling resolution from the command line when you start the UNIX Scheduler daemon. Sybase recommends a time greater than 5 seconds and less than 60 seconds, depending on the frequency and number of tasks you need to run.


Database size

Although the amount of free space you require to upgrade the log table varies, the amount of free space in the database should be greater than the size (including data) of the TRLOG current log table. If the amount of free space is greater, the upgrade should succeed.


997 Run IDs

wsproces command line arguments support parameter passing, including run IDs for 997 maps. The switches for these parameters are –p1 to –p20. With these switches, you can pass parameters from the command line to scripts. This feature is supported by both the wsproces DLL and executable. See the EDI Products 5.0 New Features Guide for additional information.


Switch options

See the EDI Products 5.0 New Features Guide for a list of current and obsolete switches.


Additional table documentation

Table 4, Table 5, and Table 6 contain additional documentation about the ACKTA1, SYS_SECU, and PWD_GEN database tables respectively.

Table 4: ACKTA1 table

Column name

Data type

Length

Description

RUN_ID

Integer

9

Normal Run ID

RUN_DATE

Date/Time

8

Normal run date

SEND_QUAL

Alphanumeric

4

Sender qualifier from originating interchange

SEND_CODE

Alphanumeric

35

Sender code from originating interchange

RECV_QUAL

Alphanumeric

4

Receiver qualifier form originating interchange

RECV_CODE

Alphanumeric

35

Receiver code from originating interchange

INTERCHANG

Alphanumeric

35

Interchange control number

ORIG_INT_NUM

Alphanumeric

35

Interchange control number from originating interchange

ORIG_DATE

Alphanumeric

6

Date of originating interchange

ORIG_TIME

Alphanumeric

4

Time of originating interchange

INT_ACK_CD

Alphanumeric

1

Acknowledgment code for originating interchange (Accepted, Rejected, and so on)

INT_NOTE_CD

Alphanumeric

3

Type of error (if any) for the originating interchange

Table 5: SYS_SECU table

Column name

Data type

Length

Description

GW_VERSION

Alphanumeric

50

Gateway version number

ONE_USERID

Alphanumeric

1

Flag for unique user ID for communications channels

ONE_LOGIN

Alphanumeric

1

Flag for unique login for each communications channel

ONE_ALPHA

Alphanumeric

1

Flag for at least one alphabetic character in the password of communications channels

ONE_DIGIT

Alphanumeric

1

Flag for at least one numeric character in the password of asynchronous channels

PWD_MINLEN

Integer

10

Minimum password length in communications channels

BAD_ATTEMP

Integer

10

Lockout after bad attempts

PWD_EXPIRE

Integer

10

Password expires after days

PWD_GEN

Integer

10

Generations for password history

Table 6: PWD_GEN table

Column name

Data type

Length

Description

USER_ID

Alphanumeric

50

User ID for the gateway communications channels

USER_TYPE

Alphanumeric

50

Communication channel type

PWD_GEN

Integer

10

Which generation for the password history

USER_PWD

Alphanumeric

50

Password for the gateway communications channels



ECRTP


Resolved CRs

Table 7: Resolved ECRTP CRs

CR#

Description

426478

Problem: NCPDP Batch Response fails to run and displays the “Transmission Header Invalid” error message.

Resolution: Corrected errors in ECRTP Edits for Batch Response.


Updates and clarifications


Multiple file processing and KeyField/Linkfield match

ECRTP uses KeyFields and LinkFields to process outbound user files. While being read a record remains in the buffer even if a KeyField/LinkField break was hit. The record remains in memory by design.

For example, if ECRTP processes a purchase order file and a line item file, RTP reads a purchase order number, and then starts to read line items from the line item file. When RTP reads a line item record that does not share the same link field with the purchase order, the program stops processing, but keeps the line item record in memory. Processing of the line item record occurs after RTP reads a new purchase order that matches the line item record’s link field.


File-size limitation

ECRTP has a limit of 2GB on the maximum file size it can process.



Documentation updates and clarifications

This section contains updates and clarifications to the EDI Products documentation.


ECMAP User Guide

This section describes updates to the ECMAP User Guide.


Zero fill for the Decimal Implicit (DI) and Signed Decimal (SD)

[CR# 431174] In “Working with fields,” in “Performing field-related activities,” in Chapter 9, “Working with Records and Tables” in the ECMAP 4.2 User Guide, step 4 of the procedure for “Adding a new field to a record” should be modified. The references to zero fill for the Decimal Implicit (DI) and Signed Decimal (SD) field types are incorrect. Step 4 should be:

Enter the following information under Edits on the Options tab:

  • Justification for a field:

    • L – left-justification. The data in the field begins in the leftmost column of the field.

    • R – Right-justification. The data in the field ends in the rightmost column of the field.

    • N – No justification. The program uses default justification rules for data in the field.

  • Mandatory fields must contain data or a warning is generated on inbound maps.

  • If Zero Fill is selected, the program fills all empty spaces with zeroes.

    Note:DI and SD field types are always zero filled, even if the Zero Fill option is not selected. If the length of the DI number is greater than 15, the DI field is not zero filled. DI and SD are the two primary types of fields used by COBOL-based environments, which is where zero-filling fields is most important.

[CR# 431174] In “Option 2 tab,” in “Running an inbound map,” in Chapter 17, “Running Maps” in the ECMAP User Guide, a note on the Decimal Implicit (DI) and Signed Decimal (SD) field types should be added for the first option—Zero Handling Options. The description for Zero Handling Options is:

Zero Handling Options – choose one of the following:

  • Zero Fill EDI Non-Null Numbers to fill incoming elements that are not blank with zeroes

  • No Zero Fill on Null or Non-Null Numbers to map numeric data exactly as it appears in the map

  • None to do nothing to incoming elements

    Note: DI and SD field types are always zero filled, even if the Zero Fill option is not selected. If the length of the DI number is greater than 15, the DI field is not zero filled. DI and SD are the two primary types of fields used by COBOL-based environments, which is where zero-filling fields is most important.


Repeat groups

In “Transaction mapping,” in Chapter 13, “Mapping” in the ECMAP User Guide, the following sections on mapping repeat groups for NCPDP data should be included at the end of the “Transaction mapping” section.


Mapping repeat groups

To map your NCPDP data, follow the instructions in Chapter 13, “Mapping.” Some differences apply when mapping NCPDP data as repeat groups. These differences are described in the following sections.You can map each repeat group uniquely or in the same way. Mapping each repeat group uniquely allows you to perform simple mapping. However, the repeat group procedure you use may depend on applications at your site.In general, the procedure for mapping repeat groups is the same for both inbound and outbound maps. However, the outbound implementation differs if the repeat group data is contained in a separate record. In this instance, split out repeat groups to separate levels so that you can map them more easily. See “Mapping repeat groups for some outbound maps”.


Mapping repeat groups uniquely

When repeat groups are mapped uniquely, each element is mapped individually to its corresponding field, and each repeat group displays on the Mapping screen. If a nested repeat group exists, it displays in the same manner as the parent repeat group. An occurrence number keeps track of the number of repeat groups.You can copy or delete a repeat group. When you copy a repeat group, the occurrence number increments; when you delete a repeat group, the occurrence number decrements. You cannot delete the last repeat group.

Mapping repeat groups uniquely
  1. Display the NCPDP source or destination on the Mapping screen.

  2. Right-click the desired repeat group and select Map Each Loop Uniquely.


Mapping each repeat group in the same way

When you map each repeat group in the same way, you assume that all repeat groups are mapped iteratively to the same fields. When you select this option, only one repeat group displays on the Mapping screen.When choosing this option, map developers must take care to ensure that data is mapped correctly. He or she must add rules to move the data after each loop or the data is overwritten with the next iteration of the loop. You cannot copy or delete a repeat group when repeat groups are mapped in the same way. However, you can copy or delete elements in a repeat group.

Mapping each repeat group the same way
  1. Display the NCPDP source or destination on the Mapping screen.

  2. Right-click the desired repeat group and select the Map Each Loop the Same option. ECMAP displays a single instance of the repeat group.


Mapping repeat groups for some outbound maps

If data for a repeat group is contained in the same record as other data, repeat groups can be mapped as described in “Mapping repeat groups uniquely” or “Mapping each repeat group in the same way”. If the data for a repeat group is contained in a separate record, you must split segments that contain repeat groups so that you can map each element in the repeat group. Splitting segments places each split group on a separate level.

These restrictions apply to the creation of split segments:

  • Every element in a split segment must be assigned to a split group.

  • Repeat group elements and normal elements must be placed in separate split groups. You cannot mix repeat group elements and normal elements in the same split group.

Splitting a segment
  1. Display the NCPDP source or destination on the Mapping screen.

  2. Right-click the segment you want to split and select Split. The Split Count for Segment window displays.

  3. Enter the number of groups into which you want to split the segment and click OK. The Split Segment window displays so that you can create Split Group 1.Highlight the elements you want to place in a split group.

  4. Click the right-arrow key. The highlighted elements move to the Split Group pane on the right.

  5. Repeat steps 4 and 5 until you have completed Split Group 1. Click Next when you completed Split Group 1.An empty Split Group window displays so that you can create the next split group.

  6. Repeat steps 4, 5, and 6 until you have created the specified number of split groups.

  7. Click Finish. ECMAP displays the numbered split groups on the Destination pane of the Mapping window.

  8. You can now map repeat groups as described in “Mapping repeat groups uniquely” or “Mapping each repeat group in the same way.”



Technical support

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you have any questions about this installation or if you need assistance during the installation process, ask the designated person to contact Sybase Technical Support or the Sybase subsidiary in your area.



Other sources of information

Use the Sybase Getting Started CD, the SyBooks CD, and the Sybase Product Manuals Web site to learn more about your product:

  • The Getting Started CD contains release bulletins and installation guides in PDF format, and may also contain other documents or updated information not included on the SyBooks CD. It is included with your software. To read or print documents on the Getting Started CD, you need Adobe Acrobat Reader, which you can download at no charge from the Adobe Web site using a link provided on the CD.

  • The SyBooks CD contains product manuals and is included with your software. The Eclipse-based SyBooks browser allows you to access the manuals in an easy-to-use, HTML-based format.

    Some documentation may be provided in PDF format, which you can access through the PDF directory on the SyBooks CD. To read or print the PDF files, you need Adobe Acrobat Reader.

    Refer to the SyBooks Installation Guide on the Getting Started CD, or the README.txt file on the SyBooks CD for instructions on installing and starting SyBooks.

  • The Sybase Product Manuals Web site is an online version of the SyBooks CD that you can access using a standard Web browser. In addition to product manuals, you will find links to EBFs/Maintenance, Technical Documents, Case Management, Solved Cases, newsgroups, and the Sybase Developer Network.

    To access the Sybase Product Manuals Web site, go to Product Manuals.


Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

Finding the latest information on product certifications
  1. Point your Web browser to Technical Documents.

  2. Click Certification Report.

  3. In the Certification Report filter select a product, platform, and timeframe and then click Go.

  4. Click a Certification Report title to display the report.

Finding the latest information on component certifications
  1. Point your Web browser to Availability and Certification Reports.

  2. Either select the product family and product under Search by Base Product; or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

Creating a personalized view of the Sybase Web site (including support pages)

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.


Sybase EBFs and software maintenance

Finding the latest information on EBFs and software maintenance
  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.

  3. Select a product.

  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.


 

DOCUMENT ATTRIBUTES
Last Revised: Feb 16, 2007
Part Number: DC00191-01-0500-01
Product: EDI Server
Technical Topics: Messaging, Error Message, Data Management, Install/Upgrade
  
Business or Technical: Technical
Content Id: 1050377
Infotype: Release Bulletin
 
 
 

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics