DSXchange

A couple of possible causes:

1) Ran out of disk space where DS is installed. In that case, more than just this one job could be affected.

2) More than 2GB of records in this particular log.

There's no DataStage restriction on flat file sizes. Your operating system or environment may inpose a limit on file sizes. I assuming when you say 'memory' you actually are referring to 'disk storage'. Always best to land or hash data, in my opinion. If you are concerned about the amount of space b...

Or you can use the 'old' style outer syntax - (+) - in the generated sql which will get you everything but a full outer join. User defined sql is a... PITA... and should be avoided if at all possible. IMHO.

Wait... are you saying that you only have a problem with this methodology when there are more than 2 billion log entries for a job?

DSSendMailTester. Routines/Built-In/Utilities.

That would be a DBA task, not a DS task.

Zabeerulla wrote:Can we use DRS Stage of DataStage 7.5.1 to connect Oracle 10g?

What happens when you try? Answer should be 'yes' but I haven't seen a need to use the DRS stage yet, so...

Search is your friend! I got 13 hits when searching for all words and 'reset KeyMgtGetNextValue'. Many of them have the actual reset syntax in them.

Because your column definitions don't match. Do you have a single column defined in the stage with the Display size set to 10?

As noted, depends on how it is being generated.

Because that's not how they are used. It only kicks in when there is an exception (hence the name), so your entire stream as it is defined now will only run when there is something wrong with the main jobstream... and there is no main jobstream. Hook Job1 to Job2, period. Take the Exception Handler ...

The changes needed in the dsenv file are fully documented in both the OCI plug-in pdf and the larger 'Installation and Configuration Guide for Supplemental Stages' - aka the instconf.pdf file. Basically, you are setting the ORACLE_HOME and 'shared library path' variables for the DataStage environmen...

Actually, you configure the dsenv file for the Oracle client information needed to use the native interface - the OCI stage. For ODBC, the other two files you mentioned are the ones that need to be edited. For ODBC, just copy what you find in the existing files for Oracle (assuming you'll want to us...

Not sure whom you are addressing, Ray, but my misconception was the fact that jobs that generate Warnings only would not Auto Purge. I was of the opinion that only a clean current run would trigger it and that warnings only - a Finished (see log) status - did not constitute a clean run. In that I wa...

Specifically included the second '2' so that both pieces of the time will be extracted - the actual time and the 'AM/PM' part since it's not in 24 hour format. Assuming, that is, that there is actually a second space in there.