DSXchange

Hello kcbland and ray.wurlod:

Thank you very much. Was able to right click on the derivation and call the routine successfully.

Still working on the filter in the transformer so as to filter out tables that have no rows.

Thank you once again.

Regards,
MJ

Hello all: I extract a message from a MQ Message queue and parse it into a sequential file. The variable in the sequential file in which I want the whole message to come into is set to longVarChar and length is set to 999999 and display to 999999. However when I try to view the output column I am ab...

Hello All: Need guidance and advice on a couple of things: A. I have a routine that needs to be called from transformer. Went to the properties of transformer. There is Before / after routine. Need to select before sub-routine. Need help from here on how to call this routine. Or if there is a better...

Hello Ray: Thank you very much for your advice. I have one more question. Who should create the message queue definition...? Is it the perosn who created the message queues or me who is only extracting the data from the messages. Would appreciate if you could reply at your earliest convenience. Once...

Hello: Having froblems in MQ series stage. Would appreciate some help. INPUT Data in the Message: 11|CONT|1|16|511|PNR|OAS|I2|OAS|20020617|2004-08-10|P2|75|IL|20020613|004.25||02|01|CONT_COM|1|10|51136|PNR|BSC|001|OAS|SP3Q3|2004-08-10|84|20020617|11| Message queue format is as follows: CONTRACT(tabl...

Thanks Amos and Rich, appreciate your advice and for taking the time to reply...!

Regards,
MJ

Hello: I am studying for DataStage - DS Server, Parallel Extender and Osh Shell scripting. ver 6.x/7.x I find this forum just too cool.....! This is a great place to increase ones learning curve besides books (for beginners like me). :) Q - where do I find information on loading data on multiple nod...