DSXchange

If you change the partitioning to "round robin" to make sure all paritions have data, does the error still persist?

girija - I just spent 5 minutes testing this at Version 8 Simple RowGen -> Trans/Filter -> Copy Stage. The Row Generator creates one seeded Random integer column with values of 1 to 100. The Filter and Transform only pass on rows with a value of > 50, i.e. about 50% filtration/constraint rates for 1...

Could you explain how you logically mapped the file (i.e., did you use "ln" for a logical link?). What are the user access rights to the symbolic link and to the actual file - try 777 and see if your error persists.

I had a similar issue on AIX, but cannot recall what was done to correct the problem. If I recall correctly, you should be able to install DataStage without creating a project; if you clean up your system and get rid of all log files and retry the installation without creating a project, do you get ...

Is this during the DataStage installation process, or are you trying to add a project?

The FMT(x,"17' 'R") statement will do what you stated you want done. Could you post your source data and the failed result of the format so that we could understand what didn't work?

I would recommend trying it from the command line with "orchadmin", if that brings an error then it needs to be reported to IBM as a problem.

Yes, please try to replace the output Oracle with a dummy copy stage and see if the error stays. Also, are you certain that you have no user-written SQL in the output stage?

I don't know what is causing your error, but did you use a hash partitioning algorithm (which would explain the empty partitions). Perhaps the view data command just doesn't like empty partitions (just like nature abhors a vacuum). Also, have you tried using the command-line "orchadmin" command to d...

If you replace your output with a dummy copy stage does the error go away? I think it might be referring to your input link, and I though Oracle SQL needs you to specify the keyword "as"?

Assuming you don't have a declaration for Column5 in your link going to the output Oracle stage, my first thought would be to see if you have any custom or manually typed SQL in use.

Excellent job of narrowing down the problem. So now you actually can get a data file and the SQL script and could reproduce the problem outside of DataStage so I would suggest you involve the DBA so that he or she can monitor what happens when you run it.

Create a job with a row generator and the column you are using to filter, run it through the filter stage and into a copy stage that has no output. Use enough rows of data so your job runs at least 10 minutes. Change the job to a transform stage and re-run with the same amount of data. What results ...

Could it have something to do with the "sv" column not having a data type that supports a number as large as 5184531156206099433639,3698732678 ?

All I have here is V8 where that routine does not exist, but do recall that the original SDK cobol conversion routines went in both directions (I happen to have quite intimate knowledge of that code).