DSXchange

What source are you reading from? A sequential file? It sounds as if you have declared the fields to be fixed length but they are of variable lengths so you would need to change your file metadata. Does this file have column delimiters? If it does then the change to a varying length column should be...

Welcome to DSXChange!

The message is saying that the sequence has tried to start a job, but it is in a state of not being "compiled" or it is currently running and thus cannot be started.

Welcome to DSXChange. There is no built-in command with which you can delete a specific job's log file contents. It is possible to write some some in BASIC to do this and I think that parts have been posted here before. It is best to stick with the standard purge mechanism, i.e. purging a job's log ...

.....simple copy paste in come other place??... Also if I create a new project with a different name and paste all these... A UNIX or Windows copy-paste of a DataStage account will not work. The engine stores information about secondary indices inside hashed files using an absolute path, so any cha...

But the name of the descriptor file can be changed; yes - the data files will retain their original naming conventions but the access will always be through the descriptor so that doesn't make a difference. It might be a bit misleading if someone browses the data directory but functionally the name ...

np, Peter. I've been driving the bike outside and keep on having to come back every once in a while to thaw out so I login to DSXchange. That "+=" name is not supposed to be there, you should also check the DSU_BP directory for that name and perhaps other ones that don't belong. That text is used in...

splayer, you also need to set your other environment variables using the $DSHOME/dsenv script. Have you checked whether the file exists and that you don't have execute rights to it? You can rename the .ds "descriptor" file using UNIX "mv". The file only contains information linking to the actual dat...

Although it is possible to install two instances of the server on the same machine (I'm not at a machine with DS right now so can't tell you where in the intall/upgrade manual this is described - but I think it has a whole chapter to itself) I don't know if this will help you, since the issue seems ...

The plugin installation doesn't affect the jobs as far as I have experienced. Are any of these plugins used in the job in question?

does the "=+=+=+=" error occur when exporting in the new project as well?

Peter, without looking in detail at the generated code there are a couple of questions that I do have - are the 2 comparison code snippets you posted from the same job, i.e. one you exported from the non-working project and then imported & compiled on the working one? It looks like they are diff...

splayer wrote:There is no orchadmin rename command so I have...

No, use a UNIX rename for the descriptor file.

The code in the file "'RT_BP1043/JOB.368399344.DT.1427061638.TRANS11" is ASCII, please post the first 16 lines, as it seems that some syntax error before the actual line displayed has gotten the compiler confused.

yes, orchadmin delete a and then just rename b.ds to a.ds

No need in this case to actually copy data around.

DSLink6 is a lookup, and you specified that Column C is a key for this lookup and thus it needs some value. You could have put a constant value into the Key Expression Box if you wanted to (it would have compiled but perhaps not run the way you wished). I assume you have modified your job since the ...