Page 1 of 1

dumping dataset to a file

Posted: Thu Feb 16, 2012 9:04 pm
by just4u_sharath
Hello,
I want to move data from dataset to a sequential file using a command. I tired the following command i got an error.
orchadmin dump updateims21.ds update.txt
-ksh: orchadmin: not found [No such file or directory]

Thanks

Re: dumping dataset to a file

Posted: Thu Feb 16, 2012 9:13 pm
by SURA
Path may not be set properly might be the reason. Go to pxengine/bin and from there execute the same. It will work.

DS User

Re: dumping dataset to a file

Posted: Thu Feb 16, 2012 9:27 pm
by qt_ky
SURA wrote:It will work.
It will work that way only if the current directory "." is included in PATH.

It was mentioned here recently that dumping datasets via command line may not give the results you expect due to special/nonprintable characters, etc., so be careful in testing the results.

Re: dumping dataset to a file

Posted: Thu Feb 16, 2012 9:51 pm
by reachmexyz
SURA wrote:Path may not be set properly might be the reason. Go to pxengine/bin and from there execute the same. It will work.

DS User
I did try following command

/opt/IBM/Engine/InformationServer/Server/PXEngine/bin>orchadmin dump /di/data/proj/inbound/updateims21.ds /di/data/proj/inbound/1.txt

It did not return any error but i did not get any output into the file.

Posted: Thu Feb 16, 2012 9:54 pm
by qt_ky
Did it dump the data set to your screen? If you want to redirect output from a command into a file, you have to put > in front of the file: echo ABC >file.txt

Posted: Thu Feb 16, 2012 10:04 pm
by reachmexyz
qt_ky wrote:Did it dump the data set to your screen? If you want to redirect output from a command into a file, you have to put > in front of the file: echo ABC >file.txt
I used > in the command still no data was dumped in to output file
/opt/IBM/Engine/InformationServer/Server/PXEngine/bin>orchadmin dump /di/data/proj/inbound/updateims21.ds > /di/data/proj/inbound/update.txt

Posted: Thu Feb 16, 2012 11:49 pm
by kandyshandy
do you have permission to execite orchadmin command?