DSXchange

Hi , Regarding the above topic i had splitted the query and i ran now.Now i am getting the following warning. Sybase Server warning 11055 (severity 16) from stored procedure 'sp_tables', line 191: Query contains an illegal outer-join request. Any suggestions would be great. Thanks in advance. Regard...

Hi Folks, I am using sybase stage as source and sequential file as target. I am inserting one user defined query in the sybase stage. When executing the job, I am getting the following error. Failure during execution of operator logic. Fatal: Attempt to get target table info from sp_tables failed. B...

Hi Folks,

Can anybody suggest me,What are the advantages of parallel jobs when compared with other ETL tools like Informatica,Abinitio,Dataintegrator.

Thanks in advance,
Sateesh.M

Hi Craig, I am not able to put my topic properly infront of you.If i troubled u guys i am sorry. 1.As you said we are reading the file into job using Folder stage and then we are writing into Queue. 2.In the next job we are reading messages from Queue and loading it into Database(Staging Table). 3.N...

yes i am writnig a condition that if the message topic is null it should get rejected.

Sateesh.M

Hi Craig, It doesn't work fine means. When we are parsing xml message INPUT: " <?xml version="1.0" ?> <MfsEnv> <Mfsh> <Psc> <Command>Publish</Command> <Topic> MFS/EXPENSEACCRUAL/adjustment </Topic> <QName>CUST.EXPENSE.ADJ.REQ.Q</QName> <QMgrName>WAS_MQ_server1</QMgrName> i should get ...

Hi Craig, Thanks for your reply.I am posting it clearly now. As of now we are inserting messages with the topic tag name as <Topic>MFS/EXPENSEACCRUAL/ADJUSTMENT</Topic>.But even if the incoming xml with topic tag as<Topic>MFS/EXPENSEACCRUAL/adjustment</Topic> I should get it as <Topic>MFS/EXPENSEACC...

Hi Friends, If i use this if NOT(isNull(Ln_Mfs_Exp_msg.MsgTopic)) Then UpCase(Ereplace(Ln_Mfs_Exp_msg.MsgTopic,' ',"")) Else "" I am getting th topic tag as MFS/EXPENSEACCRUAL/ADJUSTMENT. I have to process the XML message even when the content of the Topic tag is either upper cas...

Thanks for your replies.

Now i got it that.If we have seen the replies after 5,6 days.We can see view topics since last visit.I think there we can find replies.

Hi Friends,

I posted a topic(Sub:converting MQHRF2 format to MQSTR)on jul17th.
I didnot find any replies for this post.If anybody replied and if i have seen it later.how can i see those replies.

Sateesh.M

Hi Folks, We are using MQAdaptor stage to read and write messages into Queue.In developement our jobs are able to read messages when we are sending messages in MQSTR format.But in UAT and PROD the client sending messages(MQHRF2) are not able to read by our jobs.I need to convert MQHRF2 format to MQS...

Divya,

Please find some tips w3schools+org in google.

sateesh.M

Hi Folks, We are using MQAdaptor stage to read and write messages into Queue.In developement our jobs are able to read messages when we are sending messages in MQSTR format.But in UAT and PROD the client sending messages are not able to read by our jobs.I need to convert MQHRF2 format to MQSTR forma...

Hi, We are using Mqdaptor for reading messages from Queue.If we are sending messages into queue my ETL jobs are able to read those messages.But the client sending messages is not able to reda by ETL jobs bcause the client sending in different format. For removing those junkdata i created routine.Tha...

Hi Craig,

Thanks for your quick reply now we came to know that is because the user which we are using to run perlscript is don't have permissions.

That's why we got this error.

Thanks,
Sateesh.M