Hello,
Is there any Osh command to export the DataSet into a file ?
The Dataset is on the production box and I need that dataset in Dev. We cannot create a temporary job to move the data from Dataset to File in production.
Please let me know or point me to any previous posting for the same. (I have searched and found no postings for this)
Osh Command to export DataSet to a File
Moderators: chulett, rschirm, roy
Code: Select all
orchadmin dump -delim ';' YOURDATASETNAME.DS > YOUR_FLAT_FILENAME.DAT
Is it that simple ? Don't we need to set the configuration file and all of the other necessary things ? I have tried it and following is the command I have issued:
orchadmin dump -delim ';' hdw_prevday_R1Cards_mly_iu.ds > /home/pfint2/hdw_prevday_R1Cards_mly_iu_20101221.DAT
and following is the error it came back with:
exec(): 0509-036 Cannot load program orchadmin because of the following errors:
0509-150 Dependent module liborchgeneralaix3.so could not be loaded.
0509-022 Cannot load module liborchgeneralaix3.so.
0509-026 System error: A file or directory in the path name does not exist.
Any suggestions !
orchadmin dump -delim ';' hdw_prevday_R1Cards_mly_iu.ds > /home/pfint2/hdw_prevday_R1Cards_mly_iu_20101221.DAT
and following is the error it came back with:
exec(): 0509-036 Cannot load program orchadmin because of the following errors:
0509-150 Dependent module liborchgeneralaix3.so could not be loaded.
0509-022 Cannot load module liborchgeneralaix3.so.
0509-026 System error: A file or directory in the path name does not exist.
Any suggestions !
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
Maybe something to do with permissions , are you able to run osh ? Does your user id ( unix) have read access to those folders? Also check your library paths LIBPATH, LD_LIBRARY_PATH etc) add $APT_ORCHHOME/bin to your $PATH and $APT_ORCHHOME/lib to library path variable).
If it set correctly in teh project - it only means datastage/dsadmin will be able to run parallel jobs , not necessarily when you login to unix with a different user id..
If it set correctly in teh project - it only means datastage/dsadmin will be able to run parallel jobs , not necessarily when you login to unix with a different user id..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: