DSXchange

Hmm... the classic answer would be because you are not checking using the same userid that did the scheduling. But if it's always you, then something else must be going on. I've seen that behaviour once or twice running in a clustered environment, but I can't say for sure the clustering had anything...

A quick Google turned this up. It even quotes from an IBM reference.

More information please! Define 'old job' and what makes you think DataStage ran it. If you worked on a job, saved it back to the same name and recompiled it - all with no issues - there is no 'old job' for DataStage to run. Unless there's more to this story. The only other thing I can think of as a...

I don't know if this is different in version 5.x but in later versions it is documented (somewhat) in one of the big pdf manuals. I've looked it up before, having the same questions as you did and I don't recall where I found it - but it is there. Whichever one has the alphabetical listing of all of...

Well. I think you are going to need to expand your question just a wee bit. What exactly are you asking? What exactly are you trying to find out? That's a pretty ambiguous question, and someone could spend quite some time banging in a rather involved answer only to find out they 'answered' the wrong...

Just to expand a little bit on what my friend, The Other Craig, said: Packed data is just that - packed. It is neither ASCII nor EBCDIC, but in a format that is identical on both ASCII and EBCDIC based systems. That's why it's very important to know when / where you have packed data in a record that...

You can use Oconv or Iconv with the MCN conversion code to do what you want.

This should work ok if you use a single OCI stage, from what I recall. Depending on exactly what you are doing, sometimes setting the Rows per Transaction of the delete link to 1 solves the problem. If you are deleting existing rows based on the key you will also be inserting on, one record at a tim...

I tried to trasfer the data to a seq file but it is taking out the duplicate rows out. No... the hash file doesn't store 'duplicates'. If you search the forum for the terms 'destructive overwrite' you should find plenty of posts explaining how that works. The problem with comparing the data by extr...

Not directly, but here is a post that explains what you need to do.

'Search' is your friend!

I would have thought so too, but the fact that the data does not contain record terminators and the records are of variable length kinda makes that impossible... doesn't it?

This isn't going to be much help, I'm afraid, but... I think you are on the right track with using the CFF Stage because of the EBCDIC. I haven't used it to speak of yet, but from what I understand it is easier to use for this purpose than using the sdk EBCDIC routines yourself, especially with embe...

Ill forgo the use of them in some of my posts to even things out. We wouldnt want to run out!

Since no-one has replied yet... I'm assuming you have 'rollback' selected as the failure action, correct? In that case what you describe you want to happen should be what is happening - with one important clarification, depending on what you mean by 'previous' links. Since Transaction Grouping requi...

I have written a routine to call a shell unix using DSRunJob function. Welcome aboard! :D If you are trying to execute a shell script - no matter what the shell script does - you need to use DSExecute instead. Only use DSRunJob to start a DataStage job (typically) from within Job Control, and then ...