DSXchange

I have the sequential file with the pipe delimited data as given below: aaaa| 1000|bbbb |2000| cccc|3000|dddd| 4000 And I want have the output as given below: - <statistics> - <stat> <statCode>aaaa </statCode> <statValue>1000</statValue> </stat> - <stat> <statCode>bbbb</statCode> <statValue> 2000</s...

Hi all, I need to convert the pipe delimited data to the XML format message to put/write this message in to MQ.I am able to convert the sequential file data to XML data but not in the proper order as i am expecting. I searched about this in the whole forum,and few members are already faced the same ...

Hi Ernie,

Do you mean that using MQ Series smaller footprint MQ "Client" api and license running on ETL server we don't need to install MQ Server on ETL box with DS EE 7.x.y?

Thanks,
-Aquilis

Ernie,

Thanks for your reply. Can you please elaborate on it? We are looking for some alternate solution to avoid installing MQ server on DS ETL box.

Thanks in advance.
-Aquilis

Hi All,

In our case MQ Server is installed on a separate server and managed centrally and its not possible to install the MQ Server on ETL server. Can we create a local queue manager that is managing remote queues so we can still use the remote installed server.

Thanks in advance.

-Aquilis.

Hello All,
Does anybody got any workaround for this kind of XML file generation.
If so, let me know. i am also facing same kind of problem.

Thanks in advance.

Hi ray:

when the routine was compiled and tested,that time it will throw error. And i am using oracle DB.

Hi Josh:

I think if it would have been driver license related error,this will throw license error as a part of ERRTEXT.

correct me if i am wrong.

As its connection seems successful..."Connection OK".

Its SQL status message.

But statement execution failure :
i .e "Request KO"..
DSLogInfo("Request KO ", "ExecSql")

Hi Ray,

Error message happens to be:

"Variable "CallerName" previously undefined. Empty string used."

actually we are executing 3 statements truncate,delete and update. As a runtime 'Stmt' will have the sql statements(It might be Truncate or update or delete).This Routine is invoked in the job control code,which processes the different jobs in sequence. 1. If its job1 fails .. then delete whole data...

Hi all, acording to business logic ,if its a full refresh load then i need to truncate the Table Before loading.Otherwise i need to upsert the data into the table.So for truncating the table we wrote a routine. which is as given below. Before it was working fine, but now its giving execution failure...

Hi all, Is datastage MQ plug-in connects MQ manager Residing in the different server.Actually From MQ ,we get the messsage with Source File Location and the source File Name in it.Then Datastage should read that file and process it further, But our MQ Resides in different server other than the ETL s...

Hi, We have verified all the access privileges. Except from DS we are able to add message into the queue from MQ explorer, from unix using different IDs and ID with which DS jobs are running. MQ Admin has given all the privileges on this queue. Still we are facing same issue. I think something relat...

Hi All, We are able to read message from a Websphere Message Queue using DS MQ stage. We are able to add message in MQ from perl script using dsadm user. It means dsadm is having all privileges to read and write message in the queue. We have verified this by running this perl script from before job ...

Hi,
I am able to read data from Queue but unable to add data into queue. I am getting error message "Fail to Open queue. MQ Error Reason code 2035"
Thanks,
-aquilis