dumping dataset to a file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

dumping dataset to a file

Post 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
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: dumping dataset to a file

Post 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
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Re: dumping dataset to a file

Post 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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Re: dumping dataset to a file

Post 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.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post 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
Choose a job you love, and you will never have to work a day in your life. - Confucius
reachmexyz
Premium Member
Premium Member
Posts: 296
Joined: Sun Nov 16, 2008 7:41 pm

Post 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
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

do you have permission to execite orchadmin command?
Kandy
_________________
Try and Try again…You will succeed atlast!!
Post Reply