DSXchange

Hi Everyone. How to concatinate different columns in transformer stage? I have 10 columns in the input of which 9 are char datatype and one is decimal. My reuqirement is to concatinate all the 10 fileds to one field use the field as key to merge. what i have done is created a new filed ABC of dataty...

Hi Everyone, I have opened a PMR with IBM and they noticed that datastage cannot support more than about 200MB per record. My requirement is to create the xml file with only one row for all the repeating elements. In this case as iam getting 1.35 million rows i assume the size of one row would excee...

Hi,

I tried by setting APT_PHYSICAL_DATASET_BLOCK_SIZE to more than 597169415 but i got the warning as INVALID environment specification for APT_PHYSICAL_DATASET_BLOCK_SIZE;
the valid range is 8192 to 268435456; setting the block size to 131072.

Thanks

Hello Everyone,

Any inputs?

Hi,

Thanks for the inputs.. It worked fine.

Iam marking this thread as resolved.

Hi, Thanks for your response. But,I couldnt get what you meant "It will happen automatically". Here is my scenario. Character Escaped Value & ---------- & < ----------- < > ----------- > " ----------- " The requirement is.. if the source data contains the character values...

Hi Everyone, Iam using DB2 API stage to read the data from DB2 Mainframe and creating xml files using xml output stage. I have a requirement to handle XML special characters in our data. There are few special characters that need to be escaped in the XML files. Character Escaped Value & -- &...

Hi Everyone, Iam extracting data from Mainframe DB2 using the DB2 plug-in stage and writing it into a dataset. I am doing simple conversions such as concatenation,chanding the data format.The job is aborting with the below error: APT_CombinedOperatorController,0:***glibc detected***malloc():memory c...

Hi, My sequence job looks like J1-->J2-->J3-->J4. I have requirement to skip J1 if we are doing huge load, but we still need it in the job. we are executing all the sequences through the shell script. Could any one suggest the ways to skip the job J1 based on an parameters to the seq?? Thanks in Adv...

Hi Everyone, I have one job which reads the xml transactions(responses) from MQ and dumps into a sequential file. The next job reads from sequential file with format options as ( Record delimter string =</TCRMService>\n ,final delimeter = none) and dataype as varchat 30000. In the second job iam pul...

Hi Could any one suggest how to remove the nulls in my case..i have searched the forum but couldn't get successfull while extracting from MQ Connector stage..

Hi Ernie.

a) Its the MDM Java application

b) One XML document per MQ message

Please looking forward for your valuable suggestions.

Thanks in Advance

Hi,

The issue was resolved. For some fileds in the target sequential stage the prefix bytes property was set to 2 ( default). once we removed the property we dont see any issue.

Iam marking this thread as resolved.

Thanks for everyone

Hi, I have tried different options in the MQ Connector stage to pull the xml transaction as a single message by putting the End of the row terminator to No but unsuccesfull.So i have designed the job to pull the responses from MQ and dumps into a sequential file by putting the End of the line termni...

Hi, below are the hex values for the above one record 0000000 3030 3030 3330 3130 3033 3831 3434 7c00 0000020 0432 3138 3931 3231 3430 3032 307c 0002 0000040 3239 527c 7c7c 3033 2f31 342f 3230 3038 0000060 7c31 322f 3331 2f39 3939 397c 447c 567c 0000100 447c 597c 4163 7469 7665 0000 0000 7c32 000012...