Parameters

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Parameters

Post by admin »

This is a topic for an orphaned message.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Parameters

Post by admin »

I have been using DataStage for over a year now, but haven't messed
with using parameters much at all. I am currently using DataStage Version
6.0, on a server.

I make many changes, manually, every month. From where files get
FTP'd to (stored in a different location each month), to simply changing
what might get filled in a certain field each month in a Transformer stage.
Where is a good source of how to go about doing this easier, with
parameters, or perhaps even just a text file that i can read it. It would
save me TONS of work every month if i could just make the necessary changes
in one spot, instead of throughout my entire project.

Thanks for any info! :>


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Parameters

Post by admin »

Here's a simplified view of using parameters...

Look for a Yellow Box-like Icon on your job window that says Job
Parameters. The 2nd tab is a Parameter tab. All you do is enter all the
parameters you need to read in a source file and/or write to an output file
then on the Sequential File stage (or whatever you use) Click the arrow to
the right of where you enter the path and file name and choose "Insert Job
Parameter..." and select the parameters you need separated by / for each
subdirectory.

For Example: (The Parameter Tab)

ParameterName Prompt Type Default Value
Help Text
DirectoryName Enter Directory Name String Output
Directory where output files are sent
JobName Enter the Job Name String CustomerInfo
Enter the folder name for the job you are running
FileName1 Enter the File Name 1 String
CustomerAcctBal_2004Jan.dat Current Customer Account Balance Values
FileName2 Enter the File Name 2 String
CustomerAddress_2004Jan.dat Current Customer Address File
TestDirectory Enter the Test Directory String
/Test Use this parameter for testing otherwise leave
blank.

SequentialFile: (The # character denotes the beginning and end of the
parameter name. The / is hardcoded into the path but could also be part of
the Default Value such as is seen below for the Test parameter. If there
is a value, the result is
"Output/Test/CustomerInfo/CustomerAcctBal_2004Jan.dat" If the Value is
blank, then the result is
"Output/CustomerInfo/CustomerAcctBal_2004Jan.dat")

File:

#DirectoryName##Test#/#JobName#/#FileName1#



You should be able to change the Default Value anytime you need to change
something and not have to touch every output stage. You can add and drop
folder and file names as needed.

Good Luck! :)


Julie x 38955




Eric.Roufs@stpaul.com
Sent by: To: datastage-users@oliver.com
datastage-users-bounces cc:
@oliver.com Subject: Parameters


02/13/2004 03:48 PM
Please respond to
DataStage Users
Discussion List






I have been using DataStage for over a year now, but haven't messed
with using parameters much at all. I am currently using DataStage Version
6.0, on a server.

I make many changes, manually, every month. From where files get
FTP'd to (stored in a different location each month), to simply changing
what might get filled in a certain field each month in a Transformer stage.
Where is a good source of how to go about doing this easier, with
parameters, or perhaps even just a text file that i can read it. It would
save me TONS of work every month if i could just make the necessary changes
in one spot, instead of throughout my entire project.

Thanks for any info! :>


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users







*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Parameters

Post by admin »

Wow.
What many people do is create global parameter files.
These are parameters which you use frequently and do
not change, such as username,passwd,Source_Db,Target_DB,
Archive_Dir,Staging_dir etc.

If you are on unix, you can echo those global variables
when you pass parameters to your jobs and easily maintain
a centralized (single) set of parameters for all of your jobs.




Original Message:
-----------------
From: Eric.Roufs@stpaul.com
Date: Fri, 13 Feb 2004 14:48:21 -0600
To: datastage-users@oliver.com
Subject: Parameters


I have been using DataStage for over a year now, but haven't messed
with using parameters much at all. I am currently using DataStage Version
6.0, on a server.

I make many changes, manually, every month. From where files get
FTP'd to (stored in a different location each month), to simply changing
what might get filled in a certain field each month in a Transformer stage.
Where is a good source of how to go about doing this easier, with
parameters, or perhaps even just a text file that i can read it. It would
save me TONS of work every month if i could just make the necessary changes
in one spot, instead of throughout my entire project.

Thanks for any info! :>


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .


_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Parameters

Post by admin »

Thanks for the quick response, Julie!

This sounds helpful for 1 job, but i actually have MANY jobs. So i was
actually looking for something more "global". If i have to change the
parameters in every job, it becomes quite a monthly headache. ;>


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod




julie.voisine@hartfordl
ife.com To: DataStage Users Discussion List
Sent by:
datastage-users-bounces cc:
@oliver.com Subject: Re: Parameters


02/13/2004 03:20 PM
Please respond to
DataStage Users
Discussion List







Here's a simplified view of using parameters...

Look for a Yellow Box-like Icon on your job window that says Job
Parameters. The 2nd tab is a Parameter tab. All you do is enter all the
parameters you need to read in a source file and/or write to an output file
then on the Sequential File stage (or whatever you use) Click the arrow to
the right of where you enter the path and file name and choose "Insert Job
Parameter..." and select the parameters you need separated by / for each
subdirectory.

For Example: (The Parameter Tab)

ParameterName Prompt Type Default Value
Help Text
DirectoryName Enter Directory Name String Output
Directory where output files are sent
JobName Enter the Job Name String CustomerInfo
Enter the folder name for the job you are running
FileName1 Enter the File Name 1 String
CustomerAcctBal_2004Jan.dat Current Customer Account Balance Values
FileName2 Enter the File Name 2 String
CustomerAddress_2004Jan.dat Current Customer Address File
TestDirectory Enter the Test Directory String
/Test Use this parameter for testing otherwise leave
blank.

SequentialFile: (The # character denotes the beginning and end of the
parameter name. The / is hardcoded into the path but could also be part of
the Default Value such as is seen below for the Test parameter. If there
is a value, the result is
"Output/Test/CustomerInfo/CustomerAcctBal_2004Jan.dat" If the Value is
blank, then the result is
"Output/CustomerInfo/CustomerAcctBal_2004Jan.dat")

File:

#DirectoryName##Test#/#JobName#/#FileName1#



You should be able to change the Default Value anytime you need to change
something and not have to touch every output stage. You can add and drop
folder and file names as needed.

Good Luck! :)


Julie x 38955




Eric.Roufs@stpaul.com

Sent by: To:
datastage-users@oliver.com

datastage-users-bounces cc:

@oliver.com Subject: Parameters



02/13/2004 03:48 PM

Please respond to

DataStage Users

Discussion List







I have been using DataStage for over a year now, but haven't messed
with using parameters much at all. I am currently using DataStage Version
6.0, on a server.

I make many changes, manually, every month. From where files get
FTP'd to (stored in a different location each month), to simply changing
what might get filled in a certain field each month in a Transformer stage.
Where is a good source of how to go about doing this easier, with
parameters, or perhaps even just a text file that i can read it. It would
save me TONS of work every month if i could just make the necessary changes
in one spot, instead of throughout my entire project.

Thanks for any info! :>


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users







*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited. If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication and
destroy all copies.
*************************************************************************

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Parameters

Post by admin »

Thanks, John!

This sounds like what i'm probably looking for. I'm on Windows, not
Unix, but the same idea should work. This is kind of what i was hoping
for, but not sure how to read a text (parameter) file in and use it as "the
parameter" for that specific job. Is there an easy way to do that?


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod




"johnshot@bellatlantic.
net"


Eric
----------
"History must repeat itself because we pay such little attention to it
the first time."
- Blackie Sherrod



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .


_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked