DSXchange

Hello Ray, I have tried everything you have said earlier to locate the job that has created the Capture file. The file name was "Capture37292aa". I searched all the files in &PH& dir for the pid 37292. But, I didn't get any record with the pid. The main problem is that whenever suc...

Thank you so much Craig. I had the idea to use the job sequencer to do the job. But, I was just wondering if I was correct.

Thank you for your reply. I will do as you said.

-Gregg

Hi, I am also facing a similar situation. What should be done so that I can use the contents of a sequential file (just one value) as the parameter to the sql query in the OCI stage? For eg: SELECT * FROM tablename WHERE col1 = <Contents of the sequential file>; Thanks for your help, Gregg

Ray,

Thank you very much. All the information you have given is very useful to me.

Gregg

Thank you so much for the reply Ray.

Can you also please tell me how to read the records in the directory &PH&. I have searched the forum for more help in this regard but didn't find any information.

Appreciate your help.

Thank You,
Gregg

Hi, During the daily refresh of our warehouse some of the DataStage jobs abort (still in development). We then find that there is a huge file named "Capturexxxx" left behind in the temp dir. Since there are many jobs that are aborted we are not able to figure our what is the source for thi...

Tom,

Please take your time. I am in no hurry and look forward to your valuable insights in this matter.

Have a great weekend.

/gd

Tom, Thank you so much for your input. Most of the issues you have mentioned, I never thought about them... I thought it was enough to convert the logic in Prism into DataStage... 5. Walk thru each Prism program looking for logic before file open and after file close. Can you please explain the sign...

Hi, We have a warehouse that was designed earlier using Prism Warehouse Executive. We now want to move on to using DataStage for our warehouse design and maintenance. I would like to know if anyone has done this before. What are the major issues that we should be aware of when doing this? I would re...