DSXchange

Hi Ernie,

Thanks for the response, it worked!!

Bob.

I need to create some xml output which contains an embedded one to many relationship and I can't see how to do it. Here's the simplified source data Pr_Key,Name,Friend_Number,Friend_Name 1000,Bob,1,Peter 1000,Bob,2,David 1000,Bob,3,Fred 2000,Chris,1,Mary 2000,Chris,2,Sarah 2000,Chris,3,Erica 3000,Ro...

Well there you go! I found the relevant entry in DSXchange almost by chance! If I'd only typed in the right search words it would have been easy. Here's the link to the answer, basically it's a couple of entries in DSParams that need changing: Below is the link sent to us from IBM support concerning...

I have not redirected log myself but worth checking, can you tell me where to look? Nothing obvious on the Director screen. The Status screen appears normal, there is just no log to view. I have just created a simple text file to text file job which surprisingly aborted but I am not able to see why,...

I am just trying to get a new DataStage Rel 8 installation up and running on AIX and, whilst the jobs are running, I cannot see any log entries in the Director. The View/Filter is set to Oldest to Newest, and I have also tried Show All, so I don't believe that's the problem. Any advice would be appr...

I am creating a shared container which will write to an oracle table. The oracle stage characteristics will be passed in as parameters in the usual way. However, I notice that "encrypted" is not an option for shared container parameters which I want to use for the password. Does anyone kno...

Thanks for the info guys, just hit the same problem myself! Unfortunately I can't quite understand the command: DStageWrapper.sh -query "select x.Name,x.HostName from x in DataStageX::DSProject" what does the "x" stand for? and what is DataStageX::DSProject? Thanks for any assist...

If I understand tour requirement correctly then I have done this several times before! I also imagine your data looks like this: 100......Q11 A11 100............... 100.............. 100............... 100.............. 101.......Q11 A11 101.............. 101............. 101............. 101..........

Thanks guys, most helpful.

I certainly agree that we don't want to reinvent the wheel, but sometimes these things can be useful!

Bob.

The blocking information I was referring to can be found at the end of the match report (matchname.RPT) in the Data folder of the project. If you are doing an exact match with the Char comparison algorithym you do not need to bechanging the m or u probability settings. I think I ould leave these as ...

Not quite sure what you mean by "stops". How do you know the match has stopped? Is there an error message anywhere in the log files? Does the job actually abort? Do the files in the Data/Controls/Logs files stop increasing in size? The most likely cause is that pass 4 is creating huge bloc...

Has anyone come across this problem? I have created a simple buildop which looks for one character in another a string as a learning exercise. "1" is output when it finds the character and "0" when it doesn't, eg. 1 in 1234 gives "1"; 1 in 2345 gives "0". The ...

I have used QS reports in the past and, to be honest, it's not really worth the effort in my humble opnion. I think you will get on quicker and have less things to consider if you just take the output files in to your web process and take it from there. You might want to reduce their fixed length na...

I have used this derivation in the past for a surrogate key:

@PARTITIONNUM+1 : @INROWNUM

I wouldn't recommend it for a permenant key value, but it works well for temporary storage in a dataset.

Hmm! If you can I would try and find the logs and match report file if only because support will probably ask for them if you go down the help desk route which is looking likely! An alternative approach might be to actually implement the survivorship in DS. It's not too difficult and easier to suppo...