DSXchange

"just having a job waiting endlessly for a message to arrive. "

How do we do that that in DataStage verion 8 , server edition??

That is the question?

Thanks,
Chakradhar

Well, i am working with Server Edition, Not Enterprise edition , we don't have MQ Connectors.

What Options for monitoring the Queue for new messages can be used ??

Rgds,
Chakradhar

Using a shell script is not a good plan. there is no need. Use the MQ Stage. Why use a shell script? Did you need this to be realtime? No problem. Read the documentation. Thanks for the thought. i have couple of question added to the above. 1. Which are options to be used in MQ stage to read the me...

Next simple solution is write a Unix Script , you can make 2 files like header and detail files and process them separetely. It is quite simple compared to dataStage job.

Rgds,
Chakradhar.

MQ Series Queue needs to invoke DatStage Stage Job on arrival on any message in the Queue.

Is it good plan to have shell script to be used?

Any body any thoughts??

Rgds,

Chakradhar.

I have faced similar issue before. We resolved using the Stage varibles in Transformation stage.
It will loop till we have next occurance of Header ID.

Or you have Transformer Stage filter thru constraints check for header ID occurance.

Try any of the solution.

Rgds,
Chakradhar.

i have simple workarounds.. -> Have job to split the source data into multiple quatums. -> You can write to a flat file and then write a SQLLOADER job. this would aviod huge transaction files and if your job fails while loading then re-execute the SQLLOADER job. that would save your time of re-proce...

you can write DatStage routines to capture the log and write the information in to DB Table or flat file or you can get RT_LOGS file.

Rgds,
Chakra

Meena is right, that is good information link. But I would like to add to that. here is the example where we can use it thru DataStage. Assume: If you have Store Chain and you have store A and Store B in different locations. A customer walks in store A and makes 25$ purchases and he pays only 10$ at...

Use flat file to store this information ( User name , password) and write a simple job to read the flat file and populate the variables .

Thess variables can be used in entire session. So we can execute the primary job thru sequencer .

Rgds,
Chakra

Which is best method to invoke a datastage, from MQ Series Queue when queue has got message?

Rgds,
Chakradhar.

Dude, I would recommend simple Export and Import into new project. Here are the steps. 1. Open DataStage Manager with old project. 2. use export menu and export all with DSX format give a path like (Desktop). 3. Above steps will produce a huge file with "filename.dsx" on the desktop. Open ...

Dude, I would recommend simple Export and Import into new project. Here are the steps. 1. Open DataStage Manager with old project. 2. use export menu and export all with DSX format give a path like (Desktop). 3. Above steps will produce a huge file with "filename.dsx" on the desktop. Open ...