DSXchange

On the other hand,
Putting in a Reject link, and a columns for the reject message I get:

"XML output document parsing failed. File Path: "

in the reject column specified. Hence is a parsing issue.

OK, I got the same problem as this post. ( a few years later) CSV -> Transformer -> XML_Output -> MQ_COnnector. I can get the XML_Output Stage to create the xml data to OS files via the output link. They look marvelous. However, the MQ connector does not recieve any rows. the name of the Output Colu...

Guys, I got a process that is running MQ realtime from IMS to DB2. My log files get really big, I would like datastage 8.5 to not record "info" level entries, but I cannot figure out how to do that. The docs I was been looking at don't seam to help. Is there a sewtting some where so that d...

I am using MQ and I have to parse the payload. I am using Import column to parse the payload, after its taken from MQ. The Payload is Pipe delimited, and strings are double quoted. Given the following input, the importColumn stage is not parseing the string propertyl "Apple"|"blue Jay...

I have a MQ job that reads MQ, parses the table name, then parses the columns for that table. I would like to only delete the msg off the MQ when the DB2 commits. delete (under transaction). THe problem I am having is that if I get a resource unavilable on DB2 Side and get a sig int, then the commit...

I do the same thing, but use it for promotion between environments istool export -archive Quickwin_jobs.dsx -domain linux50 -u username -p "password -ds ' "linux50/esa_dev/Jobs/QWin_test/*/*.*" -includ edependent -incexec' . Dev to test and to prod. I include the dependents and the ex...

Think about what the Shell is doing, "aa*1" the shell is trying to figure out what the star means, try putting a "aa\*" . I know in bash the special chars get processed if you don't put a slash in them.

If we're talking Server jobs as you've marked your post, have you tried using USERSTATUS to pass (possibly modified) values back out of the job? Yes this would appear to work, I will try it. The environment variable approach would work, but would have to be unique so jobs had their own name. Maybe ...

I would like to pass a Job Parameter from a Sequence to a DataStage Job and have the Job change the Parameter value. I have tired setting the Job Paremeter to a different value in a TXFM stage. but when my seqence calls the next Job, the Job Parameter remains the same. Hence, how do you pass by Refe...