DSXchange

Hi..This is regarding the XML formating issue..You mentioned that you used the shell script to remove the line breakers..can you share that script

The application to which this xml is fed needs to be in the fomrat I mentioned..any other forms is being rejected

Hi Guys, My job prepared an xml file using output stage which looks like <SBUCode> NAV </SBUCode> <ProductPartNumber> 1646859C91 </ProductPartNumber> <ProductDescription> COVER - ASSY, POWER STEER RESERVOIR </ProductDescription> but my requirement is to get the same output as <SBUCode>NAV</SBUCode> ...

Hi All,
I have exact the same issue with grouping of XML columns mentioned above.
I see this thread has been resolved with no answer.Can you guys let me know how to proceed on this issue

Hi, I have requirement to write a XML file on to a MQ queue. Actually XML file contains timestamp value which needs to put on MQ queue I am using row generator , transformer(get value thru parameter for timestamp),XML output stage and then MQ connector. I have option of Create(under transaction) und...

Following are the log entries around the failure. Warning >>SEQ_TYPE1..JobControl (@ExecCmd_Split): Controller problem: Unhandled failure (255) encountered executing command ksh Info >>SEQ_TYPE1..JobControl (@Coordinator): Summary of sequence run 02:52:33: Sequence started (checkpointing on) 02:52:3...

Thanks Chulett for the response. Had a long production night and just got back to work. The message is from a sequence job, all the child jobs are finished okay and I do have the option "Automatically handle" enabled. I was going thru a lot of posts about your suggestion "no initial v...

Hello, The jobs in production are failing with error message Controller problem: Unhandled failure (255) encountered executing command ksh. This is not occuring daily, very random. When I rerun the jobs, they go smooth. Today I tried to dig in further and got the below message from the log. From pre...

If you want to get rid of the last 2 records then delete those line in before job subroutine or in a invocation shell (sed 'N;$!P;$!D;$d' <<inp file>> > newfile). If you are planning to handle those records then provide the exact criteria with samples

Thanks mike. My bad,it's a non root install. Looks like we messed it by trying something out of the box(non documented stuff)!

Again, I am not an expert in this section so could not debate a lot. I got the following from guide. DataStage installed by root is installed in impersonation mode with auto start enabled. During installation an administrative user is specified who is authorized to carry out day-to-day administrativ...

Hello All, This might be a dumb question in administration, but if someone can share information then that will be great. I (abc1) log into the box and sudo into sysmgr account I install Datastage(DS) as sysmgr. Remember, sysmgr is only a "sudo"Account. It doesnt have a password. DS gets i...

Aplozise for the delayed follow-up. Business has decided to strip the characters, so it was an easy job for me.

Thanks.

Hello all, As the subject says, we don't have NLS enabled and we have to handle german characters in description field. I am generating a fixed width file and the description should only be x bytes and because of this characters the o/p length is exceeding x bytes. I don't have the luxury of enablin...

I am able to get this done with seperate lookups. Would like to know if any other way I can achieve it.