DSXchange

My XML input looks like below - with E1BPMEPOTEXTHEADER repeating, but one of them will have a different TEXT_ID value and different TEXT_LINE value. <E1BPMEPOTEXTHEADER> <PO_NUMBER>ABCDEFG</PO_NUMBER> <TEXT_ID>F12</TEXT_ID> <NEW_ELEMENT></NEW_ELEMENT> <TEXT_LINE>37806884</TEXT_LINE> </E1BPMEPOTEXTH...

JRodriguez wrote:Madog,

We are at version 8.1, we have three Queue Managers on the same server where DataStage is installed with no issues

Cool bananas!! :D thats the confirmation I was looking for...


thanks all.

does anybody know if 8.1 can handle multiple queue managers on the same server which DataStage is installed onto? The input tab on the MQSeries Stage dialog box has a field for Queue Manager, so this to me suggests, yes it can. But word in the office - is that its a limitation of DataStage, and that...

sorry if this is a naive question - but where exactly is the license file located? i can access details via the web Information Server console, but I'd like to view the actual xml files. thanks.

thank you for the responses.

in the end - it turned out to be permissions issues. I had to give access to files from /IBM/InformationServer/ downwards....

just noticed.. between my eg 1 and eg 2 - i put in different port numbers in my previous post. dont worry.. when trying this, i was putting in the correct and SAME port numbers.

i couldnt get this to work.. maybe a syntax thing. vkumar, could u kindly please post an example of how you called the dsjob?

Looks like the dsjob command options have changed in 8.1 from 8.01
Previously, you could specifiy the user / password to run as, but now it seems those options are gone. Can anybody confirm? Or let me know how to run the command specifying a different user? thanks.

Thanks for all the help guys - I've figured it out.

the ksh93 was screwing things up. I've gotten it to use ksh - and all seems fine now.

Hi. I got a shell script in AIX which uses mailx. Within the body of the email, i use "\r" and "\n" to create a new line. When i call the script from AIX - the email generated is correctly formatted. When the script is run from DataStage - all i get is a bunch of literal "\r...

Has there been a resolution to this problem? I am also experiencing the same issue. I would like to delete rows based on some condition before I load into the table. I am trying ot use the Oracle 'Open command' but am not successful. I can use a PL/SQL block to do this, or execute a defined stored p...

Well, the warning message threshold is set to 'No Limit'

I was wondering is it because Lookup can only handle parallel process, not sequential...?

Hi all, For those DS experts out there, I am facing an interesting issue which you may have come across. although i am assuming you may think this is a typical SIGSEGV problem (which i am not too sure about). Job Background: Input: a dataset (sequential execution mode) reference dataset (sequential ...

Hi Ray, with the Esc character, when i go into the sequential file stage properties -> Format -> field delimiter, tried to enter ESC key, it just escaped the property screen? what am i suppose to do with that. and to specify this as 027 (its ASCII code, in decimal), what options under the format of ...

Hi all, I am trying to create a sequential file using ^] (Control ]) as a field delimiter. however this results in 2 characters (^ and ]) when i check the output unix file. what i did was, 1st test, simply putting ^ and ] together as a string in the field delimiter under sequential file properties. ...