DSXchange

John - this is a PX subject - so the typical server conversions won't work and you should explicitly convert datatypes and this is what Ray has pointed out.

The effective limit of your designer canvas is reached before any DS limit on number of files. The deciding factor is your ulimit nofiles setting.

ExecuteSQL is not a builtin DataStage routine. Using your Manager, look in your Routines to see if you have the source, if so then compile it. If not, then try to find out where you got this routine from and load it.

Jackie,

you can use a clause similar to what you've shown, the logic is sound but you might get a syntax error.

a non-zero value in the after job subroutine will cause a warning to be raised in the job log. You can issue a call to DSLogFatal() to force a fatal abort in the after-job subroutine.

There is folder in your project directory called DSU_BP.O which contains the compiled object code. The object code for the user defined ExecuteSQL routine is not in there. If you have the source to this in your project then compile it.

DataStage uses the terminator to find the end of the line/record. If a terminator is found in any but the last column it will know that it is part of the data. But the last column cannot contain a terminator in addition to the "real" terminator because DataStage has no way of determing what type it ...

Take a look at this thread for dynamic evaluation using EVAL in Basic. It is rather roundabout and inefficient but will work.

You do not have the routine "ExecuteSQL" declared or compiled.

Umberto - you are out of luck, such a tool doesn't exist

Hello Jackie and welcome to DSXchange.

This type of functionality sounds like it can best be handled in your database with a user-defined query to select the relevant records into datastage and then to a stage where you can delete them.

I think 5 rows per seconds is very good.... Some server jobs where I currently am do 30,000 rows per second, PX jobs can do in excess of 60,000 rps {given a very big DataStage server and an even bigger DB2 server}. If you are working with a database, try to see what speed you can get with the faste...

This subject came up in a thread just a couple of weeks ago, you can search for it if you wish. If directory is corrupted but still exists, you can try to copy the VOC file from another project into the directory and then immediately delete the project - it will be unusable with an invalid VOC file ...

Please post Server questions in the server forum, not in the general one.

Have you checked at UNIX level to see if this file exists or not? And if it does, does your user id have RW access to the file?

The routine that you are going to write will contain a couple of key calls that you can look up in the DataStage BASIC Programmer's guide , namely: DSAttachJob() - to attach to the job you wish to get information about DSGetParamInfo() - to get the parameter information for that job run DSDetachJob(...