DSXchange

Local run-time message handlers are stored in the RT_SC nnnn subdirectory in the project, where nnnn is the job number. I have no information ready to hand as to whether these are exported with the job, with the job executables and/or with the job source code. If it is not, copy the file called Loca...

If it runs successfully it does not need to be reset.

sudharma wrote:I want to reset this 7 th job because , this 7 th job runs fine when i run my Sequence for the first time .

Is the development system on the same version as the production system? Exactly?

Were the Options settings in the Export dialog identical in both cases? For example, did the production export include defaulted properties and the development export not include them?

Given that the permissions are 666 everyone can see the file anyway. What is the executing user's ID and umask setting? As creator you could always execute appropriate chown, chgrp and chmod commands in an after-stage or after-job subroutine.

What command did you use to bind the package in the first place?

What happens if MonthfromDate(RUN_DT) is 12? You need an If..Then..Else in svMonth. Then you need to convert the integers to strings to assemble the date-string. And when you do that you need to ensure that the resultant strings have leading zeroes.

Assuming you have version 7.5 or later, the parameter value itself can be given by an arbitrary expression. The entire expression I posted earlier can be used right there in the Job activity's parameters grid.

Try exporting the job, renaming the original, still in the project (say to jobname.BAD) and importing the job afresh. Curiously this sometimes works.

No. I need to know WHY, with both options in place, this error gets generated. And therefore why removing one - either, perhaps? - fixes the problem. In short, how it was resolved. Not what was done.

If you are using a Hashed File stage to extract data from a hashed file - and it won't extract data from anywhere else - then on the Selection tab there are two fields. Put your selection criteria in the top field Key > 0 Put your sorting criteria in the bottom, "other clauses" field BY Col1 BY col2...

What delimiter character is used in the file, and what delimiter character is specified in the field level properties?

Of course /:/u/whitef/public/ds_test.csv is not a valid pathname, because you can not use ":" as the name of a directory.

How was it resolved?

but i have restriction to use only Sequential file stage for the source. Always push back on (that is, resist) insane requirements. Demand justification. Would they expect you to tighten screws with a spanner? You have the right tool; insist upon the right to use it. It's not as if it's not in the ...

If you have QualityStage this is something that it does extremely well right out of the box. It's called standarization. There is a QualityStage plug-in that you can use to call the STAN task right out of your DataStage job. In version 8.0 there is a STAN plug-in stage that you put right there in yo...