DSXchange

ray.wurlod

Array Size = N * INT((packet size) / (row length))

where N is a small integer. Initially try it with N = 1.

ray.wurlod

Read Ernie's post again. The reject link handles conditions that can occur after a successful connection has been made, such as "queue full".

ray.wurlod

Looks like all the required ports (in particular port number 10000, which is used by APT_Communicator to communicate with processes on different nodes) may not be open on your firewall.

ray.wurlod

Integer stage variable svExample initialised to 3000.

Derive stage variable svExample as

Code: Select all

svExample + Not(Mod(@INROWNUM,5000))

Execute Transformer stage in sequential mode.

ray.wurlod

This is far more easily done using the command line tool dsjob - as you note the scope of the routine is its own project. The alternative is to go through the process of globally cataloging a routine so that it can be called from any project. This is not the preferred approach of the vendor (their p...

ray.wurlod

... then you need

Code: Select all

WHERE PREVIOUS_DATE >= '08-OCT-2013' AND FUTURE_DATE <= '09-FEB-2014'

so that the date formats coincide with what Oracle is returning.

(This is making some assumptions - see also Craig's email.)

ray.wurlod

Just to prove the format, can you please execute the query

Code: Select all

SELECT EXPIRY_DATE FROM tablename WHERE ROWNUM <= 5

so that we can see the date format?

ray.wurlod

In exactly the same way you would do it with Oracle.

Contemplate using TO_DATE() functions around your dates in the query.

ray.wurlod

They are asking about differences in the order of the columns.

Exam technique tip: Don't read anything into the question that isn't there.

ray.wurlod

Not enough information. "Get" from where, or within a DataStage job? If the source is a database table, you will need to make sure that the date picture (format) in your query matches the default used for the database, or make appropriate changes (such as conversion functions or connection...

ray.wurlod

Adding a new environment variable to dsenv should not prevent the DataStage Engine from starting. What error message(s) do you get when attempting to start the Engine? Try using Bourne shell syntax (separate setting and exporting of environment variable) in dsenv. MQSERVER=DEV.SL.QMBKRD01/TCP/'<Serv...

ray.wurlod

If this is important you need to code checking whether the queue manager is down (probably an Execute Command activity in a sequence) before you attempt to use any queue managed by that queue manager.

ray.wurlod

To clarify, insertion of tsort operators is disabled using environment variable(s) APT_NO_SORT_INSERTION or possibly APT_SORT_INSERTION_CHECK_ONLY, not directly an entry in DSParams.

Or, of course, an explicit Sort stage immediately prior to the stage that requires sorted input.

ray.wurlod

You'll need the UniVerse SQL Reference manual (downloadable from Rocket Software or from ADBK in Sweden). There's a utility for converting a hashed file to a UniVerse table - called CONVERT.SQL - it ends up executing a CREATE EXISTING TABLE statement, which basically builds all the requisite system ...

ray.wurlod

You do have backups, don't you?

Search found 53125 matches