Thanks!
differences in versions
Moderators: chulett, rschirm, roy
differences in versions
I am wondering if anybody has a good list of what the differences (or bug fixes) are between DataStage Server version 7.1 and 7.5. We are currently using 7.1, and am wondering if there are any valid reasons we would want to upgrade to the most current version out there.
Thanks!
Thanks!
Eric
Here is a list of fixes at 7.5.1 from the README files:
Problems fixed at this release
==============================
IQBulk12 creates incorrect *sql file, commit statement is missing (ecase 4560)
-----------------------------------------------------------------
Added commit after LOAD TABLE statement
Enhancement request to validate mainframe Date columns (ecase 10000)
-------------------------------------------------------
Added IS DATE and IS NOT DATE functions.
Warning "printer shared memory segment removed" should not occur (ecase 10771)
----------------------------------------------------------------
Filtered out the message from the phantom result file thus stopping it
from becoming a warning
Enhancement request to provide filter on date validity for mainframe
Date columns (ecase 11237)
--------------------------------------------------------------------
Added IS DATE and IS NOT DATE functions.
When save the column definition in sequential file, it doesn't save the format
information in DataStage Manager (ecase 16798)
------------------------------------------------------------------------------
Fixed the problem in sequential file stage, and the same issue in px
stages that have format properties
Enhancement request use COMPUTE ROUNDED instead of MOVE (ecase 17666)
-------------------------------------------------------
Added the ROUND function
Teradata plug-in support for stored procedures (ecase 17140)
----------------------------------------------
Changes added to support calling procedures that had INOUT and OUT parameters.
Teradata plug-in support for Varbinary data type (ecase 17515)
------------------------------------------------
Added support for binary and varbinary data types in teradata, terabulk
and TDMLoad plug-ins.
Column mapping support for Parallel Custom stages (ecase 17687)
-------------------------------------------------
Functionality added to allow definition of columns produced by custom
stages on their output links, such that they appear on the mapping tab
when the stage is used in a job.
Using BCI.CONNECT or CONNECT on DataDirect 4.x drivers causes ODBC
connections to fail after 30 days (ecase 19778)
------------------------------------------------------------------
Fixed driver license handling
APT_STRING_PADCHAR did not accept spaces (Ecase 30156)
-----------------------------------------
Fixed. DSEngine now allows trailing spaces to the right of the '=' sign
within the ENV Set command syntax.
Teradata Parallel stage does not support timestamp datatype consistently
(ecase 35610)
------------------------------------------------------------------------
Parallel Teradata stage does not support timestamp datatype consistently
when in append mode. Fixed.
With NLS on cannot use delimiter 128-255 (ecase 37278)
----------------------------------------
Fixed the problem by modifying the server code, and modified the client
so that if extended ASCII character is used as sequential column
delimiter or quote char, it will be stored in job design as UTF rather
than its ASCII code
Enhancement request to be able to increase the Refresh Interval in DataStage
Director higher than 65 seconds (ecase 39292)
----------------------------------------------------------------------------
Increase the maximun refresh interval to 10 mins, and add new option to
allow auto refresh to be switched off
When targeting a Delimited Flat File need the ability to always delimit
a string column with the string delimiter (ecase 39753)
-----------------------------------------------------------------------
Added a new check box to "Always delimit string data".
Multiple Compile should include buildops (ecase 40778)
----------------------------------------
Added buildops and server routine compilation to gui compiler
Make the password field optional for Teradata FastLoad,
MultiLoad and TPump (ecase 41529)
-------------------------------------------------------
The password field in now optional.
Enhancement to use Parameters on Array and Transaction values (ecase 41630)
-------------------------------------------------------------
Allow the Transaction Size and Array size to handle parameters in GUI
mode.
Problem with Parallel Oracle stage using multiple tablespaces (ecase 43121)
-------------------------------------------------------------
An Oracle instance with Mult_Tablespaces resulted in OraRead returning less
data than it should. Fixed
Using TRIM('ABC') or TRIM(link.column) in constraint causes error after
saving and opening the Output tab (ecase 43792)
-----------------------------------------------------------------------
Fixed
Errors seen when fixed length records in Parallel jobs are larger
than specified length (ecase 43941)
-----------------------------------------------------------------
Get an "internal error" when a fixed length record goes
beyond prescribed length in the Parallel Sequential File stage. Fixed.
MultiLoad fails to insert Timestamp(0) and Time(0) columns (ecase 44444)
----------------------------------------------------------
Fixed by adding additional properties.
Error 6018 when outer clause used in tablename in Informix CLI
(ecase 46014)
--------------------------------------------------------------
Strip "OUTER" keyword from token string in DoLinkReport().
merge does not work with space between columns used (ecase 46982)
---------------------------------------------------
Fixed.
APT_BUFFER_FREE_RUN does not behave as expected when modified and reset to
default. (ecase 47515)
--------------------------------------------------------------------------
Fixed: Don't add items which don't need setting to the envvar section of
dsparams; Added new env var type of float so default is compared
numerically with new value rather than using a string comaparison.
Cannot reset the status file from a job invocation (ecase 47931)
--------------------------------------------------
Fixed the problem in client
Unable to open a sequential file larger than 2gb on DS server. (ecase 48044)
--------------------------------------------------------------
Enabled large file support for Linux
Teradata plug-in needs additional information logged to Director log
(ecase 48046)
--------------------------------------------------------------------
The input link now reports the number of rows received, rejected,
inserted, updated and deleted in the Director log.
Released job aborts with 'Timoeut waiting for Mutex' (ecase 48601)
----------------------------------------------------
Fixed by recoding in dsd_ipcfile.c and DSD_IPCOpen.B
Cannot put a message on a queue with reported encoding other than that of the
queue manager (ecase 49132)
-----------------------------------------------------------------------------
Add CCSID Property
Merge stage can't process input files over 2GB (ecase 49136)
----------------------------------------------
Support for 2GB+ files added
In CFF stage, the find button in Select Column does not work. (ecase 50004)
------------------------------------------------------------
Fixed.
Job with XML Transformer is not running correctly on DS v7.1 while it runs
fine on DS 7.0.1 (ecase 50103)
--------------------------------------------------------------------------
Fixed
Issue with user-defined OldFile JCL Template when using Pre-sort operation:
incorrect run JCL generated (ecase 50187)
---------------------------------------------------------------------------
Fixed
vmdsapi.so is not thread safe on Unix (ecase 50262)
-------------------------------------
Fixed
Jobs with Link Partitioner stage abort at DataStage release 7.1 (ecase 50363)
---------------------------------------------------------------
Fixed
View Data is incorrect in CFF stage when there is a column description
(ecase 50421)
----------------------------------------------------------------------
Buffer size increased to hold description.
Generate code error- Contact Technical support and Low virtual Memory
(ecase 50681)
---------------------------------------------------------------------
The compiler now uses less memory to compile the customer's job. The job
still uses a lot of memory due to the sheer number of columns, but a
system with 512M RAM should be able to compile it successfully.
Error using view data option in db2 plug-in when job parameter isused as
schema name. (ecase 50864)
------------------------------------------------------------------------
Changed to pass column derivation through ResolveBrowseParams function
DB2 load fails due to PK constraint but job finishes ok (ecase 51209)
-------------------------------------------------------
Fixed
Auto schema specification in Parallel Custom stages (ecase 51244)
-------------------------------------------------
Functionality added to allow a property defined in a custom stage to be
set to a type that means that its value will be automatically filled
with the schema derived from columns loaded on its input/output tab.
DB2 plug-in truncates char data 1 extra character beyond column length
(ecase 51545)
----------------------------------------------------------------------
Fixed.
Enhancement for formated output for "show file" (ecase 51591)
-----------------------------------------------
Show file replaced with view data. Support for target File Set also added.
Dynamic Relational Stage truncating data (ecase 51642)
----------------------------------------
Fixed
Folder stage property wildcard does not work as previous releases (ecase 51748)
-----------------------------------------------------------------
Fixed
Different behaviour of Iconv function in version 7x after upgraading from
version 4.2.2 (ecase 51809)
-------------------------------------------------------------------------
Due to the implementation of format masks at release 7.1, the handling
of separators in conversion strings was tightened. This caused a change
in behavior of iconv. To resolve this change in behavior, code changes
have been made so that both format masks and separators will work when
the default "D" conversion is specified.
Oconv returns different results after upgrading from 5.2.2 to 7.1 (ecase 51811)
-----------------------------------------------------------------
When NLS is installed, using OCONV with the conversion code DYMD[4,2,2]
will now correctly use the default separator rather than using a space
as a separator.
XML report outputs ZERO's as empty strings (ecase 52198)
------------------------------------------
When a partition gets a count of zero records, the count in the report
XML generated has a value of an empty string instead of "0". An empty
string is not a numeric value so the XSL we use and the example XSL that
is supplied all display NaN for the value when trying to sum the counts.
Modified code to handle zeros correctly.
Date Mask does not work correctly for invalid dates (ecase 52425)
---------------------------------------------------
Fixed
FTP Plugin doesn't work while using '009' as TAB delimiter (ecase 52622)
----------------------------------------------------------
Fixed. Tab delimiter wasn't being inserted properly.
FTP Plug-in behavior different with NLS version of DataStage (ecase 52756)
------------------------------------------------------------
The ftp plugin was behaving differently (and incorrectly) when NLS was
enabled and end-of-line characters were found before all columns were
filled in non-fixed width column case. This has been fixed.
Multiple instance PX job fail with hang (ecase 52860)
---------------------------------------
Fixed to DSD_OshRun.B to correct the handling of the test for the
parallel job script file. This is now done in the correct location and
using a test which does not require write access to the script!
Multiple instance PARALLEL (not SERVER) job aborts using using BASIC
transformer and Pivot stage when invocation id is used. (ecase 53144)
---------------------------------------------------------------------
Fixed
Memory leak in udbload stage when TIME data type is used. (ecase 53346)
---------------------------------------------------------
A memory leak no longer occurs in the UDBLoad plugin when columns with
the TIME datatype are used.
Jobs with existing rangemaps failed when partioning data (Ecase 53536)
--------------------------------------------------------
Writerangemap was not accepting the cs,desc, and null options and was
running with the wrong defaults. This may have caused exisiting jobs
to give incorrect results. This has now been fixed, but jobs will have
to be changed to se the correct options on writerangemap.
Installation failure with base directory name around 50 chars (ecase 53737)
-------------------------------------------------------------
Fixed very long pathname handling
Attunity driver to ADABAS fails at Datastage/UV level, ok from Unix Prompt
(ecase 53864)
--------------------------------------------------------------------------
Fixed
When view data in DRS plugin, got an error "Unknown client library -
$PROJDEF. DSP.Open GCI $DSP.Open error -100". (ecase 53873)
--------------------------------------------------------------------
$PROJDEF is now resolved to its value in View Data
Propagate Values does not work for column tab contains terminator (ecase 54188)
-----------------------------------------------------------------
Propagate Values now works correctly
Invalid date or month message not correct, it says the data was set
to Null (ecase 54322)
-------------------------------------------------------------------
Message changed to say invalid value passed on asis.
View Data on DSDB2 plug-in does not release database connection (ecase 54338)
----------------------------------------------------------------
Call Cleanup routine to release database connection if error occurs in
browse mode.
large number of columns causes soc4 (ecase 54383)
-----------------------------------
Fixed in RTL by changing the buffer size based on the columns
On Japanese system, problem with encode/decode stage (Ecase 54584)
----------------------------------------------------
On Japanese system, jobsw would abort if the schema for an encode/decode
stage contained two or more consecutive fixed or bounded length ustrings.
Fixed
Enhance dsjob -lodetail to fetch multiple log records (ecase 54715)
-----------------------------------------------------
Enhanced dsjob -lodetail to fetch multiple log records by allowing an
optional extra event id parameter so as to request a range of records.
dsjob -logdetail <project> <job> <startid> <endid>
EOF generates an empty line that is read by mask (ecase 54748)
------------------------------------------------
Empty line no longer generated
Job with FTP stage called by another job aborts after being called several
times (ecase 54857)
--------------------------------------------------------------------------
Fixed. Handled by retrying tnet_exec, when tnet_recv return false for
telnet server returns a null login prompt
Installation of NLS Causes certain jobs to abort (Ecase 54957)
------------------------------------------------
A Parallel job with a BASIC Transformer and several Pivot plug-in stages
aborts when NLS is installed after processing about 100,000 rows. The
same job run to completion without NLS. Fixed.
DSJobReport XML shows encrypted passwords (ecase 55288)
-----------------------------------------
Modified server code to show stars for encrypted job parameters
OCI8/9 stage fails accessing table with 0xC9 as final byte in name
(ecase 55342)
------------------------------------------------------------------
No longer fails in these circumstances
If no records passed to link of command stage fatal error results (ecase 55415)
-----------------------------------------------------------------
Check to see if any rows processed. Only put out fatal if rows processed
and no execute of command takes place.
Compile Generate Button is lost (ecase 55564)
-------------------------------
The gen button is only disabled after the gui validation has been done
Table definition - Format Tab - Sync parallel button (ecase 55591)
----------------------------------------------------
Parallel schema was not updated after clicking Sync Parallel when
changing spaces between columns from any value to zero. Fixed.
Jobs with existing rangemaps failed when partioning data (Ecase 55601)
--------------------------------------------------------
Writerangemap was not accepting the cs,desc, and null options and was
running with the wrong defaults. This may have caused exisiting jobs
to give incorrect results. This has now been fixed, but jobs will have
to be changed to se the correct options on writerangemap.
Issue with running jobs with Shared Containers (ecase 55695)
----------------------------------------------
Issue with running jobs with Shared Containers: WriteColumns,0:
dspipe_wait(18732): Writer timed WriteColumns,0: dspipe_wait(18732):
Writer timed. One of the code paths that deals with InvocationIds was
wrongly replacing WriteColumns with WriteColumns.#0. Fixed.
The orawrite partitioner did not work correctly if there were multiple
partitioning keys. (Ecase 55938)
-----------------------------------------------------------------------
Fixed.
Sort Stage is 20% slower on 7.1 than 6.x on a Multiprocessor environment
(ecase 55983)
------------------------------------------------------------------------
Recoded to improve performance.
Create cfd incorrect, did not give any warning with the field name greater
than 30 characters (ecase 56001)
--------------------------------------------------------------------------
Now generates a warning.
Teradata Parallel stage defaults to buffer size instead of using
APT_TERA_64K_BUFFERS (ecase 56002)
-----------------------------------------------------------------
Teradata Parallel stage defaults to buffer size instead of using the
APT_TERA_64K_BUFFERS environment variable when it is set. Fixed.
utf_to_row error occurs in FTP stage (ecase 56019)
------------------------------------
Fixed.
Number of updated rows using UDBDB2 stage is incorrect (ecase 56035)
------------------------------------------------------
Fixed
The transform operator used the wrong collation sequence for ustring
compares. (Ecase 56084)
--------------------------------------------------------------------
Fixed
Performance Issues in DB2 Plug-in due to SQLTables call (ecase 56095)
-------------------------------------------------------
Call is done to obtain process meta data. It is replaced by a direct
query of the catalog. This will be quicker but may not work on all
implementations of DB2. If the direct query does not work, it will
revert back to SQLTables.
Varchar to bigint conversion is incorrect (ecase 56222)
-----------------------------------------
An extra digit was added when converting varchars to bigints.
Fixed.
Complex Flat File records with zero-length subrecords were being deleted.
(Ecase 56463)
------------------------------------------------------------------------
An option was added to the CFF to allow zero-length subrecs to be kept.
This option must be made visible in the GUI.
DS390 Link Collector is causing job to abort with 0C4 (ecase 56576)
-----------------------------------------------------
Insert replacement was generating FOR loops in the wrong order under
special circumstances involving the Link Collector stage (see the
associated test case). PTLGen now generates Link Collector code in a
different order to help insert replacement figure out where to correctly
place the FOR loops.
DRS plugin - rejected rows do not generate warning message (ecase 56759)
----------------------------------------------------------
DRS plugin - if update action is set to "Insert new rows or update
existing rows" or "Update existing rows or insert new rows", rows
rejected from the database does not generate any warning messages.
Rejected row messages were not being displayed in the log. Fixed.
Generate Cobol Program executes and returns warning message when it should
return error. (ecase 56784)
--------------------------------------------------------------------------
Fixed by restoring the RETURN-CODE
Unable to use variable extension. (ecase 56803)
---------------------------------
Fixed.
Error parsing Oracle user from Oracle Stage (ecase 56853)
-------------------------------------------
When setting the following as the user in the Oracle Stage in the DS
GUI: user=\'/\', this is generated in OSH: -dboptions 'user=\\\'/\\\''
This does not work. Forward slash is now also escaped for string values.
This means in this case user should see '/' in the GUI and what gets
generated is \'\/\'
View Data problem in CFF Plug-in (ecase 56958)
--------------------------------
Increase size of column description. See ecase 50421.
Problem with ICONV/OCONV causing date issues in DBMS Plugins (ecase 56985)
------------------------------------------------------------
Fixed
Dataset repartitioning failed on DB2 (Ecase 56992)
------------------------------------
The DB2 operators were running under a different nodemap than other
operators, causing aborts. Fixed.
Redbrick plug-in with map set as NONE project default makes corrupt data file
(ecase 57038)
-----------------------------------------------------------------------------
Fixed. Handle NONE properly.
No DD created if DB2 source to load (input DD req). (ecase 57103)
---------------------------------------------------
Fixed
Datastage/PX job reported successful completion even though it encounters
a Fatal error (Ecase 57112)
-------------------------------------------------------------------------
Fixed.
DRS Plug-in: Data in Oracle Long field corrupted during execution of DataStage
job (ecase 57140)
------------------------------------------------------------------------------
For inputlink, LONG column is bound to SQLT_STR to avoid data corruption.
Oracle OCI Bulk Load plug-in: automatic load job with Japanese data fails with
Strange message (ecase 57236)
------------------------------------------------------------------------------
Fixed.
Pivot stage aborts when there are several columns with long names (ecase 57269)
-----------------------------------------------------------------
Dynamically reallocated the buffer based on length of input names.
ORAOCI9 stage cannot read or write binary zero (ecase 57367)
----------------------------------------------
The fix is to treat fixed length character strings differently than VARCHAR
strings. A fixed length character string (created as CHAR(n) at CREATE TABLE
time) is considered to be Oracle type SQLT_AFC whereas other character strings
are SQLT_STR.
Sybase OC Plug-in can't import meta data from Sybase IQ (ecase 57388)
-------------------------------------------------------
The Sybase OC plug-in can now be used to import meta data from Sybase IQ 12.5
Install problem on Redhat AS 3.0 (ecase 57452)
--------------------------------
The DataStage Server could not connect from client, with error "Cannot
acquire exclusive access to signature table" in log. Correctly access
signature table on machines where the system semop function is used.
RTg32sg02 Test03 gives error 'contains characters which are not defined in
the files NLS map' (ecase 57460)
--------------------------------------------------------------------------
PreserveCRLF property now defaults to "Y" in runtime
Transformer function Problem (ecase 57497)
----------------------------
Fixed
DB2UDB fails to update rows using user-defined SQL (ecase 57740)
--------------------------------------------------
Fixed.
The combination of lookup stage and funnel stage did not properly combine
records. (Ecase 57774)
-------------------------------------------------------------------------
Fixed.
In OCI Plug-in, column Generated SQL query only allows 1024 bytes query length
(ecase 57785)
------------------------------------------------------------------------------
Buffer size is increased based on length of the sql query.
Bringing up routine activity stage is very slow over a WAN (ecase 57808)
----------------------------------------------------------
Replaced combobrowser with treebrowser to reduce the time required to
open job and routine properties.
Incorrect message when cancelling creating job from template (ecase 57823)
------------------------------------------------------------
Fixed in client
Client applications perform certain tasks extremely slow (ecase 57860)
----------------------------------------------------------
Unnecessary multiple calls were being made to a routine, fixed.
dsjob -local truncates arguments (ecase 57949)
--------------------------------
dsjob -local command was truncated if it used numerous or long arguments.
Resolved.
The CLASS_OF number did not reset, so the # has changed each time code
generated. (ecase 58007)
----------------------------------------------------------------------
The DECLARE CURSOR no longer changes each time COBOL code is generated
null on group by cause abend S0C4 (ecase 58053)
---------------------------------
Fixed
Some Parallel datasets require more disk space in relases after 7.0
(ecase 58115)
--------------------------------------------------------------------
Some Parallel datasets generated with 7.0.1 and later releases require
more disk space when the columns are of Datatype VarChar when compared
to 7.0. This is due to changes added for performance improvements for
bounded length VarChars in 7.0.1.
Added environment variable APT_OLD_BOUNDED_LENGTH
which when set to any value will revert to pre-7.0.1 storage behavior
when using bounded length varchars. Setting this variable can have adverse
performance effects. The preferred and more performant solution is to use
unbounded length VarChars (don't set any length) for columns where the
maximum length is rarely used, rather than set this environment variable.
OCI Plug-in gives error ora-01036: Illegal variable name/number (ecase 58410)
---------------------------------------------------------------
Fixed.
DRS does not support Informix data type 'BYTE' (ecase 58470)
------------------------------------------------------------
Added support for SQL_LONGVARBINARY( BYTE in informix)
logdetail crashes with long log entry ending <lf> (ecase 58554)
-------------------------------------------------
dsjob -logdetail fails with a segmentation violation on Linux when
handling a long entry (40K) which also ends in a line terminator
character.
Fixed out by one error in one of the called routines
SOC7 bad data in MFF stage display numeric (ecase 58588)
------------------------------------------
Fixed
Oracle enterprise stages fails to read a synonym table when the
partition option is used (ecase 58679)
----------------------------------------------------------------
The Oracle Parallel stages cannot read from tables when synonyms are used
to reference the table in the partition table option. Fixed.
OCI Plug-in reports DBMS.CODE=ORA-01461 reported when inserting into Oracle
table (ecase 58718)
---------------------------------------------------------------------------
Handles more than one LONG column now.
Problem compiling parallel job (ecase 58836)
------------------------------
Fixed
Job monitoring did not work with Custom EE Operators which
use composites within composites (ecase 58988)
----------------------------------------------------------
Fixed.
SEGV when parsing large schemas with Custom EE Operators (ecase 58989)
--------------------------------------------------------
Fixed.
Teradata FastExport job fails with "received signal SIGSEGV" (ecase 59058)
------------------------------------------------------------
Made the FastExport side of the plug-in more robust to differences
between the table meta data and the stage meta data. Also changed the
plug-in to redirect FastExport's standard output and standard error to
the report file instead of using the route commmand.
Process Metadata from DS390 jobs come back with local timezone
timestamps (ecase 59178)
--------------------------------------------------------------
Changed to use GMT timestamp.
Could not load a column defined as CHAR(1) or CHAR(2) in the Teradata
database (ecase 59284)
---------------------------------------------------------------------
This is a bounded-length string issue found in renaming fields. We only
checked the string length to see if one string can be renamed to the
other. It is ok for variable-length strings. For fixed-length and
bounded-length strings, we also need to check if two strings are both
fixed-length, or bounded-length. Fixed.
Job validation not reporting duplicate DDNAME (ecase 59320)
---------------------------------------------
Fixed
The DSJobStartTime macro does not work as a parameter for the sequential
file stage. (ecase 59375)
------------------------------------------------------------------------
Fixed error in conversion of DS format macro into ParallelEngine format script
parameters.
SEGV when parsing export schema in Custom EE Operator (ecase 59466)
-----------------------------------------------------
Fixed.
When stopping job from DS Director, it does not stop the Tera Fast Export
process in unix. (ecase 59389)
-------------------------------------------------------------------------
This is a duplicate of Ecase 52267 which was fixed in TDMLoad plug-in 1.3.1
dsjob -logdetail logrange truncates log entries (ecase 59493)
-----------------------------------------------
Following the fix to 58554, under some circumstances log entries can be
truncated. In the original code, after converting a newline to a zero
byte, the code skipped a character. If the string ended in a newline, a
buffer overrun occurred. For the 58554 fix, the character-skip was
removed to fix the buffer overrun, but this caused consecutive newlines
to be converted to zero bytes. A pair of zero bytes marks the string
end, and therefore caused truncation. For the 59493 fix, the
character-skip is applied only if the next character is another newline.
This avoids zero-byte pairs in the string and the buffer overrun.
A new "layout" view problem (ecase 59506)
---------------------------
Fixed
When creating a job from a Template Datastage will not allow the name to
contain an underscore "_", but it can be renamed after. (ecase 59548)
------------------------------------------------------------------------
Modified the client to allow the use of underscores in jobnames
Upgrade from 7.x to 7.5 doesn't remove the quotes from the invocation id
(ecase 59753)
------------------------------------------------------------------------
Fixed upgrade code to remove quotes
Merge stage generates incorrect results (ecase 60018)
---------------------------------------
Additional check added to consider row terminator for Left Only join type
Encrypted parameters are not passed from Sequencer to Server job (ecase 60194)
----------------------------------------------------------------
Fixed error in handling of parameters whereby we were decrypting at the
wrong time
Parallel job run with Multi Invocation doesn't pass parameter to Shared
Container (ecase 60330)
-----------------------------------------------------------------
Read parameters from parent job correctly
When validate a job using Routine UtilityAbortToLo- job failed (ecase 60359)
--------------------------------------------------------------
Added extra checking for entities with DSX
DRS Informix: Non-numeric character in datetime or interval (ecase 60406)
-----------------------------------------------------------
Added '.' character if date data length is more than 23.
jobmon gets confused when sent incomplete data (ecase 60448)
----------------------------------------------
This ecase is a request to make jobmon able to process data with BEGIN
tags, but no END tag. Fixed.
Multiple output links from transformer data wrong (ecase 60518)
-------------------------------------------------
Fixed.
New project option for RCP default (ecase 60704)
----------------------------------
Implemented new default RCP setting in admin client
DSSendMail does not work for users other than dsadm. (ecase 60747)
----------------------------------------------------
The sendmail_###.sh file created does not have executable permission for
owner and group. Fix made to ensure correct ownership of file.
error importing 6.0 job into 7.5 (ecase 60876)
--------------------------------
Fixed
Need to remove Check integrity of job files (IE clean up project) from
DS.TOOLS (ecase 61014)
----------------------------------------------------------------------
Removed Check integrity of job files from DS.TOOLS
Import of PL/1 file definition incorrect (ecase 61035)
----------------------------------------
Storage length calculation for decimal (n) is (n/2) + 1 instead of (n+1)/2
Intermitent issue when loading data with the Parallel Teradata Enterprise
plugin (ecase 61330)
-------------------------------------------------------------------
The Parallel Teradata operators now block the SIGALRM interrupts from jobmon
Add an environment variable to allow skipping the check against the
dbc.ampusage table (ecase 61386)
-------------------------------------------------------------------
The teraread and terawrite operators now use the 'lock row access'
modifier when accessing system tables. This should allow faster access
and will avoid locking rows during processing.
Teradata plug-in rejects valid records when the first record contains a null
column (ecase 61428)
----------------------------------------------------------------------------
If a NULL value was sent to a NOT NULL column, the plug-in rejected the
row and every row after it. Now it correctly rejects just that row.
When compiling a PX job with DRS, job parameters that are environmental
variables not put in osh correctly. (ecase 61545)
-----------------------------------------------------------------------
Fixed.
Refresh does not occurr when delimited stage has 2 output links (ecase 61560)
---------------------------------------------------------------
Code needed for selection change was missing. Fixed.
Buffer over run error when three date cols in a row (ecase 61604)
---------------------------------------------------
Changed handling of record header
Some functions available in the Expression editor can't be used in the
Constraint of flat file source stages (ecase 62155)
----------------------------------------------------------------------
Added missing functions.
Truncation of schema strings over 64K (ecase 62190)
-------------------------------------
This is caused due to an error in the string to ustring conversion
routine where a short is used instead of an int. Fixed.
Reject rows in DRS plugin show the data truncated (ecase 62296)
-------------------------------------------------
Just a reporting error. Fixed.
TeraData API plugin does not process clipsb.dat file (ecase 62347)
----------------------------------------------------
The plug-in no longer overrides the default client character set.
Clicking on Project Properties causes Runtime error '6': Overflow (ecase 62402)
-----------------------------------------------------------------
Fixed.
Join stage, Full join with Two File match technique is not outputting the
correct results (ecase 62680)
-------------------------------------------------------------------------
Fixed
The default mode for parallel SAS datasets in the GUI is create (abort if file
exists) rather than the default on normal datasets which is overwrite
(ecase 62755)
------------------------------------------------------------------------------
Stage type updated
There are no SAS environment variables available from a standard pick-list
from within the configuration (administrator or job parameters) (ecase 62759)
-----------------------------------------------------------------------------
Added SAS environment variables to the supported set (operator-specific)
The UNPACK module taking too much CPU time (ecase 62830)
------------------------------------------
Fixed
Empty string values are converted to SQL_NULL (ecase 62852)
---------------------------------------------
Fixed
The call to SQLTables from the DRS plugin is taking too long and slowing down
their jobs. (ecase 62979)
-----------------------------------------------------------------------------
Set DS_NO_PROCESS_METADATA to TRUE to turn off the Link meta data
reporting. This prevents the SQLTables call.
Problem importing a sequential file (ecase 63024)
-----------------------------------
Modified server viewdata parsing code
Running a large volume match procedure in Parallel mode. 7 pass match process
that seems to be hanging (ecase 63029)
-----------------------------------------------------------------------
The issue was related to raw_to_substring coversions with type N and the
source field contains spaces only. Fixed.
Char To Double conversions (ecase 63212)
--------------------------
The problem occurred in strtod() when the first argument is passed in as
a function call. Chose to create and use a local variable. The fix was
made to buildop/transform/evalexp.C
TDMLoad Plug-in: If the column data is greater > 32,000 byte- warning Row too
long (ecase 63341)
-----------------------------------------------------------------------------
Added support for VARCHAR(64000).
Teradata field in format "time" cannot be imported (ecase 63356)
--------------------------------------------------
Fixed
Lookup stage pads spaces to the end of varchar fields returned from
lookup (ecase 63415)
-------------------------------------------------------------------
Fixed
Compile Error in Job Sequncer in DS7.5A (ecase 63544)
---------------------------------------
Fixed compile error message in client
Problem using a lookup fileset that has been partitioned (ecase 63654)
--------------------------------------------------------
The fix is to disable memory sharing for lookup table in process-only
mode if the input dataset has preserve-partitioning flag set
The Unidata 6 stage does not allow updates (ecase 63690)
------------------------------------------
The previous Unidata stage can now be used to connect to Unidata 6
When scheduling a job through director tool with a (ecase 63965)
----------------------------------------------------------
When scheduling a job through director tool with a difference Invocation
Id and a diffrent Parameter inserted there is no log in director with
the Invocation Id after it runs.
PX: Sequential stage: If First Line is Column Names is true and Quote character
is None the column names are enclosed in the word none. (ecase 64067)
-------------------------------------------------------------------------------
Fixed in file_export.C
RT_SCnn directories for deployment are not created with timestamp from
re-compile (ecase 64100)
-----------------------------------------------------------------------
Amended job compilation code to ensure Unix timestamp on deployed job
directory is updated every time job is recompiled
UserVariables Activity stage can't compile when using the UtilityHashLookup()
transform. (ecase 64105)
-----------------------------------------------------------------------------
Fix the problem in client
Runtime error after converting a portion of a parallel job to a shared
container. (ecase 64313)
----------------------------------------------------------------------
Fixed shared container stage construction from existing stages
Mainframe job does not issue a rollback after aborting (ecase 64352)
------------------------------------------------------
Cobol code now puts in "if return-code > 4 exec sql rollback"
Job Canvas opens without links for very large job with UOW (ecase 64486)
----------------------------------------------------------
Fixed in the client.
Cannot delete a custom routine from a protected project. (ecase 64502)
--------------------------------------------------------
Fixed.
Memory leak using XMLTransform in a PX job (ecase 64627)
------------------------------------------
Status flags were not being re-initialized after an end-of-wave
condition. It appeared that there were no more rows to process on the
plug-in's primary input link, which in turn caused stages downstream of
the XML input plug-in to not see any rows.
The lookup stage Key Expression is not updated when a link name is changed
(ecase 64760)
--------------------------------------------------------------------------
Fixed
View Data fails or works depending on the position of the APT_CONFIG_FILE
parameter in the job properties grid. (ecase 65325)
-------------------------------------------------------------------------
Fixed in job parameter / environment variable processing for PX view data
IS DATE and IS NOT DATE functions generating incorrect code (ecase 65511)
------------------------------------------------------------
Added the capability to use IS DATE and IS NOT DATE against columns of
type CHARACTER. This is accomplished by first casting the character
column to date. For example, CAST(col_name AS DATE) IS DATE where the
character date value must be in the ISO format (ccyy-mm-dd).
Using a Business Rule Stage that does DB2 commit processing causes
the DB2 source cursor position to be lost after a commit (ecase 65972)
----------------------------------------------------------------------
If a COMMIT is done in a Business Rule stage, the WITH HOLD construct
will be added in the DB2 generated DECLARE CURSOR statement.
Redundant Cobol code is generated (ecase 66149)
----------------------------------
The generated Cobol MAINBODY-EXIT processing was fixed to call the
appropriate CLEANUP paragraph only once.
If you change the serial number on one client install, when you switch
back to that install, it sees the old serial number (ecase 67769)
----------------------------------------------------------------------
When attempting to copy the registry keys and values from the version
specific key to the "CurrentVersion" key the wrong string was being used
to define the version specific key. As the Multi-Client Manager could
not find the required key, it always used the first version specific
entry it came across. On the customer machine, this is always the 6.0
key. The correct version string is now used.
</a>I did not include the list of enhancements - there are some nice ones there as well. I think that these documents are readily available on the Ascential website but just happened to have the CD in my drive when you posted your question.
We have 7.5.1 on our AIX box right now and, apart from new sporadic aborts of my designer, nothing untoward has happened.
We have 7.5.1 on our AIX box right now and, apart from new sporadic aborts of my designer, nothing untoward has happened.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: