DSXchange

Hi,
How to execute a SQL script in Close Command Option in Oracle Enterprise Stage?

Thanks
Rahul

Hi,
Can we use DataStage DATE function in Filter Stage?
if yes could you please let me know how.

Thanks
Rahul

Hi, I am using filter stage to filter out records based on a date filed. In order to select the latest day's records i would like to use sysdate. Can anybody please help me with the same, because it seems sysdate doesnt work with DataStage. The condition in where goes like this: DATE_FILED > SYSDATE...

Hi, I am using Oracle Enterprise Stage to load a few big database tables. I am choosing Index = Rebuild options. The table is being loaded in parallel, however, the indexes are not using the parallel functionaly, eventually taking more time. Could anyone please suggest how to make DataStage EE rebui...

Hello, I am using the Sun OS (SunOS edwps405 5.8 Generic_117350-21 sun4u sparc SUNW,Sun-Fire-15000) and facing the same problems. Could you please advice me on the patch you mentioned and the relevent details if any. Thanks very much Rahul Hi You havent specified what unix OS you are using.If it is ...

The calculations are based on the actual space occupied by the DataSets and respective oracle tables.

There are no CHARs in the database tables.
There are only NUMBERs, DATEs and VARCHAR2s.


Thanks
Rahul

Hi, we are about to define our Scratch and Disk space for DS EE 71r1 on Solaris 5.8. We have quite a few DataSet jobs creating persistant datasets. It is observed that datasets tend to occupy a lot more space then oracle does. Accourding to the statistics i have accumulated, following storage requir...

Hi,

Can I have some guidance on what all can we delete from the ascential file systems so as to save some space.

thank you.

Hi, Whenver I try to add a sequence (containg both parallel and server jobs and subsequences) to schedule, it throws an error: _______ Error adding to schedule: you are not authorized to use at. Sorry. (Command was: at 17:00 today ) (Data was: /opt/ascential/DataStage/Projects/H3g_Odh/dsr_sched.sh /...