DSXchange

You can't wrap a DELETE ALL before-SQL with row-by-row INSERT statements into a single transaction within a DataStage ODBC connector or enterprise stage.

Do you have a calendar table from which you can determine whether a day is or is not a business day? If so, a query against this table will give you the number of days that you need to add.

Welcome aboard.

The double slash in the keystore pathname might be the problem.

To calculate a rank within DataStage you need your data to be sorted on the column for which the rank needs to be calculated, and you need two stage variables. The first stage variable returns the rank, and is incremented if the value in the current row is different from the value in that column in ...

Tell me the exact error message you got from the SQL, or review the UniVerse SQL User's Guide (downloadable from Rocket Software).

Why? What's wrong with your solution? We implement almost exactly that scenario in that way (though it's a 15 minute interval), with the addition of a mechanism for notifying the sequence to stop (a file comes into existence).

Read the as decimal column in database as varchar in datastage. This way there wont be any unwanted zeros. Similarly, to specify a data type in DataStage one must name the column. Therefore this approach will not work. I suspect what was actually being suggested is CAST columnname AS VARCHAR(size) ...

No.

If you are going to transform the data in a column you must name that column.

PIPE-SAFE means that there's guaranteed to be a read process so that the pipe does not become full (and break as a result).

Simple IF statement to control whether WRITESEQ is executed.

You can also put HEADER SUPPRESS at the end of the SQL query.

They should be derivable from the project's Engine configuration settings.

Did you enter the correct URL? (http://serviceshost:9080/ibm/iis/console)

Is the WebSphere Application Server process running?

SUBROUTINE ParseTimeString(InputValue, ErrorCode) Equate TAB To Char(9) DEFFUN OpenSequentialFile(FileName,OpenMode,AppendMode,LogMode) Calling "DSU.OpenSequentialFile" ErrorCode = 0 hInFile = OpenSequentialFile(InputValue, "R", "A", "Y") hOutFile = OpenSeque...

Fair enough. Then the job could write untransformed data into the flat file that the subroutine processes, and the routine could be invokved as a before-stage subroutine in the second Transformer stage.

Check the score. The operator for reading from or writing to Data Set is copy which may be eliminated by the optimizer. This, in turn, may lead to a record count of zero.