DSXchange

You've seen what I imagine the only impact would be - anything that uses a relative path to any of the contents of the bin directory will be prone to failure. What all those might be I can't say and don't have access to anything to check. If you've had that line there before go ahead and simply add ...

Could you answer my first question above, please? If the answer is yes, can you post it? And then perhaps the exact text of the error message so we can try to match one to the other.

01 is the record level, fields below that start with 02 as noted. And "FD" is short for "File Descriptor", the COBOL file metadata. Were you given one to import into the CFF stage? Have you worked with COBOL files and nomenclature before? Seems like the answer is no and you may w...

This.

jwiles wrote:Import the string as-is into a decimal and then divide by 100.

StringToDecimal(field)/100

This question really can't be answered without more information from you. We have no idea what your job design looks like, what your source and target are, nor what your transformation / business rules are. For all we know you are trimming the string and thus making the two values equal...

Actually, there is more information you can provide. First off, what is your job design? What database are we talking about here? What type of procedure did you declare it to be in the stage - Source, Target or Transform? What have you tried so far to capture the return value and what hasn't worked ...

It also depends on how much time has passed... if you edited it 'quickly' it won't show it as edited.

Your char field will always have a length of 2, that's the way CHAR works. It won't have "5" in it, it will have "5 " in it and even if you trim them, any trailing spaces will be automagically added back in. Again, all part of the nature of a CHAR field.

From what I recall, the Connector stages only come with the 8.x release, not 7.x and I'm not sure they were ever retro-fitted into Server jobs. Meaning I believe they are PX only stages but that may have changed in the later releases, something I don't have access to. As for the 'work around' we've ...

You can exit the loop early if you need to, simply branch from inside the loop to a Terminator (if you want things to stop abruptly) or branch to a stage past the End Loop stage if you just want to sneak out early.

What patch?

We have a similar situation - two related tables that really need to be loaded at the same time as they share a common generated key between them. Sure, we can treat it as a 'parent / child' load and load the first table and stash the information needed for the second, following child load but the p...

:!: vamsi.4a6 - Please stop quoting everything every time you post here, it creates unnecessary work for the moderator who (being an anal soul) has to constantly come along and clean up after you. There is a perfectly lovely functional Reply to topic button, use that instead of Reply with quote... u...

Glad we could help.

I think your other team members are mistaken. Contact your official support provider to see what your options are in the release that you have. Like I've said, I honestly don't recall any kind of official LOB support in the 7.x release and always had to 'work around' that back in the day. Any possib...