DSXchange

Hi Paul,

I couldn't replicate the oracle error. I write a Job that do the same as you discribe and it runs fine.

Regards,
Udo

Hi Paul,

the output format must be 'yyyy-mm-dd hh24:mi:ss' (ISO-Format). If you look at the generate SQL from your output you will see that DataStage include automatically a to_char() around you timestamp field.

Regards,
Udo

Nelc,

which DS Version did you use?

In DS 5.1A (HP-UX) each link to an OCI stage open their own session. In DS 5.1r5 and 6 all links (from the same transformer?) to an OCI stage use the same session.

Regards,
Udo

Hi Roy,

please take a look on the build in routine WeekTag. This handels correctly for non-US calendars the first day of a week (Monday) and year of week and the beginning of a week at turn of the year.

Regards,
Udo

But in the near future the DataStage repository should be in a RDBMS (Cobra Release).

Regrads,
Udo

Hi Rahim, did you enable row buffer in your job or did you use IPC-Stage or LinkPartitioner/Collector? At first you could increase the timeout time in the performance tab of your job. The error means, that the job couldn't get the exclusive access of the used shared memory segment in the specified t...

Did you enable transaction grouping in your OCI Stage?

Hello Starg, the condition lookup is ownly avaible in DS6/390. But you could solve your problem with the link partitioner/collector in DS 6 by using the modulo function. Generate an additional field "need_lookup" with the values 0 = not lookup, 1 = lookup. Then you are able to use the link...

Differences between DS 5.1 and 6.0

- IPC Stage
- Link Partitioner / Collector Stage
- Query Build in OCI-Stage
- Make Links with right mouse button
- Performance Analyzer in Director
- Show process data (rows/sec, num rows) in Designer during job run

Hi Amaruvi,

you should be able do this with the Parallel Extender. This has an SAS Plugin.

Regards,
Udo

Hi Vinay,

in the next release of the MQSeriers plugin you can select between browse mode and destructive reading. It should be available Dec/02 or Jan/03.

Regards
Udo

Hi,

use the MQSeries-PlugIn. Shipped since DataStage 5.

Build the oracle clint lib for datastage describt in readme.txt on the cd.

Add ORCALE_HOME in the dsenv file and append the SHLIB with $ORACLE_HOME/lib.

Hello Ramana,

the MQSeries Documentation is shipped with the cd -> MQ.pdf (see end of page 10 ff).

Check if you have inq rigths on the queue manager. This is IMHO a security problem. This will be fixed with a new MQ-Plugin at the beginning of 2003.

Regards,
Udo

Why don't you use MetaStage for this?