DSXchange

Try to monitor the CPU usage of your server when you run this job. For initial load (or atleast for testing) change the update action to Insert and drop indeces in the target table (if you have any) before loading the data. If you database and datastage are of different server, check for network con...

Force compile will do the magic for those jobs where design is copied. RCP can be siwtched off for the whole job as well.

Even DataStage Server Edition version 8.0 doesn't have a Universe engine.

Humm... Then just just XML pack installaion for upgrade wont do the wonder, as told by the product manager or someone.

row_to_external() should refert to the ftp interface. Try to write it in to a sequential file. And check if there is any thing unexpected. Later try to ftp the same file from command prompt and check if you find any difficulty in that.

If you are using DsRunJob(), ther is a run mode DSJ.RUNRESET.

Check for the data, if Null or any ^M is been passed.

You can leverage the Creation of Jobs from Templates, if you need to create many similar jobs.

Hope all these question were not Interview question.

Version 5 onwards.

Large volume of data will consume time, but you can aproach the data to load in parallel streams by dividing the input data into parallel similar stream. If you add index on the key in which the look is made in target, it may increase some performace while finding the record for Update or insert. Bu...

userasif - Either If you dont find any jobs or if they are not compiled, you may not see the options to run the jobs. So check if you were able to find the jobs using other User id.
If not even in other user id, you may need to Reindex your project.

But you can try to have a ORDER BY class or a Aggregator in the job to check if the lock be released, so that you can delete in the same job.

You can see his message if you click here and proceed further.
For the date issue, if or using user defined SQL use TO_DATE() funciton, else convert into requried fromat in Datastage Transformer.

If you are using ODBC stage, and using Call StroredProcedure, just pass some dummy argument. And you need to chagne your stored procedure to include one input argument to be present. You can just use a transformer with out any input, or another database stage, which pass some dummy value from its ex...

chulett wrote:Detail Suppression. Run the query with and without and you shall see, my young Padawan.

Thats obvious from you, Jedi Master.