DSXchange

^@ is not really binary data. ^@ is ASCII NUL character, or Char(0), which is the default APT_STRING_PADCHAR setting. Your strings are padded with this character because of that setting. Change the setting to 0x20 or simply a space character. You could explicitly get Trim() to remove that character ...

What columns are on the input link of the RemDups stage, and which of these are marked as keys for the purpose of removing duplicates? What columns are on the output link, and how are these mapped from the input link (look on the Mapping tab of the output link)? Are the data partitioned and sorted o...

"Modica" would be the plural, however plurality does not enter the argument.

Yes, it's work. It's not difficult work, if you're systematic about it, even though it is tedious. And you do need to schedule time to do it. But, if you do it well, you only ever need to do it once (per project). Not sure about whether AllowCRLF as the right property. Test this. Create a job with U...

What Vincent means is: export edit the export file (search and replace) import You can do the same with line terminator characters, provided you export with default values of properties included. ExecDOS to ExecSH could similarly be searched and replaced, but you ought to do this manually so that yo...

Try putting a Copy stage between the two Connector stages and/or disabling operator combination.

Purely curious, can you ask them why they set the speed low? It doesn't save electricity or anything like that. Seems to me a strange decision to make.

Most System Administrators - certainly all the ones I've trained over the years - keep records of what patches (and software) have been installed, when and why.

My advice is not even to think about moving them with DataStage directly. Move them with FTP or some other transfer utility. DataStage is an extraction, transformation and loading tool - what transformation are you likely - or even able - to do on picture files?

How do you determine the exit status in the before/after subroutine?

What happens if you call the transform function from the before/after subroutine?

What error message do you get when the query "failed"? Just "it failed" does not help anyone to diagnose it. Have you tried SELECT branch_code, branch_surrogate_code FROM branch_pointer WHERE branch_code = '? ' UNION ALL SELECT office_code, office_surrogate_code FROM office_pointer WHERE office_code...

If the job is really still running, compilation will be prevented with a "job may be being monitored" message.

Can any one please provide the routine for this. That's the kind of thing consultants charge money to do. I still don't believe that "we have to split the dates and premium amount based on the no of premiums" is a sufficient specification. If you had the adverb "equally" in there somewhere it would...

But surely anyone with a modicum of sense takes a backup before upgrading! DataStage or any other software.