DSXchange

pravin1581 wrote:Is there any limitation to the size of the file that we can attach.

Probably, but it's a limit in your email server.

The version 8 MQ stages allow you to specify a local or remote queue manager.

MQ Intercommunication is configured within MQ Series, from one queue manager to another.

If you've never used it you need to create SDKSequences. Run any of the SDK key management routines from its test grid as the easy way to do so.

Other than that you're right - if the sequence name does not exist in SDKSequences you will need an INSERT statement - normal SQL rules.

None whatsoever. They give you pen and (blank) paper when you're taking the test. There is only an overall time limit. You can return to questions you skipped on the first run through (good exam technique - answer the ones you know first). You can even mark the ones you want to return to. And you ca...

DSBINARY is a structure in a DSX export file.

Please be less hasty in leaping to conclusions.

You should be able to access them using an ODBC driver for MS Access.

None of the SQL Catalog tables can be manipulated with SQL. You need VERIFY.SQL to repair the schema information. How will you remove the entries for the project from XMETA (the common repository for IIS)?

Is something else invoking the SDK key management routine that exclusively locks its record in SDKSequences for the duration of the job run?

Please post the exact error, using Copy and Paste. What you have provided does not make sense - it is missing at the very least some vital punctuation.

The thread has strayed from its original topic. DataStage does NOT generate an executable file. DataStage parallel jobs generate an osh script. When the job is run, a new osh script (called the "score") is written, taking into account the currently selected configuration. The score is executed withi...

There is nothing directly available within a DataStage stage. You can code using the ODBC API - in which case the function is SQLTables() to retrieve a list of tables (optionally filtering with a wildcard name).

Job number 81660 ?!!! Are you sure you're not hitting some operating system limit here, such as number of subdirectories in a directory?

If you know how to look RT_CONFIGnnn contains far more than "names...and nothing else". It's just that there are no metadata for retrieving the contents of these records. Structure of these records is, however, described in RT_CONFIG.H. The importer looks after creation of RT_BPnnn.O, RT_CONFIGnnn, ...

Can you please execute the following query from Administrator client's command window?

Cluster Key Change reports that a new group has commenced, whether or not the data are sorted (though, obviously, they must be grouped).

Key Change reports that a new value of the sort key has been encountered.