How to automate import/export process in version 7.5.2

srik9683 · Post by **srik9683** » Tue Sep 01, 2009 4:00 pm

Hi guys,

I am new to datastage and I am trying to learn how to automate import/export jobs from the server. can somebody please let me know how to start with this.

server is installed on AIX 5.3.

and also is there a way to export using dsjob command from the server.

your help is much appreciated.

thank you
srik

kiran259 · Post by **kiran259** » Tue Sep 01, 2009 10:33 pm

"Search" will help you. :D

chulett · Post by **chulett** » Tue Sep 01, 2009 10:46 pm

Before version 8.x the import/export process is all client based. There's some export capacity on the Server side, but the expectation is that is all handled on the client. The two basic commands are dscmdexport.exe and dsexport.exe off the top of my head - the former is for all jobs in a project while the latter is for a single job. As noted, a search here will turn up all manner of discussion on the subject. You can also go to Kim Duke's website and download a batch script from his Tips section that will automate the export of all projects on a server, quite handy to have that already built.

I believe it is 8.1 that finally brings full import/export capabilities to the server side with the "istool" executable. Again, a search here will turn up those conversations.

Also, the syntax for 'dsjob' is fully documented in the Command Line Interface section of either Developer's Guide pdf manuals.

srik9683 · Post by **srik9683** » Wed Sep 02, 2009 9:47 am

thanks a lot. I will try to workaround that

chulett wrote:Before version 8.x the import/export process is all client based. There's some export capacity on the Server side, but the expectation is that is all handled on the client. The two basic commands are dscmdexport.exe and dsexport.exe off the top of my head - the former is for all jobs in a project while the latter is for a single job. As noted, a search here will turn up all manner of discussion on the subject. You can also go to Kim Duke's website and download a batch script from his Tips section that will automate the export of all projects on a server, quite handy to have that already built.

I believe it is 8.1 that finally brings full import/export capabilities to the server side with the "istool" executable. Again, a search here will turn up those conversations.

Also, the syntax for 'dsjob' is fully documented in the Command Line Interface section of either Developer's Guide pdf manuals.