DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Thu Dec 13, 2001 9:40 pm Reply with quote    Back to top    

This is a topic for an orphaned message.
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Thu Dec 13, 2001 9:40 pm Reply with quote    Back to top    

Yes, no problem.

In the SQL, refer to job parameters using the syntax #ParameterName#

Note that this is effectively textual substitution, so if you are comparing with a string value for example, you will need something like:

Where column = ‘#Parameter#’

(note the quotes).


You can use this in both the user defined query or in the filter for a generated query.

-----Original Message-----
From: Choppie Pieterse [mailto:choppie.pieterse@tmb.co.za]
Sent: Thursday, 13 December 2001 10:40 PM
To: datastage-users@oliver.com
Subject: Paramaters

Hi There

We are runnning DS ver 4.2

I want to pass some paramaters from a batch to the sql in my oci stage. The batch must be scheduled in the evenings and run with a default paramater value. When we run the batch manually - it must prompt for the paramaters first.

Is this possible??

Thanks
Theo


Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 13, 2004 2:48 pm Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 13, 2004 3:20 pm Reply with quote    Back to top    

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


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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 13, 2004 4:10 pm Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 17, 2004 2:25 pm Reply with quote    Back to top    

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


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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 17, 2004 2:30 pm Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours