DSXchange

Thanks a lot, Julio.
That is some great information.

Ken, Thank you for the direction. Julio, I am curious to know how I can achieve that with DSJOB? Can you please throw some more light on it. And our process runs through iterations...so it goes in to MQ gets a message out and creates an xml file, goes in gets one out creates an xml file. Using start...

Hi, The job basically sleeps for 5 seconds if the queue is empty. We dis discuss about the 'Stop Message'. As there are a lot of front end applications sending these messages, could not implement that. One option as per Craig is to do it through the wrapper. I am curious if there are any other viabl...

Hi, We have a wrapper script that runs a MQ job (which pulls from message queue) every five seconds. The job is kicked off fine from Autosys, when we wanted to stop the job from Autosys, it is not stopping. Basically our requirement is to run this job between 9AM and 5PM. Any suggestions please. Tha...

Changing the variable default to 2000000 and it worked. Thanks a lot for your suggestion. Here are some things to try.... Increase the APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I have had success with that when needing a larger size to support XML stages, albeit not with the MQ Connector.... Try a Server Jo...

I am using MQ Connector on DataStage 8.1 to read an xml message. I am getting this error " WebSphere_MQ_Connector_0,0: Fatal Error: Virtual data set.; output of "WebSphere_MQ_Connector_0": the record is too big to fit in a block; the length requested is: 1646578, the max block length ...

If you are talking Plug-ins...then DataStage provides you with a SAP IDoc load stage plugin. This is probably the right one for your requirement. We used this in one of our Data migration projects. Worked faily well...quite a few limitations and not enough support.

If you are talking Plug-ins...then DataStage provides you with a SAP IDoc load stage plugin. This is probably the right one for your requirement. We used this in one of our Data migration projects. Worked faily well...quite a few limitations and not enough support.

Ok, then I think you can do this. Create table definitions from the schema file and use those definitions in the buidops I/O schemas.
Let me know if I dint make any sense here.

Hi All, In buildop stage can we pass input and output schema @ runtime. Also do buildop have facility to read input and ouput schema from text file. regards Sandep Ranade -- I guess we can pass them at runtime but, you probably need to check the runtime column propogation feature. But in order to g...

Thank you. I will give it a try. I will try with transformer first.

Can you please let me know, how can I delcare an array of the reference table. Looks multi - dimensional to me.

Thanks

-- delete --

Yup,

You r right. Looks like there is a bug with the timestamp_from_string function. I am looking at the work arounds.

Thanks

Hi, I am using the StringToTimestamp function in the transformer. I am reading a char field 26 length(no scale) trying to convert into a timestamp. But the problem is for example: Input : 2005-10-14-19:45:22.666666 CHAR(26) Even after using this format timestamp_from_string(timestamp,"%yyyy-%mm...

Thanks..Ken