DSXchange

Yep. There it is.

Thanks, Ray. I appreciate your help.

Tony

Hi all. I'm running DataStage v6.0.1.5. I am trying to do a multirow lookup and found detailed instructions in both the help file and this forum. I cannot seem to find the "Link Properties" item in the sub-menu for the link. This link is an ODBC stage and is a reference link. When I right-...

prem,

This is a wild guess. Is it possible that the data in the column has a character that you have specified as the column delimiter for the flat file?

Hope this helps,
Tony

Never mind. I think I have it figured out. It wasn't intuitive to me to chain a bunch of Routine activities one after the other (each one returning a different job parameter from a file) to feed the Job Activity. I wanted to put multiple inputs into the job activity and it can only have one. Thanks,...

I want to read job parameters from a file and set the parameters in a job sequencer activity. Apparently, I don't understand the job sequencer activities, etc enough to do this. I can see that I can run ONE routine and use the return value from the routine to set any job parameter on a job activity....

Thanks, Vincent. I appreciate the info. This is exactly what I suspected. It's good to have it confirmed.

Thanks for your help,

Tony

Does anyone know of a way to read to/write from a Microsoft Access database from DataStage running on Unix?

I appreciate your help.

Tony

I've received this message before when I called a routine and some sequence of logic caused me to set Ans = to some variable that I had never initialized (never set to a value).

Hope this helps,
Tony

I physically deleted all the files and directories associated with the hash files and recreated them. Still acts the same.

Tony

Thanks, Ray!

Now that DataStage is my main focus at work, these kinds of things are very handy to know.

Thanks again,
Tony

Thanks for enlightening me, Craig. I have never seen this explained this way in the documentation. I appreciate your help.

Tony

It happens both in the same job and in a new job that I created that just had a hash file stage and a sequential file stage. Read the rows from the hash file and wrote to a flat file. Looking at the data in both hash file and flat file within DataStage showed all but the last record. Looking at the ...

Ok, guys. I've been thinking about this for a few days now, trying to reconcile both Ray and Craig's answer. Let me see if I understand. I mentioned checking the Clear checkbox on multiple hashfile stages for the same hash file. Craig, you mentioned that this was unnecessary because DataStage is sma...

This is excerpted from a function someone else wrote, so YMMV :) FileName = Arg1 OpenPath FileName To FileHandle Then ... do stuff here :) End Else Ans = @False Call DSLogFatal(" unable to open file, status = " : Status(), "YourRoutineName") End You might want to read up on OpenP...

I'm using DataStage v6.0.1.5, on HP/UX. In Designer, when I look at this one hash file in this job (View Data), I only see the first 8 out of 9 records in the hash. When I read from the hash file and write the data to a flat file, I get all the data in the flat file, but if I press the View Data but...