DSXchange

For future planning purposes, we'd like to know whether it's possible to have a client workstation with both Hawk and version 7.5 installed. I'm hoping that users who have worked with the beta version might be able to tell me whether using the Multi-Client manager (or some other method) allows you t...

Thanks for your help everyone!

you can call an parallel routine that you can write in C that does a simple efficient translation from EBCDIC to ASCII

So does this mean that there is no functionality within the parallel toolset to perform this type of conversion after the data has been read from a file?

In my particular case, using a CFF stage is not the most suitable option.

Any suggestions as to how I can perform the conversion within a transformer?

Thanks,

Peter

Hi All,

I'd like to convert a string from EBCDIC to ASCII within a Transformer stage. If I were developing this code in Server Edition, I'd simply use the ASCII() function. How can I do the same thing in Parallel Edition?

Thanks!

Peter

I already tried it, but this was the error I received during compilation... Error in output column derivation expression for column field1 in link LnkInboundData. Invalid conversion requested from a raw to a string. The actual syntax for the derivation is LnkInboundData.field1[4,7] The message seems...

Quick question here... If I want to extract part of a varchar field, I use the following syntax: field_name[4,7] In this case, the 7 characters beginning at the fourth position of file_name will be returned. How can I accomplish the same thing with a VarBinary data type? (i.e. return 7 bytes of the ...

Thanks folks! You were absolutely correct - DataTypePicComp did exactly what I needed.

You can use the SDK functions that convert binary COBOL datatypes to do this. Do you know what sort of binary data you have? We seem to be thinking along similar lines. As a matter of fact, I've used the DataTypePicComp function to successfully read packed data, and I was hoping that there would be...

Hi Folks, I've searched the forum about this, and although there are lots of mentions of binary data conversions, none appears to capture my specific case. I am reading a stream of EBCDIC data as VarBinary. I know that at a pre-defined position and length (i.e. REC_IN[11,4]), there is data that woul...

Thanks for the response!

Will releasing the locks on a job that he has open cause any problems other than losing his code changes?

I realize that when a job is incorrectly locked, I can use the Cleanup Resources utility to release the locks. However... A developer is on vacation and has left a job open in Designer. We need to make changes to this job today. Can I safely use Cleanup Resources to release the locks he's got on thi...

Thanks for the quick responses. Kim - you mentioned that.. You can export a job that is broken and will not import. Does this mean that I can safely attempt to import a dsx export that was taken from a corrupt project? In other words, if there is corruption in the dsx export, can I assume that only ...

A couple of quick questions... 1. If a project has become corrupt, but I'm still able to export jobs from a specific folder without any error messages, can those jobs be safely imported to a new project or could the export also contain some corruption? 2. Is there a utility that can determine whethe...

Thanks Ray!