DSXchange

Do you need to sort the entire DataSet? Or just the data on each partition? In the latter case, the PX sort may well be faster.

In SQL terminology it's complaining about an attempt to

If your file really is fixed width it will look like vin shelke You need to be absolutely sure not only that the file really is fixed width but also that you have the column widths perfectly correct. If the file is actually some delimited format, then you need metadata to describe that format correc...

There's a file called ora.11858.910475.0.log.bad that will tell you what the problem in sqlldr was. You can use the oerr command to decode the Oracle error numbers, and usually get advice about how to remedy the errors.

Currently there are no manuals available for download.

This may change now that IBM has acquired the products, as their model includes publishing manuals on a web site.

But not yet.

You will note that you can not influence the metadata on this link, therefore the answer is NO as far as the Sequential File stage is concerned. The rows on this link simply don't match the metadata defined on the output link's schema. Possibly you could direct that reject link into some other stage...

If you have prepared SQL then clearly it can be done with user-defined SQL. Yes it's a horrible query but hopefully the query optimizer can deal with it sensibly. Some bitmap indexes, if these are possible, could make such a query really fly.

Of course. User-defined SQL in a regular stage type.

Do "insert or update" into the target table. Normally I advise against this but, with the complex selection requirements and the small volumes, you'll get away with it.

So, if session details aren't available, could one be buying a pig in a poke?

Is there any DOS command to check the size of the file greater than 0kb and to delete the file? If you're on 7.5 with MKS toolkit, or have MKS toolkit anyway, then you can write a UNIX script to do this. Something like: if [ -z $filename ] then rm $filename fi I don't know if there's a DOS equivale...

Be careful if you're really on Windows, which your original post specifies. The Windows line termination sequence is actually two characters, made up of a line feed and a carriage return. Since Convert() only does character-by-character conversion, you would definitely need Ereplace() - which does s...

You need joining (perhaps self-joining), grouping and possibly set functions when extracting from SQL Server.

Do it all in DataStage and ditch the PL/SQL? Each time you invoke sqlplus there's all the overhead of command line processing and parsing, waking an Oracle listener, getting the SQL organized (optimized?), and so on. DataStage establishes one connection, has the SQL prepared once, and then only pass...

You could use the Debugger if they hadn't broken it.

Almost certainly you (the executing user) lack permission to delete these dynamic hashed files. (Among other things, you need write permission to the parent directory, as well as write permission to the hashed file directories themselves.)