DSXchange

Hello MT,

Yes - "but is the specified length in DataStage the same as in DB2?"

I adjusted the database table column as suggested and received the same warning. I even made column a len of 100 an still the same message.

Hello MT, thanks for the reply

Some columns are as small as 1 and as large as 80. The database code set is UTF-8.

I understand what you wrote. I would still expect the implicit conversion to account for this.

Based on what you wrote, this message will never go away. True?

Hello chulett,

Thank you for the reply. I am unable to get the RAM size.

The admin was able to get this done by moving the dsx file to the server, then used the command line command to import.

This tells me that there are not enough resources on the client to handle the file size.

Thanks again.

Hello ArndW and thank you for the reply. The client is on W7. My admin is not sure if the UNIX box and/or file system supports files larger than 2Gb. He did note that the resources are low in my environment. So this failure could be due to the DS client using lots of memory to open this dsx. If ther...

Hello All, Is there a dsx file size limitation when using the import tool in DS 9.1? I have a project export dsx, which has design and executables. The file size is 2,270,986. I'm trying to pick 5 jobs at import time but DataStage will not open this file. The import gets as far as "Loading Stag...

Thanks Meave. This was useful. It took awhile, to review all the jobs and make the change.

Hello All, we are seeing strange behavior with the Remove Duplicate stage, when looking for the latest record in a group where there is more than two records that match a key, i.e., the second record in a list of three is being kept by RD. See data below. The job looks like this: - Seq ==> Copy ==> ...

That worked Ray. Thanks so much.

How can I output one master record to many update records? When I join a single master record to two update records using the join stage with a left outer join I get two records in the output file. The master data joined with the same update record. I tried the merge stage and got the same results. ...

Hello chulett.

I have abandoned the Aggregator and Group by solution and went back to the sort and key option, which seems to be working.

Thanks so much.

Sorry. Yes that would be correct.

thanks chulett Empl_rec, Daily_Change_Ver_Num, Changed Data 03456, 1, Empl_Status 03456, 3, Empl_Status, Leave_of_Absone_Date, New_Salary 03456, 2, Empl_Status , Leave_of_Absence_Date 45633, 1, New_Address 45633, 2, New_Address, Empl_Status There may be multiple changes to a record between runes. Da...

Thank you for the reply chulett.

Col_3 is not available on the mapping tab. Is this normal? Is there a way to map it in the Aggregator? Col_3 is different across the records in the group.

Hello all, I have a set of records that I am sorting and creating a change key. I want to select the record that has the highest value in a different column (Col_2 below). See example below. Is there a way to select that record in the group without having to resort? Thanks in advance for any help. I...

Thank you all.

I thought through what bart12872 and pavi wrote and redesigned the approach to the shared container.

I am treating the container as a job where I'm using change key in sorts, LastRowInGroup(), and control break logic.