DSXchange

Hi All,

Our requirement has changed we are no longer looking for response from MQ.

I have got lot of help for the mentioned topic and had a good hands on experience with XML Transformations and MQConnector.

I am marking this topic as resolved. :D

Thanks

Hi Ernie, Thanks for the quick reply :) I went through the MQConnector documentation and tried reading from the Queue with testdata. I was able to retrieve the data to Peak Stage. I couldn't find anything related to reading a response from the Queue and then then read the data from the queue based o...

Hi Samrat, I hope the concept of Partial Schema's might come handy. I haven't tried a hand on this. You can have a look at the below link from IBM. https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/r_deeref_Partial_Schemas.html Please update us ...

Are you doing a select on the Table or on the View? Are you doing any joins or exists conditions with in the query? If so try, to achieve the joining capability in datastage rather than on SQL. Try increasing the Max Heap Size on the database.

Hi Abhinav, Sorry for the delayed reply. Thanks for sharing the Links. It was really helpful. I have generated the XML files and pass then on the queue and it was successful. But I am unable to figure out how to read the response from the queue and decrypt the XML File. Hi Craig, I Couldn't reply to...

Hi All, I am new to XML's and MQConnector's in Datastage. We have a library of XML services. Our requirement is to map relational data into an XML structure, place it on a queue, then read the response from the queue and decode the received XML message. I went through IBM Documentation regarding the...

Hi Prasoon,

Do you mean the partitions as the no.of nodes used in the configuration file?

Hi All,

Could you please explain me about the System Variables

1. @NUMPARTITIONS
2. @PARTITIONNUM

and want to know their behavior while generating a sequence number?

I tried something like below:

dsexport /h=host /u=user /p=password project_name /xml /job=job_name job_name.xml

But hard luck

Hi,

Is there any command line argument, where we can export the datastage job as XML instead of DSx or ISX format.

I have 100's of jobs that need to be exported.

Thanks,

Could you let us know whether the key column is "Nullable" ?

Hi Harry, You can use the "CompactWhiteSpace(%string%)" function in the transformer and pass the column as input to it. Example: CompactWhiteSpace(DSLink.Designation) if the data is in format : Input string: "THIS IS TEST STRING" Desired out put: "THIS IS TEST STRING"

Hi Ray, Actually i created the test job, in the output sequential file, i have given the path name incorrectly where the file gets created. SO my job aborted with errors and there are Fatal Errors: Example: seq_output,0: Unable to open XXX/XXX/XXX.txt: No such file or directory. buffer(0),1: Fatal E...

Yes there are Fatal Error in the datastage log but i am getting the status code as 2.

I ran the command directly on the server and the status is again 2 for Fatal Errors.

Hi All,

Thanks a lot for the information.

Actually, we have our linux servers in cluster. So we just disabled the Grid tab and added the second server node details in configuration details and worked fine.

Thanks,
Mohsin Khan