DSXchange

While testing, I set the time/date locale for this job to OFF and then recomplied the program and now the job does not give any errors. Earlier the time/date locale under NLS was set to 'US-English' : Edit -> Job Properties -> NLS Tab -> Default Locale Categories -> turn Time/Date to OFF I still hav...

'DateGenericToTimeStamp' is located under Routines -> sdk -> date and has the following code : ************************************************************************* * Copyright (C) 2004, 1997-2003 Ascential Software Corporation. All Rights Reserved. * * This code may be copied on condition that ...

DateGenericIsDate is under Transform -> sdk -> date -> Generic in manager/Designer. When I double click DateGenericIsDate, it does not give any code but under 'Details' tab under 'definition' it has the following : (If DateGenericToTimeStamp(%InputDate%, 0) # "" Then 1 Else 0) It seems it ...

One of our old DataStage job started abending from January 1, 2013 with the following error : WSWDS044CommonInvoice..S50TransValidate (DateGenericToTimeStamp): Could not convert date/time :20130102 This job uses the 'DateGenericIsDate' function and has the following code in the stage variables : If ...

By data I mean the input files. We will get the input files on SUSE Linux server and also we will be running some pl/sql or sql*loader jobs on SUSE Linux server. Some of our processes also use name and address cleansing software (Trillium) which will also be running on SUSE Linux. Since we don't hav...

My main concern is 2 different boxes with different operating systems in our new environment : SUSE Linux for Data/Scripts etc. and AIX for DataStage. So my questions is: 1. We can export our DataStage projects from existing HP Unix environment and then import them to AIX environment and recompile. ...

We are currently running DataStage 7.5.1 on HP-Unix. Our company is planning to migrate from HP Unix to SUSE Linux and want to use another AIX server for DataStage jobs where DataStage is already installed. All our data/scripts etc. will be on SUSE Linux and for DatsStage jobs we want to utilize AIX...

Last Week, the DataStage Daemon suddenly stopped running on our production server (HP Unix). Our DataStage jobs started failing and on analysis we found that the engine is not running. Our Unix SA started the engine using 'ds.rc start' command and we were able to logon to DataStage. But we are not s...

Currently we are using DataStage 7.5.1 on Unix (HP UX) with Oracle 9i database. In the next couple of months, we will be upgrading Oracle from Oracle 9i to Oracle 11g and will also enable tablespace encryption. 1. Are there any known issues with DataStage 7.5.1 using Oracle 11g with tablespace encry...

Any suggestions for fixing this issue?

I checked the NLS Locale from DS Administrator and is currently set to US-English in all catagories (drop downs) including 'CType'. The CA-French is not even installed. Do we need to first install the CA-French NLS Locale and then select it for which category i.e for Ctype only or any other category...

We added a new environmental variable NLS_LANG with value : AMERICAN_AMERICA.WE8ISO8859P1 at the project level for each project and the issue is fixed.

We use DataStage XE 7.x on HP Unix and our database is Oracle 9i. We have another product 'Oracle Programmer 2000' on Unix for which our company pays the annual support. But we are NOT sure which product requires Oracle Programmer 2000. Our development team does not use Oracle Programmer 2000. Now t...

I looked at data in the input file from Unix (vi) as well as from view data from DataSatge and the french characters are displayed correctly. The input file as well as the output file has the default project NLS settings which is ISO8859-1. The Oracle's NLS setting is WE8ISO8859P1. I tried changing ...

We are currently using DataStage 7.5.1.A on HP Unix server and our existing database is Oracle 9i. Our Datstage jobs connect to Oracle using OCI8 stage. We are planning to upgrade the Oracle from 9i to 10g on our HP Unix server. Do we need to do anything to our datastage jobs or they will work witho...