DSXchange

This was very helpful. Thank you again.

I have a requirement to make sure there are 3 records for each key fields in an output table regardless of how many come in from the input file. There are 3 types of records for each account. Types are ABC, DEF, GHI. The Account field is the key field. Example: Input File Layout - Account,Type,amoun...

Hello Everyone. I have a requirement to take a file which is ftp'd from the mainframe (os390) to our unix server and load it into greenplum. The job consists of : complex flat file component -----> transformer -----> GP connector. The file consists of hex, packed, and ascii data that is why it is ft...

Thank You all for your responses. This was a great help.

I have a requirement to read in a mainframe flat file, use two fields from the source record to see if a record with that key exists on the target greenplum table where the column END_EFF_DT = '9999-12-31'. If it exists, I need to update the target record and set the END_EFF_DT field to the value in...

I have a request that requires us to pull the max value of a field from a table which will be incremented and appended to the end of records which are sourced from the mainframe downstream in the sequence. Is it possible to set a user variable to the max value and use it later down the line when pro...

FranklinE, you hit the nail on the head. Switched it to big-endian and it is now translating the COMP field as expected.

Thanks Again for your help.

Thank you for your initial response FranklinE. We tried the decimaltodecimal function in the transform step and its returning the same value (-29691). We also used the "View Data" option inside the complex file element its displaying the same(-29691). Any other items that you think we shou...

Hello everyone, I am new to the forum and to Datastage. We have a requirement to pull a mainframe file over to our unix server that will be processed by Datastage and loaded into Greenplum. We successfully pulled and loaded the data into Greenplum. We are having an issue with one field where it is d...