DSXchange

asorrell wrote:You may get a ticket from the metadata police...

Thanks ArndW & Andy Sorrell.

Will there be any issues with doing Metadata Impact Analysis?

Is there any down side of not providing the lengths for the Varchar fields through out the entire job flow? We have created few jobs and removed the lengths for the Varchar fields from all the way source (Sequentail files) to the target (Datasets). We removed the lengths for the Varchar fields even ...

Please let me know, if Oracle 11g is supported with DataStage 7.5.2.

If not, any newer versions of DataStage support Oracle 11g.

Thanks in Advance.

We have requirement to specify a custom CorrelationID value for CorrelationID property on Message Header, when we write the message to MQ from DataStage.
Is this possible with DataStage 7.5.2?

Thanks in Advance.

We are trying to read MQ messages using MQ Plugin Stage in DataStage Parallel Job. We are trying to read a message, which contains a XML file. We had set the following properties in the MQ Plug in Stage: WaitTime is set - 1 (Unlimited) Message Limit is set 1 (Since we want to read one message at a t...

Hi Ernie,

The job is simple with no transformations.
We are on 7.5.2

Could you please send me the link for your blog.

Thanks in Advance.

Hi Ray,

Yes this requirement is satisfied.

Thanks

I was able to make the job work, by defining the 2 meta data columns. one with Message ID and the other as Message. I was able to read the messages. Iam still running into the following issues: Issue 1 : DS job is not able to read the message when the wait time is set to unlimited within the job. Jo...

I have entered the message into the queue using 'amqsput' command and its a pure text.
I still having the same problem.
Do i have to specify the 'Message Type' property?

I was able to write a message from DataStage to MQ. This part works fine.

Thanks in Advance.

Hi Ernie, Thanks for the response. I have tried these options: When i specify incorrect Queue name, i get the 2035 errors. When i specify timeout value and the correct Queue name, job writes some garbage output to the file, may be that is result of timeout. But i don't see the actual message being w...

We are building a sample prototype to test reading MQ messages and processing through DS. We have installed MQ 6 on the DataStage Server (7.5.2). Setup the Queues. Cretead a test job to read the message from MQ. Job is able to connect to the Queue manager, but not able to read the message, its waiti...

Hi
Is MQ plugin is part of standard DS software or do we need to purchase seperate license for 7.5.2?

Thx

Suren

Hi All, We are running into an issue where the Pivot is not sending the output properly when the derivation has more columns. Pivot stage transposes records upto 7 columns properly and after that it ignores rest of the data. We have around 19 columns that need to be transposed into records. Pivot wo...

I do not get anything when I search on "CLOB" or "LOB". Are you getting results when you search on "CLOB" or "LOB"

Has anyone loaded data into Oracle CLOB columns using DataStage? Using Dynamic Relational Stage (DRS) in a Parallel Job, when I try to load data into an Oracle table containing CLOB column, it is loading only 1 byte into the column.
Please let me know if you have any information on this.