DSXchange

If there are no delimiters how do you know where one field ends and the next begins? You either have to specify a field width for each field, or specify string (Char) data type for each field, which implicitly defines the width. Put another way, without field width or delimiter you cannot have VarCh...

When displaying data type Raw (= binary) each byte is shown as a single character if that character is a printable character, or as a two digit hex number if the character is non-printable. The 00 characters in your data are ASCII NUL characters (Char(0)). Your 8.5 raw string shows Little-Endian rep...

DataStage has no in-built capacity for dealing in any way with BLOBs.

If you have a command-line utility for de-serializing the BLOB then, since you have a Windows server for DataStage, you may be able to invoke that utility through a Command stage.

I don't know the Oracle Enterprise stage well enough for a completely cogent response. Have you investigated using an Oracle Connector stage? Otherwise have you investigated using Before-SQL and After-SQL to issue commands to set and reset a lock?

There is no solution that involves a keyword when the job run request is submitted.

Look near the bottom of the DSParams file in the project directory on the DataStage engine. This is where the values that determine the location of logging are stored. One of them is ORLogging. What values do these have?

If you can carry through a column such as LAST_UPDATE_TIMESTAMP you can use the highest value of that as your tie-breaker.

Technically, "transaction isolation level" is part of the ODBC standards.

What exactly are you trying to accomplish?

Using the performance analysis tool in Designer (if you've enable the collection of performance data) or, if you have the DataStage Operations Console (introduced in version 8.7), you can get it from there or customise a report from the underlying database.

DataStage Administrator (only) is not much called for. In a well set-up system it would take about 0.1 of a full time equivalent. Information Server Administrator is a rather more complex set of skills, and so will command higher salary if you're any good at it. The former really ceased to exist at ...

Is it any faster using an Oracle client (e.g. TOAD) from the DataStage server?

If not, you may have network issues that need to be addressed.

Note, too, that it's not the time for the first row to appear; it's the time for all rows to arrive that you're interested in.

"ALNUM" is a datastage string function for checking if a field is all Numeric. No it isn't. Alnum() is a built-in DataStage function that reports whether a string of characters is wholly alphanumeric. Num() reports whether the string of characters validly represents a number (but this can...

Arnd is correct on both counts; CASE is not supported (use EVAL and an I-type expression), and you have not created a "UniVerse" SQL statement because your statement lacks a terminating semi-colon, so you've got an invalid RetrieVe SELECT statement.

priyadarshikunal wrote:the requirement is to check if it is not number.

No it isn't. Read the original post again.

If you're prepared to use a BASIC Transformer stage or server job, date handling there can handle BC dates correctly out-of-the-box. I'm not aware of any environment variable that allows negative years to be handled in parallel jobs. Perhaps you could extract the date components (year, month, day) s...