DSXchange

sh won't work, since you're on Windows.

When you say "command stage" are you referring to an Execute Command activity in a sequence, or to something else?

Search (for -14 will do it). This code has been reported by many people, particularly by people with not enough grunt in their server.

If it works you can skip them. Otherwise you probably need -user and -password options preceding them. In that case you may also need to specify -server and, once you get to version 8, -domain as well.

Don't know, and manually (or perhaps by editing the export file).

Another possibility is that you build your data warehouse in a database that supports multi-valued fields, such as UniVerse or UniData. If and when required these support dynamic normalization of those data.

is the same as

That's just SQL.ERROR. You have to call SQLError() repeatedly to strip the error information off the handle, to learn precisely what went wrong.

Convert dates to Julian dates. Convert times to seconds from midnight. Do the arithmetic. Convert back to date/time/timestamp.

Put a reject link on the Sequential File stage. It will capture any row that does not match the metadata on the main output link.

You need to have installed the .NET C++ compiler before installing DataStage server.

Search the forum for OpenSequentialFile, a server routine that covers all the possiblilities for opening. Choose the one marked version 4.x. Then research ReadSeq, ReadBlk and CloseSeq statements in the DataStage BASIC manual.

use like this (u can use any name u want)RROWID = :ROWID. Since ROWID is a key word in oracle you cannot use the sameone in the job. Change it to something in ur job and it will work. U did not ask the question. U is one of our posters. The second person personal pronoun in English is spelled "...

waiting for reply ASAP Wait on. We don't do "urgent". DSXchange is an all-volunteer site whose members post as and when they can, if they have something to contribute. If you want urgent help sign up with your support provider for priority service and learn the true cost of "urgent&q...