DSXchange

Post what you have installed for your C compilers and did you install the Microsoft SDK for Windows Server?
I'm guessing that your job can't compile? Correct me if that is thecase.

The error message looks suspiciously like one where you have not installed the right compilers or wrong version.

Have you tried the Aggregator stage? You may need to split out the data that you want to sum and merge them back. Read the manual on the Aggregator stage and have a play with it. There is option to SUM the columns.

Check your to_date syntax I think you need to define how the date format is.

Hi, You can install it on Windows XP Professional. You will need the following to be installed before you start your Information Server install. 1. Microsoft Platform SDK for Windows Server 2003 R2 2. Visual C++ 2005 Express Edition Both I believe you can download them from the Microsoft site. Obtai...

If you have an interview then best not to BS if you're out of your depth.
Partitioning is pretty fundamental in PX jobs so you will be caight out if the interviewer knows his stuff.
If there is time prior to the interview to take the DVD course as Ray suggested that is your best bet.

In your input seq file stage you can add the option for File Name Column.

Try researching on the dsjob command. There is an option to dump out the log details.

Contact IBM for patch ; it's a bug in the client software.

Can confirmed that this is a bug. In order to test the theory,I deconstructed the shared container into a server job. So no passing of Parameters from a Parameter Set to a server shared container from a parallel job - problem disappeared. I'm not going to pursue this further but just post this here ...

Thanks for your reply Ray.

Do you reckon the problem that I have is a bug in Data Stage?
Is there a list of known bugs that I can refer to for v8.0.

JS

Hi, I am using ParameterSets to pass parameters to my jobs. Sequence Job - runs Job A and Job B. Job B is a parallel job but passes data to a server shared container.(done that way due to historal reasons). Shared container contains Oracle stages to write to a Oracle database. Jobs run fine. However...

You can also try using an External Source Stage with a unix command to read the files ; handy if you need a bit more logic to determine which files to read e.g in cases where the file names are not in the same pattern.

If DS is running on Unix then there is not much options; the default ODBC drivers that are delivered with the standard install does not have anything for MS access.

Best to get the official C++ compiler from SUN. I can't remember but in the good old days the C++ compiler comes with the OS CDs. It's called SUNspro.

Thanks for that Craig. Ernie Ostic's document was very informative. I tried the 'ls' command and it passed just the name of the file without the full path name so i used 'echo' instead i.e. echo opt/dstransfer/dev/credit_sanctioning/xml_input/* ,which provided the full path name for the file as inp...