DSXchange

There is no limit imposed by the software. There will be a limit imposed by the amount of memory available to the process.

... except that orchadmin requires APT_ORCHHOME to be set, in addition to the requirements for dsjob.

Find out who has the job open in Designer, Director (log), or Director (monitor). It that is a defunct session, disconnect it using Web console for Information Server.

Uncheck "log warning message for activities that do not finish with a status of OK".

Craig has it, but we had to be certain whether you meant that, or an export file, or something else.

Seach DSXchange for "access violation". There are lots of possibilities.

Please advise the source of this advice (that hashed files should be used as intermediate storage) and the context in which it was given. I predict that you have taken the advice out of a quite specific context.

Read the Parallel Job Developer's Guide about implicit and explicit data type conversions (you can search within the PDF). In short you can convert from any numeric to string implicitly but the reverse operation will require a conversion function. The name of the function will depend on whether you ...

In the Match specification block on NYSIIS of name and NYSIIS of first name. Use UNCERT (assuming an undup match). Your u-prob figure (probability that match is purely by chance) is very high, usually it's set around 0.01 - is there a reason for your choice?

And the error message ID ?

Ravi_nitj wrote:When I query the Oracle database 10g, I am getting the date shown in following format:
'mm/dd/yyyy'.

What does that tell you about the format in which your Oracle instance expects dates to be presented?

To which "backup file" do you refer?

Please post the complete detail of the error message, including the error message ID.

The database has a defined length, and may be objecting to metadata suggesting that the string may have a potentially larger (that is, unlimited) size.

Welcome aboard.

What is the default date picture in your Oracle instance? (What format do you get with SELECT Date_Column_Name FROM Table_Name; ?)