DSXchange

snassimr,

it shows the average; taking the ratio of Wall-Clock time and CPU time used.

Sunshine,

when you use this stage with a dotted-line as a reference input to a transform stage the "reference input" logic will be used - it has a SELECT whilst the main input quite often does not. The greying out of the view data button is a function of filling out the Primary input box.

You can remove the error by doing an explicit conversion, i.e. DfloatToDecimal() or modify your incoming datatype to decimal. Which stage are you reading from?

qmbs, you really need to do some of the debugging work yourself, which is why I had stopped posting. Also, one-problem-one-thread plus, when you have a solution, post it so that others can benefit. Instead of including the generated source code (which is not going to solve the problem directly, sinc...

(even though this response comes shortly after I posted the question, we did spend most of last night trying to get an answer to this, with DBAs, DS people and SYSOPs involved) The DBA noticed that the newly created Oracle instance had UTF8 instead of the previous AL32UTF8 defined, dropped all table...

We have a simple job taking a dataset and writing it straight to a partitioned Oracle table. This job has run in the past, but yesterday the Oracle database was corrupted (due to hardward problems) and has been re-created. The grant select privileges in the docs were re-instituted but now the job ab...

I can't even run dsjob (system error) on my current PC; but I do recall having had problems getting the syntax correct. Someone else will surely come along and help. Sorry.

try using "=' as a separator, i.e. -server=datastage and so on.

Jasper,

is this a PX job or a Server Job?

qmbs,

hmmm, so what steps have you taken so far to find out what the cause might be?

Can you have someone on the host help you to view the data? I think the file has terminators (otherwise DS wouldn't have known about the short read), so you can define the whole row as a CHAR(nnn) and let DS do the EBCDIC->ASCII conversion, plus define that column attribute to be incomplete. That wi...

How did you declare your index mode in the Oracle write stage? When loading to this type of partitioned table we have $APT_ORACLE_LOAD_OPTIONS set to "OPTIONS(DIRECT=TRUE,PARALLEL=FALSE)" as per the documentation and to not have problems loading. The documentation is pretty clear on the access right...

When you have the transformer, run the job to get an abort, then do a RESET in the Director and look at what log messages show up under "from previous run".

qmbs,

You have done something wrong in the Transformer_2 - most likely one of your derivations generates a runtime error. Perhaps doing a mathematical operation on a string value? What sort of constraints or derivations do you have in that transform?

Hello Sravan, those are some pretty broad questions, so the answers will of necessity be as general: How do I extract an Excel spreadsheet from my Unix DataStage server? If the Excel spreadsheet and the server are both on Windows then you can use ODBC, these drivers are free on that platform. The OD...