Switch to standard view 
  Sybase logo
 
 
 



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:


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:

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

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:

[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:


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:

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:


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.



Back to Top
© Copyright 2010, Sybase Inc.