DSXchange

Hope wrote:or can I do this in using Aggregator with out mentioning a group key?.

That way.

You could try digging up Vincent McBurney's ITToolbox blogs on DataStage, from what I recall he has a series on the history of the product. Perhaps whatever in the heck you are looking for will be there somewhere.

Please read through that information and try to put it to use. It would be best to come back with specific questions once you have had some experience with them. Depending on exactly what you need, you may be 'rejecting' records logically before they become an issue as Nick notes. Or you may need to...

You are trying to capture rejects from what - a database? Something else? Those functions aren't the kind of thing you should be using in constraints. I'd suggest you open up the online Help in Designer, go to the Index tab and type 'reject rows'. This will give you a decent overview of how rejects ...

They're... newer. And have more stuff in them.

Again, it's amazing what out there in Wiki World:

http://en.wikipedia.org/wiki/Oracle_dat ... on-numbers

I'm sure more details could be found (somewhere) on Oracle's site.

Is it really that hard to search out there and find this information yourself? For example:

http://en.wikipedia.org/wiki/Awk

Did you try searching the forums? It's all out there and I don't really see why I should type it up one more time. You'd need to decide if it was applicable to your situation or not.

Your problem is this information won't work as a constraint as these are source field names and not the link names that the constraint would use. Perhaps if you standardized on link names and could 'pre-pend' that standard name to each field name? That could get messy, however, if the constraint get...

When you say 'the target file looks like this' - what are you using to do the looking? 'View Data' in DataStage doesn't count, you need to do this from your operating system. The octal dump we've both now mentioned is one way, a hex editor or even vi can help.

Thanks for pointing out the documentation, I tried ASCII delimiter 168 in the delimiter column of the delimited flat file stage , it says its invalid .. So what exactly did you try? Hopefully not literally 'ASCII delimiter 168' but rather just 168 in the field, as long as that is the decimal value ...

Again - without specific examples I'm not sure how anyone can know whether you're on the right track or heading down the rabbit hole. You haven't shown us: * What these 'truncated' values look like * What these 'untruncated' values look like * What 'special characters' you think you are seeing Not s...

Um... examples? 'Some special characters' tells us nothing.

Do you have access to a hex editor? That would help. Or an old school od or 'octal dump' in UNIX. The -A switch will let you get hex output if you're more familiar with that - check your man page.

I'm not sure 'control characters' really are your problem but this Convert definitely is not the way to go. I can see what you are attempting to do, but this isn't the way to do it. Since you've entered them all as just characters, each one individually will be converted to an empty string - first a...

You'll need to create indexes for this, have you? Search the forums for CREATE.INDEX and BUILD.INDEX for the gory details.

Is what really something I care for? Accurate information? Of course. I see now that the Guide does indeed say "(About 30 minutes)" but in reality the answer is hard-coded in the Engine at 60 or 90 seconds, tops. Sheesh, don't take it personal - just pointing out that (regardless of where it came f...