DSXchange

Not much to explain. Simply replace your staging tables with sequential files, swap your OCI stages for Sequential File stages. Landing the data to flat files instead of loading them up into staging tables cuts out all the overhead of the database, which it seems like you are not needing. Now, if th...

The Parallel a.k.a Enterprise Edition includes Server jobs, so both types of jobs can be built and run.

Better to correct the permissions problem.

There's absolutely no reason to use User Defined SQL to do that - the stage will automatically generate the 'proper' TO_CHAR (and the corresponding TO_DATE) sql for you based on the datatype. IMHO, user defined sql should be avoided at all costs, only when you've got no other choice should you fall ...

Now can you help me to figure out a way So I can upload a constant string type in date type OCI stage. You just... do it. Make sure it is in the format the datatype is expecting. For example, declared as a Timestamp it would need to be in the format YYYY-MM-DD HH24:MI:SS to 'upload' correctly, assu...

jagadhish wrote:The SP is already existing one, we cant change it.

Just for the record, I didn't suggest you change it - I suggested you pitch it.

First suggestion would be to read the XMLPACK_20_Designer.pdf document that you'll find on your pc in the 'Docs' folder under your DataStage client installation directory.

Both statements are correct. Resetting a job puts it back to a runnable state, no recompile needed. Aborted jobs must be reset before they can be recompiled.

Does this really need to be in a SP? Why not convert it to a 'normal' OCI query?

1. As long as we're not talking millions of records, then sure. Suggest you read the Property Help for the Sort Specifications field to understand the syntax used there and always provide a specific location for the Temporary Directory so it doesn't default to your project. 2. Other more traditional...

Another suggestion would be to always debug from a 'fresh' Designer session. I've had intermittent issues if I've been working with a job or several jobs for a period of time in a Designer session and then attempt to debug. It usually results in a crash or the more typical abort with the 'debugging ...

Are you sure you have the file names correct? Case is correct and they are fully pathed?

First suggestion would be for the person with the issue to reinstall the client software and see if that helps.

Optional plug-ins, like the Pivot stage, are chosen during installation of the Server. If there are some you didn't select, you will need to repeat the Server installation in order to get a chance to select them again. The good news is the software is smart enough to know you are in 'Maintenance mod...

Oh, agreed - it can be slow as mud at times generating 'large' amounts of XML... that's why I was curious which external parsers you've used.