DSXchange

Although you can use integer values for the return value, you should always use the supplied constants as found in the documentation for the DSGetParamInfo() function, so code IF (v_paramType = DSJ.PARAMTYPE.INTEGER) THEN ... Note, you cannot change the value of a job's parameter after it ha...

Does this XYZ folder actually get created by the batch? At compile time no checking is done for source and target file paths, so you won't see this error message then.

Start with the sequential file error. Do you have a column called NAME and can you view data or read the file without the combine records stage?

What will happen is that if the last run of the job you are checking has warnings or error or hasn't run since compilation your current job will abort.

Since you have already sorted the data, you can use the server method of storing a row in stage variables and comparing it with the previous row's value. I'm not at a DS system now, but are you sure that no alternate output is allowed for a remove duplicates?

I'm not quite sure what your question is. The code snippets don't look incorrect (if you assign the appropriate parameter name to the v_paramName variable)

dsguy - I apologize for my earlier post about assuming you hadn't tried anything.

What was your error message when you tried this?

It would also be helpful if you could define "hanging" in this case. Does the job monitor show any rows processed or what is the status? Are the UNIX processes still running when this happens and is there any load on the system? If it accesses a database, are the connections open? How long do you wa...

laxmi_etl - you still haven't given us any error message with which to work. Please, post those details.

I give up.

p.s. Why did you quote your oringal post?

umamahes - I'm confused, why did you quote your original post, but add no comments?

Can you connect to "KISHORE" via your PC client's command line, using "TELNET KISHORE"? If not, perhaps you could add that host to your HOSTS file, or use the IP address to connect to the server machine.

You are right, the Oracle log shows no errors.

laxmi_etl wrote:The error gives Oracle log file reference...

That is the error message whose contents could help.

laxmi_etl wrote:...The error gives Oracle log file reference. And the log file does not show any errors. ...Any thoughts.

Sure, my thoughts are that you haven't posted the exact error message, so there isn't much to work with yet.

You have a bad media. One thing you might try is copying the CD to disk and installing from there. Or clean the CD. Or try another CD drive.