FTP and job parameters

Post by **admin** » Mon Sep 29, 2003 8:45 am

Hi All

I have an input file which has one column. The column contains file names
that need to be FTPd from a remote box. How does one pass the filename to
the FTP parameter Remote File Name? I thought of reading the source,
setting a job parameter to be the same as the source filename and then using
this in the FTP stage. However, I cannot find a function I can use to do
this. Any ideas anyone?

Thanks

Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
Cell +27 83 380 2335

Post by **admin** » Mon Sep 29, 2003 9:18 am

Hi Mark,

I dont know what you want in all details. But I guess, that you want to do
it all in one job, that is not possible. A parameter can never be change
during the job.

What you can do is to write for example two jobs. The first reads the
seq-file and starts the second with your parameters.

Can for example be done with the batch-language.

Wolfgang

-----Original Message-----
From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za]
Sent: Monday, September 29, 2003 10:45 AM
To: DataStage User Group (E-mail 2)
Subject: FTP and job parameters

Hi All

I have an input file which has one column. The column contains file names
that need to be FTPd from a remote box. How does one pass the filename to
the FTP parameter Remote File Name? I thought of reading the source,
setting a job parameter to be the same as the source filename and then using
this in the FTP stage. However, I cannot find a function I can use to do
this. Any ideas anyone?

Thanks

Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
Cell +27 83 380 2335

Post by **admin** » Mon Sep 29, 2003 9:48 am

Thanks Wolfgang. I wanted to avoid the batch language option if it was
possible. Will have to do it the hard way. I wonder if version 7 will allow
one to change a parameter while the job is running. Anyone know if its
going to be available?

Thanks.

-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Monday, September 29, 2003 11:19 AM
To: datastage-users@oliver.com
Subject: RE: FTP and job parameters

Hi Mark,

I dont know what you want in all details. But I guess, that you want to do
it all in one job, that is not possible. A parameter can never be change
during the job.

What you can do is to write for example two jobs. The first reads the
seq-file and starts the second with your parameters.

Can for example be done with the batch-language.

Wolfgang

-----Original Message-----
From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za]
Sent: Monday, September 29, 2003 10:45 AM
To: DataStage User Group (E-mail 2)
Subject: FTP and job parameters

Hi All

I have an input file which has one column. The column contains file names
that need to be FTPd from a remote box. How does one pass the filename to
the FTP parameter Remote File Name? I thought of reading the source,
setting a job parameter to be the same as the source filename and then using
this in the FTP stage. However, I cannot find a function I can use to do
this. Any ideas anyone?

Thanks

Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
Cell +27 83 380 2335

Post by **admin** » Mon Sep 29, 2003 12:57 pm

I dont believe, that with version 7 there will be a change concerning
changing parameters while job is running. Maybe, that you can solve your
problem with the jobsequencer without writting any code.

But reading a seq-file and feeding some loops with the input is not a heavy
task. Some click-click and your batch-job is ready.

Wolfgang

-----Original Message-----
From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za]
Sent: Monday, September 29, 2003 11:48 AM
To: datastage-users@oliver.com
Subject: RE: FTP and job parameters

Thanks Wolfgang. I wanted to avoid the batch language option if it was
possible. Will have to do it the hard way. I wonder if version 7 will allow
one to change a parameter while the job is running. Anyone know if its
going to be available?

Thanks.

-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Monday, September 29, 2003 11:19 AM
To: datastage-users@oliver.com
Subject: RE: FTP and job parameters

Hi Mark,

I dont know what you want in all details. But I guess, that you want to do
it all in one job, that is not possible. A parameter can never be change
during the job.

What you can do is to write for example two jobs. The first reads the
seq-file and starts the second with your parameters.

Can for example be done with the batch-language.

Wolfgang

-----Original Message-----
From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za]
Sent: Monday, September 29, 2003 10:45 AM
To: DataStage User Group (E-mail 2)
Subject: FTP and job parameters

Hi All

I have an input file which has one column. The column contains file names
that need to be FTPd from a remote box. How does one pass the filename to
the FTP parameter Remote File Name? I thought of reading the source,
setting a job parameter to be the same as the source filename and then using
this in the FTP stage. However, I cannot find a function I can use to do
this. Any ideas anyone?

Thanks

Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
Cell +27 83 380 2335