DSXchange

Hi. I am getting a permission denied. Here is the message: Could not create/truncate table file "/workarea/DataStage/DataSets/lookuptable.20081105.ndqynaa": Permission denied It seems kind of obvious, but is this because I need permission to write to this particular directory? Thanks in ad...

Hi. I am writing with a similar issue using the lookup stage. I am getting a permission denied. Here is the message: Could not create/truncate table file "/workarea/DataStage/DataSets/lookuptable.20081105.ndqynaa": Permission denied It seems kind of obvious now, but is this because I need ...

Thanks Ernie...that's a start! We tried what you said and created a column with the name PutApplName and populated the column with the value 'datastage', it created the column and populated it when we created the xml file. But once it put it on the queue, it still said 'osh'. When naming the column,...

Is it possible to change the values n the MQ Header Columns when using the MQ Connector Stage? It seems that they are greyed out and I am getting bad data in this field? The specific column I am concerned about is the putApplName column, the value is 'osh', but it is putting a hexidecimal 0x0 in the...

Hi. I appreciate the response .To answer your question, the MQ Header, apparently is it is putting garbage data (a null) in the application name section. Any ideas?

ArndW wrote:Which header - the MQ header(s) or your message? What is wrong with a null? What is the issue that you are seeing? ...

Hi. We are using the MQ Connector Stage to put a record on a queue and the parser after the queue is having an issue. Apparently, there is a null before the header of the message??? Has anyone experienced this issue?

Is it possible to invoke a COBOL component from DataStage, pass data to it as input and get return data back? I guess importing the copybook would be one of the first steps, but what stage would be used? Am I posting this to the wrong forum? If so, sorry, could someone direct me to which forum I sho...

Hi. Using the XML output stage, I want to output the documents to one file and I was able to do this using the correct output mode, but it only generates one header for all of the documents. Is there a way to repeat the header for each new xml document? Also, when generating the xml - see below - th...

Yes, i'll try that, that probably will work, now that I think of it! Thanks! what is actually returned from the Service? blanks? nulls? Are you going directly from the WSTransformer into an rdbms stage? Could you implement a Transformer and use a constraint to prevent the rows from going thru if the...

Hi! I am making a call to a web service from DataStage and in the web service (java) I want to populate the returning object and then it will return that object to DataStage and output that row of data to a results file. Sometimes the object doesn't get populated and that is fine, but I don't want i...

Hi. Thanks for the response. I think we fixed that problem because we did run into it. We set DATASTAGE_JVM -> jre/bin/jv9m and another one, so I think that is what you are referring to. OK, and perhaps i'll try to see what happens from a server job, like you said. Thanks again for your input. Nicol...

We have successfully imported the WSDL and filled out the Web Service Information in the WS Transformer Stage correctly. I posted a message asking if anyone has seen the same error message (APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 231). Does anyone know what these types of er...

I haven't received any responses to this yet. Let me ask another question. For those who have successfully called a webservice via DataStage, do you know if if there is certain security, etc that needs to be set up in order for the web service to be called? Is there a way to test the connectivity to...

Hi there! I'm creating a job to validate our data. If a certain column on the left table has a value of 'Y' then it should have a row in the right table. So i'm trying to do a merge, but what I really need to know are the rows that do NOT merge. What is the best way to do that? I tried creating anot...

Hi Craig. By any chance, do you have the wsdl you got from combining the two? That would be extremely helpful. I'm receiving the same error message. Thanks, Nicole Thanks Ernie. Interesting stuff, was blissfully unaware of the debates. :wink: I must have missed Ray's edification request. I'll try to...