DSXchange

isql/osql command line script. By writing a reusable wrapper script now for executing SQL scripts or procedures, you'll enable a long term elegant solution for running scripts quite easily from a Command stage in a Sequencer, or the Command stage in Windoze Server jobs. You'll also be able to use a ...

Better get on it quick, we're due for another 10 posts now that a new version is out.

dos2unix supports streaming input and output I believe so it's really an easy choice. It would take care of those trailing ^M's on the file. As to high/low chars, well, that's a different story.

Still don't like that DOS radio button solution, eh?

I haven't ever tried it, but you could consider putting the return SQL DBMS variables that come back into another output link and constrain that link to a list of error values. If you want any of those values to abort the job, just set the Abort After N Rows value on that new link to 1 to abort on t...

I am waiting for a tool from Ascential , whcih can migrate the Server job inot Parallel jobs There's no equivalent of a HASH file, all user-written DS BASIC functions would have to be magically ported, you'd end up with non-parallel jobs just to satisfy jobs that HAVE TO sequentially process data r...

Not really, the Informix CLI stage is unlike ODBC and Oracle OCI stages in that DATE data type fields MUST be presented to the CLI stage in the DataStage BASIC internal date format. Viewing the data has rather odd results in newer released of DS, in that you see the internal number followed by an IS...

If your whole issue is that you want to sequential assign a column the new available unique number, why don't you manage the process yourself inside the tool? There are many useful techniques for doing this. All rely on "seeding" the jobstream with the starting value from which to assign. Then, use ...

A little birdie (actually an Ascential Consultant) once whispered in one of my previous client's ear that Server jobs are due to be extinct in some future version of DataStage and he'd be better off doing his entire dev in PX for future maintainability. Har har har. Yeah, that's a good one. Do you ...

If you are using the Informix CLI stage, you must use the internal DS date format. Please search the forum as various solutions have been covered. This isn't an "issue", it's a feature.

Change the radio button on the Seq stage to "DOS" instead of Unix.

Or run dostounix on every export file when finished.

Absolutely not.

If you have need to use job parameters, then fetch them from hash file and put into into parameters using custom job control or Sequencer logic.

My original answer is still sufficient because the question was wide open and I answered in like fashion.


I left out the conditions because the poster didn't ask about operating systems, versions, licensing, or any other restrictions.

If I was to experiment, I would create a table that matches your dataset and run that dataset into the table. Enable parallel on that work table, alter your session enable parallel dml. Then, check the explain plan on deleting from your big table where the matching key is in your work table. Somethi...

Sure. 1. Look at the load on the server/nodes. Do you have full resources? 2. Look at the queries running against the table. Anybody doing stuff? 3. Look at the indexes. Are there a lot? 4. Look at the indexes. Are they partitioned and are they global or local? 5. Look at your table. Is it partition...