DSXchange

Can not provide any further help unless you post the definition of the stored procedure. Stored procedures called from, say, the ODBC stage must process a data set. They return a single (SmallInt) value to indicate success or failure.

Welcome aboard.

Check with your DBA how much of the database is quiesced or locked when backups are running.

I think you will have your explanation.

Your site needs to get some Administrators!

Job parameters must be defined in the job properties dialog. Use the fifth tool from the left on the toolbar, or Ctrl-J, to open this dialog.

Is this through ODBC and, if so, what is the total size of the row? There is a tunable limit (MAXFETCHBUFF) to row size in Data Direct ODBC drivers.

Nor should it.
will preserve the trailing spaces, because they are part of the data. DataStage behaves in the same way. If you want them trimmed, you have to trim them.

By tunning one can only assume that you wish to liquefy your jobs and store the same in casks or barrels. How do you define "performance" in an ETL context? What are your key performance indicators? Why do you believe your job design to be sub-optimal? Do you believe that your databases (DB2 and Ora...

Do some debugging. Find out what was actually passed. Job parameter names must be correctly spelled and correctly cased in order to work properly. Further, they must be enclosed in a pair of "#" characters when used in passive stage types. Did you type the job parameter reference in your design, or ...

Of course, if no column had been defined as Key, DataStage would not have known with which value it had to replace the parameter marker.

It is the resource disk that is used to store the data files associated with Data Sets and File Sets. The assertion by ggs to have knowledge that "both of the stages can be loaded with the data formats like .CSV,.txt,and .dat" is horribly misplaced and, not to put too fine a point on it, so wrong. N...

I still believe the single Convert() function can do it. Can you take a look at some of your accented data with a hex editor and confirm the byte codes being used?

Is the MQ Series server co-resident (on the same machine as) the DataStage server? This is a requirement if you are using version 7 or earlier of DataStage. At version 8 that requirement is removed; you can get by with just MQ Series client software on the DataStage Server machine.

For example you may or may not need to Import the web service definition.

You should use the expression editor to build expressions, rather than typing them in. That way you would get your input column names properly specified - that is, qualified with the input link name.

You need to provide a lot more information about the web service before any sensible answer could be given. What does it do? What arguments does it expect? What is the preferred method of accessing it?