DSXchange

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!

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!

Thanks for all the advice.
But how to insert into more than one table using one OCI stage? So far I have been using 1 table --> 1 OCI where I import the meta data columns and do the respective mapping.

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...

Hi chulett,

Thanks for the advice.

I am currently using one OCI stage for each table I need to insert to. Meaning total of 4 OCI stages for 4 tables.

How can I use a single OCI stage to insert to multiple tables?

Would appreciate further advice... [:)]

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 ...

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!

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...

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...

Two possible ways:

1)Use Field(input.InputDate, " ", 1,1) to extract based on space delimiter.
2)Left(InLink.TheTimeStamp, 10) to extract the first 10 chars. This was posted in another thread previously.

Hope it helps!
Good Luck!

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. ...

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 ...

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....

Problem solved!

Vincent: Thanks for the advice!

[:D]

Another add-on query relating to this thread: @INROWNUM and @OUTROWNUM is with respect to the total number of the source record. Is there any way to group the sequence number such that it restarts with every new ID? Example: ID SEQ 1 1 1 2 1 3 2 1 2 2 2 3 Any help is much appreciated! [:)]