Search found 29 matches
- Mon Jan 07, 2013 7:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateGenericIsDate is NOT working
- Replies: 13
- Views: 7951
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...
- Fri Jan 04, 2013 11:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateGenericIsDate is NOT working
- Replies: 13
- Views: 7951
'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 ...
- Fri Jan 04, 2013 10:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateGenericIsDate is NOT working
- Replies: 13
- Views: 7951
- Fri Jan 04, 2013 9:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateGenericIsDate is NOT working
- Replies: 13
- Views: 7951
DateGenericIsDate is NOT working
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 ...
- Thu Aug 23, 2012 1:00 pm
- Forum: General
- Topic: DataStage Project Migration from HP-Unix to SUSE Linux/AIX
- Replies: 4
- Views: 3104
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...
- Thu Aug 23, 2012 11:27 am
- Forum: General
- Topic: DataStage Project Migration from HP-Unix to SUSE Linux/AIX
- Replies: 4
- Views: 3104
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. ...
- Wed Aug 22, 2012 1:12 pm
- Forum: General
- Topic: DataStage Project Migration from HP-Unix to SUSE Linux/AIX
- Replies: 4
- Views: 3104
DataStage Project Migration from HP-Unix to SUSE Linux/AIX
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...
- Mon May 02, 2011 11:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Daemon Suddenly Stopped
- Replies: 0
- Views: 1628
DataStage Daemon Suddenly Stopped
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...
- Tue Sep 29, 2009 9:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage 7.5.1 and Oracle 11g
- Replies: 2
- Views: 2134
DataStage 7.5.1 and Oracle 11g
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...
- Wed Nov 19, 2008 10:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: French char. are not converted correctly for M/F binary file
- Replies: 3
- Views: 2390
- Tue Nov 11, 2008 1:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: French char. are not converted correctly for M/F binary file
- Replies: 3
- Views: 2390
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...
- Thu Nov 06, 2008 1:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: French Characters are not converted correctlly in Oracle tbl
- Replies: 5
- Views: 8280
- Thu Nov 06, 2008 1:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage and Oracle Programmer 2000
- Replies: 2
- Views: 2390
DataStage and Oracle Programmer 2000
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...
- Wed Oct 22, 2008 6:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: French Characters are not converted correctlly in Oracle tbl
- Replies: 5
- Views: 8280
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 ...
- Wed Sep 03, 2008 1:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration from Oracle 9i to 10g
- Replies: 1
- Views: 1383
Migration from Oracle 9i to 10g
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...