orchadmin dump problem

abc123 · Post by **abc123** » Sat Jun 23, 2007 11:42 pm

"Orchadmin dump" copies a datset to a sequential file. However, the problem is, by default, it puts a space after every field. Is there any way to adoid that? I would like to copy a dataset to a sequential file as is, that is, the length of all columns should be exactly the same in the dataset as in the sequential file.

ArndW · Post by **ArndW** » Sun Jun 24, 2007 1:34 am

The default separator for the dump option of orchadmin is space, if you wish another character such as the semicolon, you need to add -delim ';'

abc123 · Post by **abc123** » Sun Jun 24, 2007 1:42 am

I don't want anything after a field. How do I specify that?

abc123 · Post by **abc123** » Sun Jun 24, 2007 2:50 am

It has to be:

-delim ''

Interestingly, "orchadmin dump -help" does not talk anything about -delim. ArndW, where did you find it?

ArndW · Post by **ArndW** » Sun Jun 24, 2007 3:57 am

I can't recall, but I'm sure it is in the documentation somewhere. I don't have any pdf's available on this pc, but if it isn't in the advanced programmer's guide then it might be found in the original orchestrate documentation.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 24, 2007 4:47 am

Try the Orchestrate Administration manual.

lstsaur · Post by **lstsaur** » Sun Jun 24, 2007 1:41 pm

Page 173 of AdminInstall.pdf
-delim 'string' Use the string 'string' as a delimiter on top-level fields. Other possible values for this are: nl (newline), tab, and space. The default is a space character.
However, why don't you try Peek stage since this command is almost identical to the peek operator in a data flow.