DSXchange

XML input stage: Under stage->transformation Settings->selected repetition element required Input->XMLsource->gave filename and selected URL/Filepath -->columns--->gave filename with varchar (no) an length 255 output->transformation Settings->selected repetition element required ---> columns -gave a...

Hello, I am trying to parse an XML document using External source--->XML_input---->Sequentialfile Gave all the properties in the stages and I see no warnings or errors but the output looks different. Input is <ENTITY>172</ENTITY> <ACCOUNT>0000000006196</ACCOUNT> <TRACK>0</TRACK> <USER_CD>1101</USER_...

Yes, we can write a subquery and feed it to the main query for the table_name information I am looking for but the issue is the table_name is not a straight field which can be pulled from the sub query. I did pull it from an other table and did some transformations for that value, now that value is ...

Thank you Andy! Yes it is the same Database.Please find below the sample structure table_name (comes from Table1) Table1--------------->Table2(select field1, field2 from table_name ) is the query where the table_name should be taken from the Table1 table. Please suggest how to store that value and p...

Hello,

can anyone let me know if I can use zOS file stage to read IMS, VSAM and other datasets directly from Mainframes?

If they can be read..are there any common issues which may be seen during reading?

Please suggest

Thank you!

Hello

The CDC stage can process huge amount of data. Select the key fields from base table and also the staging table.
There can be three links coming out from CDC stage inserts, updates and deletes.

Thanks!

Do I need to give this command in the before job routine of the job along with the path or where do I need to give?

I did give hexdump filename.txt in the directory of the file location and I see the data in all numbers....

So if we change the format will that change the real data?

I did ask them and they said change the format and transform the data.

Please let me know how to read this format from DS so that it looks like normal UTF-8.

Thanks again

This is just a one time transformation, so its better I will ask them to send a file which has data in it. Coming to the sample file which is a QAW file, with out viewing it in Data Stage I opened it in Notepad++ and it looked like this thresholdxp?@ NUL NUL NUL NUL CAN w which I think is ASCII form...

Thanks very much! Will use the websphere MQ connector , it is in real time stages. Does it need to be deployed through ISD or can be run just as a batch job? This is just a one time requirement so for sample file used sequential file. As given below how can I change the data from this sample file be...

Hello, Can anyone suggest me how to read IBM MQ msgs from datastage? As of now a sample file was given to see if the data appeared can be transformed in datastage. This sample file when opened by Note++ is opened in ASCII which is NUL,DC1 ...etc but when read the same file from Datastage now the dat...

Thank you! It is not possible to unmask back again...as the masking pack is irreversible. I got an idea of generating sequence number to all the records and just send the records with SSN to masking pack and after that use the two links(SSN records and Non SSN records) to funnel stage and sort based...

Thanks very much! Reverse the mapping? do you mean creating a seperate flow to the masking pack? How can the routine be created? writing an own routine? In the list of the records I need to search where ever it says SSN? As given below Below is the source sampleXXXXXXXXXXXXXX SSN: 123456789 XXXX XXX...

If there are several fields we can give functions to only fields which need masking but in our case we have only 1 field where we need to mask for only some records where ever these is SSN.

Sorry for the confusion. Below is the source sampleXXXXXXXXXXXXXX SSN: 123456789 XXXX XXXXXXXXXX XXXXXXXXXXX Sample2XXXXXXXXXXXX SSN:987654321 XXXX XXXXXXXXXX XXXXXXXXXXXXX Below is the Target sampleXXXXXXXXXXXXXX SSN: 576195198 XXXX XXXXXXXXXX XXXXXXXXXXX Sample2XXXXXXXXXXXX SSN:348231890 XXXX XXXX...