DSXchange

That worked ray. Thanks so much for the solution and lesson.

Thanks ray

In the Aggregation Stage
Input Tab
The partitioning tab, partitioning type = (Auto)

Hi all I'm getting duplicate groups while using the Aggregate stage and summing on an ASCII pipe delimited file. In the Aggregate Stage I have two input columns Column_1, the grouping, varchar 255, data is alpha numeric Column_2, is being summed, varchar 255, data is amount (18, 4) I have the follow...

Hi all. How can I locate and process the last file in a directory? Every day an ascii text file is push to a unix file directory. The file name is always The_File_Name_YYYYMMDD.txt., the "The_File_Name_" is always the same. As an example the directory currently has "The_File_Name_2011...

Hello Everyone.

I have a need locate all the job and stage names across a project that uses a particular sequential file. All developers have not used the metadata setup for this file.

Is there a way to list out all the jobs name and stages name that use a file?

Thanks in advance for any help.

Just the non-printable characters will work. Thanks.

As an example my text file contains a yen symbol. When I view the file in Ultra Edit the yen symbol is not displayable. When I turn the hex display on I see the hex representation of the yen symbol. There are other non-displayable data as well. So I was hoping I could write a DataStage job that woul...

Hi All Is there a way to use DataStage to scan an ASCII text file for hex values and write the values an ASCII test output file? I have an ASCII text file that contains may hex values. All the values are unknown to me. I'd like to use DataStage to collect all the hex values from the file and write t...

Yes PhilHibbs that is the goal

Thanks for your reply fmou.

I will need to do this in DataSatge, as I am working with flat files.

Thanks PhilHibbs. Not sure if I was clear. But all records belonging to a group/any group will be in a single file.

I have a set of records in a sequential file. I'd like to read that file and move the records that belong to a group to single sequential file. The grouping happens at two levels, which are sourced from two separate files. Group Level 1 Key005 Group Level 2 FkeyAAA Detail file Key001, FkeyAAA, Data....

Thank you chulett. I'll post my findings.

I have a DB2 table that has a column defined as data type XML and nullable. I am using the ODBC stage to select and append into the table. I have done an Import Table Definition ==> ODBC Table Definition and the column has a data type of LongVarBinary I have done an Import Table Definition ==> Plug-...

chulett, forgot to answer your Filter suggestion. There are no filters on.
Looks like DS_PXDEBUG = 1 is the answer viewtopic.php?t=131128&highlight=_debug