DSXchange

ArndW wrote:Craig - I would be surprised if the installation is an NLS one from the type of post (the language quoted was German)

Didn't mean to imply NLS had to be installed, I've played games with characterset conversions on systems without NLS just by setting NLS_LANG and occassionally LC_CTYPE as well.

Thru setting NLS_LANG but first - what is your source and target? What is the characterset of your target? Just need to be certain that it will actually support the characters in question.

8) is a smiley, this is one of those times when you need to check the 'Disable Smilies in this post' option. You can go back and edit your posts for that.

I'm curious why you are using a UNC path to the file when it allegedly resides locally on your DataStage server? You certain it's not on a mapped drive? That would only be used for 'network' resources, hence the question. And probably your issue.

I believe so, yes. The MKS Toolkit ships with the Enterprise Edition for Windows and brings UNIX capabilities to the table. Pretty cool stuff.

The UV stage doesn't require a DSN, just a VOC record and an index, neither of which require admin privs and they can all be automated in a job. But if you want to take a different route, I appreciate that and good luck with it.

Unless they have the MKSToolkit installed.

OK, here's a free bit of Forum Etiquette advice: Please don't quote everything every time you post. Use the 'Reply with Quote' option when it is appropriate so people know what you are replying to if there might be any confusion, but most of the time that's not needed and there's a perfectly loverly...

Rather than continue to go round and round, why don't we wait for DSbox61 to come back and clear things up before we throw out any more 'solutions'?

Still at a loss why you'd need to "recognize the relationship among them" or even what that means. If you've written the chunks out into separate txt files as you've noted, can you not simply cat them together in the same order? :? cat root_element childA childB childC childD closing_eleme...

Hmmm... still clear as mud. Can you provide examples of what it looks like before, then split and then the desired output? Hopefully that will help light the

So, what is it that you want to do, sort or group? You can't "group" records and keep all of the detail, the end result will be fewer record so some sort of "calculation" (sum,max,last,etc) needs to be done on the non-grouped fields. :? Seems like you may just want to sort your o...

While the first statement is true about 'duplicates', the second is not necessarily true and the third is false. Asking for a scenario when one cannot use a hashed file is a little broad, like asking when one couldn't use a screwdriver. Use the tool that's appropriate for the task, whether it's a sc...

Time to mark this as Resolved using the button at the top of the page, it seems.

Check the OpenSeq syntax in the BASIC manual, you need to add the 'else' path to create it when the open fails. A search here would turn up examples as well.