To export jobs from command prompt DSEXPORT utility can be used. We can pass various parameters to DSEXPORT utility to configure export. Following are the parameters required while exporting jobs from command prompt:
/D - Specifies the domain where the application server configured. Usually in SMP environment this would be same as DataStage server name.
/H - Specifies the host name which would be same as DataStage server name.
/U - Specified the user name.
/P - Password for the user.
/JOB - Specifies the job which needs to be exported.
Following option can also be supplied in order to configure the export format. /XML to export into XML format. /EXEC to specify if only executable needs to exported. /APPEND to append the exported items to the existing file.
Following exmaple can help us understanding the export command:
DSEXPORT command can be executed from client machine. On the client this command can be found at \IBM\InformationServer\Clients\Classic.
While exporting the jobs we should one thing in mind that if we have any encrypted values defined in the jobs then these encrypted values can be seen as it is in the exported files. Hence we should consider this while designing jobs and should pass the values only at run time instead of storing them.
amigo, me podaras explicar de una forma mas detallada el tema de la configuración, lo que necesito es exportar solo un job, pero al ejecutar el comando se exportan todos. esta es la linea que utilizo
friend, I prune to explain in a more detailed configuration item, what I need is to export just a job, but when you run the command exports all. This is the line I use.
To export jobs from command prompt DSEXPORT utility can be used. We can pass various parameters to DSEXPORT utility to configure export. Following are the parameters required while exporting jobs from command prompt:
ReplyDelete/D - Specifies the domain where the application server configured. Usually in SMP environment this would be same as DataStage server name.
/H - Specifies the host name which would be same as DataStage server name.
/U - Specified the user name.
/P - Password for the user.
/JOB - Specifies the job which needs to be exported.
Following option can also be supplied in order to configure the export format. /XML to export into XML format. /EXEC to specify if only executable needs to exported. /APPEND to append the exported items to the existing file.
Following exmaple can help us understanding the export command:
DSEXPORT /D myserver:9080 /H myhostname /U myname /P mypsw mytest_project c:/temp/myexport.dsx
DSEXPORT command can be executed from client machine. On the client this command can be found at \IBM\InformationServer\Clients\Classic.
While exporting the jobs we should one thing in mind that if we have any encrypted values defined in the jobs then these encrypted values can be seen as it is in the exported files. Hence we should consider this while designing jobs and should pass the values only at run time instead of storing them.
amigo, me podaras explicar de una forma mas detallada el tema de la configuración, lo que necesito es exportar solo un job, pero al ejecutar el comando se exportan todos. esta es la linea que utilizo
ReplyDeleteDsExport /
friend, I prune to explain in a more detailed configuration item, what I need is to export just a job, but when you run the command exports all. This is the line I use.
ReplyDeleteDsExport /