 Related Questions To pass parameters to the job we can use Unix shell program. But I do not know exactly how to do that.Plz let me know detail steps to pass the parameter through shell script How to call a Stored procedure which is in SQL Server database in Datastage job? I want to pass job parameters as one of the SP parameters and for remaining SP parameters , I want to use default values. Also I want to perform transformation on the result set of SP. Read Answers (1) | Asked by : udaykiran In datastage how we can do for this type or requirement:The sales data will be extracted in 2 flat files.Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif suppose we run first time means the job names are Read Answers (1) | Asked by : sreedhar k 1.What is the use of parameters in datastage job?2.What is the difference between datastage 6 and datasttage 7.0?3.Whta is unit testing, system testing and integration testing?4.seheduling the jobs in Datastage?5.What is the difference between datastage 7.1 and datasttage 7.5?6.How to do error handling in datastage?7.how do you remove duplicates in a flatfile? Read Answers (4) | Asked by : srinivas Are there any ways of passing parameters or values across parallel jobs in a sequencer? Scenario: Job 'A' would execute and based on the result of the Job we want either Job 'B' or Job 'C' to execute. Hence the result of Job 'A' would determine the sequence of operation. Read Answers (3) | Asked by : Manraj What is the use of $PROJDEF Variable and how can we use this variable to pass the parameters from parameter files ? Read Answers (1) | Asked by : Premnath I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc). Theoratically I understood. But practically unable to implement it. Can Latest Answer : For example I create a parameter for my hashfile folder like it :
Name: $pHashdir, type:string,def.value:†C:DataStageInput DATAHashâ€
and when I use my hash file in path file name i use just this parameter $pHashdir
and when you run ... Latest Answer : Yes,You can pass the parameters.There is a options called "Usage Variables" in job sequence.Here you can declare ur parameters.These will be available in entire job sequence. ... How to pass input parameters using UNIX Shell script to DataStage Director? How to create Job Sequence? Latest Answer : You can create job sequencer using designer client, if you click create new job like server or px job in Datastage, it will get open window there you can find to create the job sequencer.Job sequencer uses to run multiple jobs either server or px based ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
2