Hi all,
I am currently using DataStage version 5.
Just like to check whether the newer versions support MS Excel and SQL Server?
Thanks in advance!
Search found 23 matches
- Mon Sep 29, 2003 2:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Does DataStage support Excel and SQLServer?
- Replies: 3
- Views: 2135
- Mon Aug 11, 2003 12:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calculate number of months between 2 dates
- Replies: 4
- Views: 2108
Calculate number of months between 2 dates
Hi All,
Need to calculate a duration field, (end date) - (start date).
Result required to be in months.
Couldn't find any appropriate functions to apply.
Anyone can advise?
Thanks in advance!
Need to calculate a duration field, (end date) - (start date).
Result required to be in months.
Couldn't find any appropriate functions to apply.
Anyone can advise?
Thanks in advance!
- Fri Jul 18, 2003 10:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI stage DB connections
- Replies: 6
- Views: 3157
- Thu Jul 17, 2003 8:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI stage DB connections
- Replies: 6
- Views: 3157
OCI stage DB connections
Hi all, I noticed that each OCI target stage uses one DB connection. So when I need to load into 5 tables, DataStage actually gets 5 DB connections. This results in not enough connections esp when I am sharing the DB with some application developers. Any way to use one connection for multiple stages...
- Thu Jul 10, 2003 7:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting to Multiple Oracle stages
- Replies: 8
- Views: 2987
- Thu Jul 10, 2003 4:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting to Multiple Oracle stages
- Replies: 8
- Views: 2987
Inserting to Multiple Oracle stages
Hi all, I faced the problem of jobs behaving differently in different database instances. Somehow the job that worked in DB1 previously(by that i mean that the data are correctly and successfully loaded), couldn't work in other instances like DB2. The job will hang and no response or error messages ...
- Mon Jun 30, 2003 1:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to stop a job that hanged
- Replies: 2
- Views: 1718
Unable to stop a job that hanged
I have problems with stopping a job that is running. It has been running for a few hours already. When I click Stop, it says stop request has been sent to server but the job is still at the running status after a few hours.
Any other way to kill the process?
Thanks!
Any other way to kill the process?
Thanks!
- Wed Jun 25, 2003 3:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Hangs When Running
- Replies: 3
- Views: 1957
Job Hangs When Running
Encountered the problem that the job status is stuck at running for more than an hr... even though I already set the constraint to extract and process only 1 record. There could be many possibilities but is there any of those common causes that anyone know of? How can I trace the job record by recor...
- Tue Jun 24, 2003 9:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error with DateGenericToTimeStamp
- Replies: 5
- Views: 3252
Read from the routine comments that DateGenericToTimeStamp might not work in a NLS environment. I manage to get it working after disabling the NLS maps for this job. Thanks Ray! However, the calculation returns results in number of days, any way to return in months OR convert the number of days to m...
- Tue Jun 24, 2003 1:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Remove timepart in Date field
- Replies: 6
- Views: 1971
- Tue Jun 24, 2003 1:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error with DateGenericToTimeStamp
- Replies: 5
- Views: 3252
My understanding of DateGenericDateDiff function is arg2 - arg1. Thus, the second argument for DateGenericDateDiff is the later input date. Think what you mean by zero or one is the args for DateGenericToTimeStamp. In which I did not explicitly call this method. It is called by DateGenericDateDiff. ...
- Tue Jun 24, 2003 1:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence Generator
- Replies: 8
- Views: 3950
Thanks Ray for the advice on the group seq generator. I tried what you suggested by implementing the following stage variables: Var Derivation CheckID RowProcCompareWithPreviousValue(input.ID) Seq If (CheckID) then (Seq+1) else 0 However I still get errors with unique key constraints as this seq no ...
- Thu Jun 19, 2003 8:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error with DateGenericToTimeStamp
- Replies: 5
- Views: 3252
Error with DateGenericToTimeStamp
Need to find duration between 2 dates. Encountered the following error while using DateGenericDateDiff: (DateGenericToTimeStamp): Could not convert date/time :5/31/2005 I have look up the routine specs and it mentioned can be used with "Any delimited date with Month Day Year, e.g. 4/19/1999, 4....
- Thu Jun 19, 2003 1:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transform multiple columns into multiple records
- Replies: 2
- Views: 1338
- Thu Jun 19, 2003 12:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence Generator
- Replies: 8
- Views: 3950