DSXchange

Did you enable the Write output to a file option on the Stage/Options tab? Did you put your desired pathname in the File path field there?

When I transcribed the previous syntax I was using into the post I left off the trailing slash, which is why it could no longer be parsed. So now both are working and here are some timing tests for anyone interested: sed -e 's/$/|M/' *.xxx >> fileout 55 sec avg cat *.xxx | sed -e 's/$/|M/' >> fileo...

Any file that starts with a 'dot' is a hidden file in UNIX. When you do a 'list' of the contents of a directory, you have to include the -a switch on the command line to see 'all' content, at the very least:


Then you'll see the file.

There are three files in a dynamic hashed file's directory that you'll need to copy:

.Type30
DATA.30
OVER.30

Ok. Is that exactly the same name you used when creating the hashed file? From your O/S can you verify if that directory exists and is accessable?

You may not get an error but there should be diagnostic Info messages in the log - post them.

Suggest you try and see. Too many variables specific to your environment for anyone to give a definitive answer. I doubt it, though. Perhaps a chat with your DBA is in order?

If your post has been resolved, please mark it as such. Thanks!

Which part? When you repeat the installation, it should go into 'Maintenance Mode' rather than just install everything. You'll have to remind me what all of the options are but pretty sure you'll need to do the step which basically says 'Repeat the installation'.

AFAIK, only an SA can change the 'hard limit' for something like that. Seeing as how the soft limit is only 2 bytes below that, raising it via ulimit won't be possible until the hard limit is raised.

Welcome aboard! :D You do know that your version will not run PX jobs, yes? Develop yes, run no - that takes 7.5x2 or 8.x. And that XP is not supported as a Server platform? That being said, search the forums for your error message. Also, there's never just one lovely little line from a PX compile -...

The 'authorization code' for Server, which is separate from PX. You'll need to repeat the installation.

Not sure. Try: insert into PSADMEP.PS_Z_RCN_ERR_TBL values('#DSJobStartTimestamp#','#DSJobName#',' ','N');

It's not really for merging files. It serves three basic purposes: 1) Allows you to get filenames from a directory one by one. 2) Allows you to get filename and complete file content one by one. 3) Allows you to write multiple files to a directory. Most of the time it is used for #2 feeding data to ...

I'm not suggest you have to do it. 'Get' as in 'make arrangements with whomever manages the server' to have the DSN created.