DSXchange

gxhpainter

To Achieve the converstion. 1. Use ODBC Stage / DB Stge -> Transformation stage -> XML Input -> MQ Stage plugin 2. In XML Output stage, use '/' in the description. 3. Use Single row output. We can send the message with XML format as payload in MQ Queue and structure will be retained in the payload. ...

gxhpainter

Hi, Want to read the DB table single record , convert into XML format layout and post the record in MQ Queue in one job. Layout in the MQ Queue payload should look like below. <emp> <body>'john' </body> </emp> How can I do it? What are the stages the best used for the above? Rgds, Chakra

gxhpainter

Thanks for the tips. THEY WORKED!... I can now invoke DataStage Server jobs from our AS/400 ( iSeries) from within iSeries CL programs using the RUNRMTCMD. Pretty slick. we have jobs that dump data into staging tables and then need to invoke DataStage to process them and send them into another syste...

gxhpainter

I am trying to invoke a DataStage job from a windows batch file. I am passing in a parameter. I have read the skimpy notes in the Admin guide but the job will still not run. If I issue the command from a command window the command string works properly but within the windows .bat file it doesn't DSJ...

gxhpainter

thanks for the thoughts..

Infact, we have AS400 applications in production, we need to trigger DS jobs from AS400 and communication link between AS400 ( iSeries) and Linux server is a challenge.

So we have decided that moving Windows is a solution.

Rgds,
Chakradhar.

gxhpainter

Hi all I have one procedure in backend which is process data like select data from physical table insert into temp table do some verification and calculation and insert into second temp table then select * from second temp table I need to find alternate way for procedure in datastage as i m not get...

gxhpainter

Hi, We are planning to migrate DataStage Server migrate from Red Hat Linux to Windows Server. I have couple of questions in this regard. 1. Did anybody had any issues after migration from Linux to Windows? 2. When we move the existing code from DataStage linux Server to DataStage Window server, did ...

gxhpainter

You have to check the format of the data available in the Lookup set and format of the Data in source. I would suggest, try to use some other column as key coulmn and write the Amount field to sequential file and source data to the same sequential file for testing purpose. Try to look for the format...

gxhpainter

You can issue user defined query ' delete from tablename with nologging" that will do couple of things

1. It will not make log
2. It is very fast compared to normal delete.

Rgds,
Chakradhar.

gxhpainter

You can issue user defined query ' delete from tablename with nologging" that will do couple of things

1. It will not make log
2. It is very fast compared to normal delete.

Rgds,
Chakradhar.

gxhpainter

To conclude Setting at MQ Series Stage Wait Time : -1 Message Limit : 99999989 End of Data Message : 0 This settings will read the messages for ever and job will be in running state and waiting for the message to arrive. Use a Database Stage, so that message will be written in the DB as soon as it i...

gxhpainter

No , I don't want to terminate the job. I want to read message from queue and write message to DB Table. job should continue to be in running state.

Rgds,
Chakradhar.

gxhpainter

Thanks for help, I can make the job run endlessly till a message arrives. But I wanted job to run 24/ 7 and when the message arrive in the queue read the message and write to staging file and again continue running state for the next message. It goes on in loop 24 /7. What are configuration need for...

gxhpainter

Thanks Ray for the though.

Can you please get me more information on the services setup for DataStage Job.

Rgds,

Chakradhar.

gxhpainter

"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

DSXchange

Search found 28 matches

Convert DB record to XML format.

Thanks

running a datastage server job from Windows batch file

Re: DataStage Server migration from Linux to Windows Server

Re: can I transform this process in job?

DataStage Server migration from Linux to Windows Server

Check for the format.

Resolution steps and details for MQ Series Queues.

Read message and continue to wait for new message.

Setup job as Services

how do i make a job wait endlessy for a message to arrive MQ