Page 1 of 2
TO export job through unix
Posted: Thu Dec 24, 2009 5:54 am
by gssr
Hi,
Do anyone have any idea of exporting and impoting jobs or awhole project through commands in Unix OS
DS server - AIX 5.4
Thanks in advance,
Posted: Thu Dec 24, 2009 7:07 am
by srinivas.g
dsimport,dsexport (job level)
Posted: Thu Dec 24, 2009 9:06 am
by chulett
What 7.x version?
Posted: Thu Dec 24, 2009 9:16 am
by Akumar1
dsimport.exe /H=<hostname> /U=<user> /P=<password> <project> <path>\job.dsx
dsexport.exe /H=<hostname> /U=<user> /P=<password> /JOB=<job> <project> <path>\job.dsx
Posted: Sun Dec 27, 2009 11:25 pm
by gssr
chulett wrote:What 7.x version? ...
Yes, V7.5.2 Px
Akumar,
I want to export a specific catagory folder that contains a set of 25 jobs. Can i do it with single command or else i have to export every job with a seperate command ?
Thanks in advance
Posted: Mon Dec 28, 2009 6:29 am
by srinivas.g
for catageory wise export through unix is not possible.
U need export job by job.
Posted: Mon Dec 28, 2009 6:52 am
by gssr
Akumar1 wrote:dsimport.exe /H=<hostname> /U=<user> /P=<password> <project> <path>\job.dsx
dsexport.exe /H=<hostname> /U=<user> /P=<password> /JOB=<job> <project> <path>\job.dsx
Do i have to execute this command in home directory?
I logged into the unixbox AIX through the user/password of that project,
Can anyone help me in this, i was new to UNIX..!!
Posted: Mon Dec 28, 2009 7:41 am
by chulett
Technically, you can issue the command from anywhere but probably easiest from $DSHOME/bin for you. And make sure you put a "./" in front of the command.
Posted: Mon Dec 28, 2009 8:09 am
by Akumar1
srinivas.g wrote:for catageory wise export through unix is not possible.
U need export job by job.
Not sure , but I think it's possible, there are some optional [option] to export category wise.
DS experts can you please add input to it?
Regards,
Akumar
Posted: Mon Dec 28, 2009 8:13 am
by chulett
The only category option is via the GUI, not the command line.
Posted: Mon Dec 28, 2009 11:30 pm
by gssr
Thankyou all for your thoughts,
I tried to execute the below code
Code: Select all
/dsexport.exe /H=dstest /U=tuser /P=dstest /JOB=Testjob1 ETL_TEST /home/tuser/job.dsx
where dstest is the server
tuser - > user name
dstest - > Password
Testjob1 - > name of the job to be exported
ETL_TEST - > Project in which the job resides
/home/tuser/job.dsx - > The path where the dsx file is to be stored.
but it throws me some error that /dsexport.exe does not exists
Did i miss anything?
Correct me if i was wrong..
Thanks all
Posted: Mon Dec 28, 2009 11:52 pm
by ray.wurlod
/dsexport.exe almost certainly does not exist. You are telling UNIX to look for a file called dsexport.exe in the root file system, and it's almost certainly not located there!
I suspect what you meant to type is ./dsexport.exe but, even then, I am concerned about the ".exe" suffix. This is really unusual for a UNIX executable.
Posted: Tue Dec 29, 2009 12:10 am
by gssr
Sorry Ray,
i am not able to read your full content,
Do i need to check the root directory?
Actually ,i executed the command in the home dir,
Code: Select all
tuser@dstest:/home/tuser>/dsexport.exe /H=dstest /U=tuser /P=dstest /JOB=Testjob1 ETL_TEST /home/tuser/job.dsx
Thanks,
Posted: Tue Dec 29, 2009 12:17 am
by chulett
Do you understand what that first slash means? I suspect not.
cd to $DSHOME/bin and then issue your ./dsexport from there. There are no .exe files on UNIX so do not include that.
Posted: Tue Dec 29, 2009 12:19 am
by ray.wurlod
gssr wrote: i am not able to read your full content
By now, with well over 100 posts to your name, you should at least have some inkling of the benefits of premium membership. It's not that expensive - less than 30c (Rs12) per day.