purge queue

put messages to a queue

get messages from a queue

browse messages in the queue

runmqsc

mqrc

rfhutil

jmsadmin

Client

Bindings

No default. The transport has to be defined explicitly

None of the above

Queue Not available

Security Error

Queue Manager Not Available

2085 is not a valid return code

TEXT

STRING

MQSTR

MQSTRING

dmpmqaut

runmqsc

setmqaut

defmqaut

runmqsc

jmsadmin

MQ Explorer

rfhutil

Queue Manger Not available

Queue Not Available

Security Error

Invalid options specified in a call to connect to queue manager

Sender

Receiver

Sender/Receiver pair

SVRCONN

Cleanup resources from a failed datastage job

Start and stop datastage engine.

Provide read access to Datastage configuration file.

Report datastage client connections.

APT_NO_JOBMON

APT_PERFORMANCE_DATA

APT_PM_SHOW_PIDS

APT_RECORD_COUNTS

Call the DSLoggFatal function from a stage variable derivation

Call the DSStopJob function from a stage or column derivation

Use the SETENV function to set the environmental variable APT_PM_KILL_NOWAIT

Create a dummy output link with a constraint that tests for the condition to abort on; set the 'Abort After rows' property to 1

Datastaage function

Datastage Macro

A system variable

a link variable

Auto detect by XML stage.

Check the "Repetition Element Required" box on the output link tab.

Set the key property for the column on the output link to 'Yes'

Set the 'Nullable' property for the column on the output link to 'Yes'

Create a task with single oracle enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle enterprise stage.

Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an oracle enterprise stage.

Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an oracle enterprise stage.

Environmental variable APT_AUTO_TRANSPORT_SIZE

Environmental variable APT_SORT_MEMORY_SIZE

Sort stage Restrict memory usage property

Sort stage Max memory limit property

Unique sort keys must be set to True

Allow Duplicates must be set to False

Sort Group must include the sort key values

Stable sort must be set to true

Writes the job’s OSH script to the job log

Automatically sets all environmental variables

Graceful shutdown of datastage engine

Provides a snapshot of a job’s performance

Set APT_JOB_REPORT to True

Set APT_DUMP_SCORE to True

Set APT_MONITOR_SIZE to true

Set APT_RECORD_COUNTS to true

Entire

Round Robin

Random

Hash

Modulus