DSXchange

I'm getting a signal error when loading an xml to the MQ. It is a huge xml used all the APT_variable and in the xml output stage.. i'm getting the below error: operator terminated abnormally: received signal SIGABRT If anyone faced the similar problem please provide your experience and solutions.. T...

I'm getting a strange error which i dint meet earlier in any of my projects. I tried to combine two sets of huge volume of datasets holding a different xml connected by a same ID. When combine those two into one datasets, i'm getting an transcoding error (XEF) message. Can any one please help if you...

It can be done through the standard utility routine 'UtilityHashLookup' under sdk option.

Thanks Ernie. I tried the character code and hex code earlier and resulting unsuccessful. As i told in the earlier posts i'm dynamically generating the XML's.When i pass the hex code to the appropriate db2 column. I'm getting the the hex code as &hexcode. Can you have some other way to parse it ...

Thanks for inputs guys, Yes Arnd. these are legal strings from DB2. I could query through the tables and looked the data, its looking fine. Craig, NLS are installed properly and by defaul it has been mapped to UTF 8. But The next step when i do for generating xml dynamically, it results in an extra ...

Sorry for the late reply. Thanks for the input guys.

Sorry for the late reply. Thanks for the input guys.

Thanks Ernie. I have loaded the xml file successfully into the MQ.
But I just want to know how to purge the messages in MQ one at a time.

Thank you very much. but one more question can we check a mixed format like aphabets and numerals:

eg:
[A-Z][0-9]
A9B
4BU
4B5

We can write the matches in a static way but the question is can we achieve it through dynamically.

Thanks in advance

Dear all,

This question may be simple or known to all.
Can we have any function to check the format of the string like for eg

'XX XXX' * return true

aa abcd - returns true
aaa dcd - returns false
aaaaaaaaaaa - returns false

Please post me if you know any functions for this one.

Hi everyone, This question may be quite simple. :wink: I dont know whether there is any ruleset which will standardize for vehicle make or vehicle model. If not, could i create a customer ruleset which will standardize the list of vehicle names and their model. Can you say how to create custom rules...

Ernie, I have the same issue, have to update a lot of XML files to an MQ. Can you tell the what is the way to write the data in MQ.

[quote="ray.wurlod"]Everything in server jobs is a string. The fact that you can use these strings to load into databases is a bonus - but that's precisely what you are doing with manually-entered SQL after all. Thus ...[/quote] Just for an effective straight forward question: How to conve...

[quote="chulett"][i]StringToDate()[/i] is a [b]PX[/b] function so no good in a Server job. For that you'll probably need the IConv/OConv tag team but that can depend on what you mean by "date". What's your target? ...[/quote] Craig, I want to extract any format of date such as (t...

Hi when i try to convert a string to date from a transformer stage it shows the derivation as red in color even when i used the same format as IBM indicated StringToDate(string,Format). Can any one tell the solution.