DSXchange

I tried the FIELD function, but the @VM was not recognized as the delimiter so it did not parse the data.

The entire source column was written to the first target column.

Any ideas?

Thanks.

Once I have the hashed file populated and read it as a reference lookup, how do I take a record out of the hash file like... StudentID Grade 1 A@vmB@vmC 2 D@vmD and populate a single row with multiple columns: StudentID Grade1 Grade2 Grade3 1 A B C 2 D D

We are planning the process to convert from DataStage on Windows to DataStage on Linux.

Is there an easy way to do this without having to reload all table definitions and recreate the database stages?

I was able to fix it by including the display value in the metadata. Thanks.

I am unable to FTP (receive) a fixed width file using the FTP stage. The connection works fine. The error I am receiving is

Internal error: 'buffer_to_row' failed.


Any insight would be greatly appreciated.

Is it possible to receive a cursor variable as the result set from one stored procedure and use it as input into another stored procedure to actually break it down into the appropriate columns? Also, does DS understand row types as a result set back from a stored procedure. If anyone has any info re...

Exactly...for this pass!

Ultimately, I will be creating headers/footers using the key data to break on.

Let me know if you need more... I have multiple files that contain a different set of data for claims processing. The files are: Claims Pharmacy Prescriber Patient Insurance etc... The first 86 characters are the key they have in common... Client, Group, Plan, Patient, Health Service ID, Health Serv...

Do you want to see layout examples or actual data?

I have numerous segmented files that share a common key but beyond that are defined differently.

How can I merge these files and sort on the common key in the process.

Any help would be greatly appreciated.