DSXchange

The error message states "read-only file"; so either the umask for files you create doesn't allow you to the the files (rather unlikely) or to code is trying to clear a file which someone else created and you don't have "R" access to. Check access rights to files in your project directory, which is ...

There is no benefit in duplicating the data in a flat file. Also, if your table is partitioned you might actually get better throughput from the parallel database access than by using a single-threaded sequential file. I don't think that sorting would make a difference here. Luckily, all of these qu...

can you connect to that database using the same values for host,user,password with the sqlplus tool? Is your tnsnames correctly set and sourced?

The error message relates to your user's permissions on your system. The CLEAR.FILE command needs more than just "RW" permissions on the files, so you would need to be owner. Have you changed the umask settings? have you tried running as dsadm?

You were too fast reading my reply - I was going to delete it! The DataStage mainframe system is different from Server/Parallel so there is no way that I know of to do an automated conversion. Perhaps others here know of a way to do this.

Compare the director log entries for the parameters between the manual run and the job sequencer. A job will not "know" that it was started from a job sequence so there should be absolutely no difference between runs. Change your Oracle output stage to have a reject link and find out the reject reas...

Yes, it is possible. But it is not possible to do it purely via software - you will need to do manual work.

When column In.Datefield is '01/25/2008' then the derivation is

There is no utility, but you can select and delete multiple entries in the Manager.

View data will not work unless the queue is local to the server. Always try to run the job with the MQ Connector

A job will not run differently when called directly or from a job sequence - unless you pass different parameter values. Could this be the case?

I don't see how you can change the filter in the stage interactively. Also, are you doing Wave processing?

If you limiting yourself to a lookup stage, then you have 2 phases - the first is getting the data from the source system into DataStage and the second is applying the lookup query to that result set. Phase 2 will be identical regardless of source (assuming you don't try a sparse lookup). The sequen...

swathi Singamareddygari wrote:StringToTimestamp(svr,'%yyyy-%mm-%dd %hh:%nn:%ss')

What you are doing cannot work. Your string picture is in absolutely no way compatible with the decimal numbers you listed. You are telling DataStage to convert the number "85363200" into a date formatted
as listed above?

Oracle Date and Timestamp are not stored with formats. You can choose which display format to use when converting to a string or display output.
What is your actual problem in this case? What format do you need where?