TO export job through unix

gssr · Post by **gssr** » Thu Dec 24, 2009 5:54 am

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,

srinivas.g · Post by **srinivas.g** » Thu Dec 24, 2009 7:07 am

dsimport,dsexport (job level)

chulett · Post by **chulett** » Thu Dec 24, 2009 9:06 am

What 7.x version?

Akumar1 · Post by **Akumar1** » Thu Dec 24, 2009 9:16 am

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

gssr · Post by **gssr** » Sun Dec 27, 2009 11:25 pm

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

srinivas.g · Post by **srinivas.g** » Mon Dec 28, 2009 6:29 am

for catageory wise export through unix is not possible.
U need export job by job.

gssr · Post by **gssr** » Mon Dec 28, 2009 6:52 am

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..!!

chulett · Post by **chulett** » Mon Dec 28, 2009 7:41 am

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.

Akumar1 · Post by **Akumar1** » Mon Dec 28, 2009 8:09 am

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

chulett · Post by **chulett** » Mon Dec 28, 2009 8:13 am

The only category option is via the GUI, not the command line.

gssr · Post by **gssr** » Mon Dec 28, 2009 11:30 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Dec 28, 2009 11:52 pm

/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.

gssr · Post by **gssr** » Tue Dec 29, 2009 12:10 am

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,

chulett · Post by **chulett** » Tue Dec 29, 2009 12:17 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 29, 2009 12:19 am

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.