DSXchange

Trun on your statistics and check whether you are getting the number of rows passed per second in the green link, once the job is finished.
If not you need to turn on the Monitor.

Decimal(4,2) ment total length is 4 and out of it, precision is 2. And hence the mantissa is also 2 here. If it is fixed width 4 consicutive digit can be read as 4,2.
In case of delimited input, 10 will be considired as 10.00.

You can try from ControlPanel Add or Remove programs and cleaning up the registry if required.

To narrow down, try running the job in a single node config file, so that, you can eliminate lower down the number of processors running for that user. And can confirm, whether its related to number of processor/user limit.

You can do this after doing a lookup, and sorting based on the data and using stage variables picking the lates and transforming.
But if yo give with some example, it will be easy to follow up.

panchusrao2656 - Do you mean to say, the waist time taken by the job is due to the post index building timing?

Do you get any erro when you give just this command,

DELETE From postal_loc_pickdel_test1 WHERE pl_location_lk in (select pl_location_lk from postal_location where co_ctry_lk IN (select co_ctry_lk from country where co_ctry_cd='#CTRY_CD#'

You can use plug in metadata as well.

Either you can use merger or lookup based on the volume of data. Since your concertn is on metadata, I guess you are on Concatination, if so just use cat file1 file2 > new filename command in any of the unix command execution option, like Execute command activity or Before/After job subroutine.

DSJobStartDate of what? If its the for the job that produce the file, you can use UserVariable Activity or Routine activity and use the same command DSJobStartDate and pass as UserStatus.

Check whether you are trying to give the same path and name as the existing job.

@INROWNUM or @OUTROWNUM.
DSLinkRowCount is similar to @OUTROWNUM not simlar to @INROWNUM.
Have a constraint in the transformer, you can find the difference.

move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter#

Hi Nick,
Welcome to Dsxchange!!!

You may need to say the purpose of cursor as well. Do you have more to come in the Body part of the cursor? If it is just to insert into the a table with a some condition, you can acheive this with simple quer with decode logic and where class.

Welcome to Dsxchange!! Basically Datastage uses the credential features of the operating system upon which the server is residing. In your case unix. You may be not to loging to Unix, but if you could not loging to unix using given user id, it wont allow you to log to datastage as well. Apart from t...