DSXchange

Try it without the double quotes and hashes - i.e.

(Original post retracted - I misread and misunderstood the question)

Are all the columns numeric of the same type?

This would be an IIS configuration setting. Using the web front end you can set up DataStage to authenticate and only use one userid for actual logins at the OS level. It would seem that it has been set up to be "dsadm" at your site.

Not automatically. You will need to make a backup of the project before deploying so that you can restore that state should your deployment fail.

Yes, it is the same software.

Yes, if the record already exists then the "insert" generates the error you posted. If you do an update first, then an insert, you will not see this error.

Those are all different names for the software application.

There aren't any published books available at stores, the only books are the tutorials and documentation that ships with the product. For this reason it is generally recommended to take at least the introductory course(s). Are you looking for general literature about Data Warehousing and ETL or spec...

The "orchadmin" command is documented. the "dump" option does exactly that, it dumps the contents of the DataSet to standard output. This command doesn't modify the dataset at all, just does the DataStage equivalent of a "cat" of the contents.

It seems as if you have written a before-after job routine instead of a user function.

As MDB has stated, the filename indicates more of a normal text file instead of a Dataset.

Where is this error being raised, in which stage? What is your Oracle database character set?

Actual, there are switches you can set to make the build-op look like it is wave aware. I am not at my system now to check how I did it, but I do think that this switch is documented. As Ernie has already stated, unless you are doing wave processing with MQ-Series (as we are in this case), you can d...

Nisha, welcome to DSXchange. With many problems like this one, someone else will have encountered it before and there will be solutions found in old threads. This is a good example of this type of a problem. For this reason it is recommend to use the Search facility. In this case many posts are dupl...

Did you change the values in the Administrator tool or did you edit the files from UNIX? The first line in the log of a job run will show the ENV values - which parameters are declared there, the old names or the new ones?