DSXchange

ur suggestion siuts for one job if there are n no of jobs using the routine then wat is the solution If n jobs use this routine then by replacing the code and recompiling all n jobs will immediately use the new code. The other routine would be to do a full export of all jobs, then manually edit the...

nkln@you wrote:...I could not find a way of recovering them. Is there any way of recovering them...

I would attempt to delete the jobs and then reload from a your backup .dsx file. Since you have file corruption, you should also run the DS.CHECKER command (after doing another backup)

What is the data type and contents of the 3rd column? Could there be some nondisplayable characters there?

That error will occur if the key contains a field mark (char 254) or char 000, any other characters in the ASCII set are valid.

This sounds like a misconfigured APT.CONFIG file. Can you post your version on test and also compare it to the active version on your development box?

There is no built method to do this. Can you just replace the code of X1 with Y1 and recompile the new contents of the routine?

What is the size of RT_CONFIG1303\DATA.30? I am guessing it might be 0, in which case you will not be able to run a fix file since the data is gone. Your only option is to delete that job (which will force a delete of this corrupt configuration file) and restore from backup. The blink errors you pos...

pp - as far as I know this cannot be done, i.e. column names need to be used instead of positions.

You will need to create a loop in your sequence job, which reads one file name off the file list returned from your command stage and passes that value to the job as a parameter.

It would be very helpful if you posted your complete compiler error.

Hello jaideepbakre and welcome to DSXchange. If you remove the AsInteger() function does the job run (you will get a warning message about the implicit conversion)? What stages are the 3 outputs going to? If you reset the job do you get an entry in the log file labelled "from previous run...", and i...

You will need to tell us more about the job "holding up" when using a reference lookup to DB2 before anyone can help you.

ecclesr - I think you are mixing up the terms for server and client. The DataStage server needs all of the files that is installs with and you cannot safely delete anything from the master install directory. If all you wish to run on a client machine is the dscmdexport.exe program I think you have l...

You can run DS.CHECKER from the UV shell or from the command tool in the Administrator. It would be best to make a backup before doing this, just in case more goes wrong than expected.

Pavan - don't equate compile time with execution speed; the delay in the compilation phase that I've seen with TRANSformer stages is very lengthy, but the compiled code executes very quickly.

Are you more worried about compile times or run times?