parameter

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 3:56 pm

NOt in the sequence job. In your px job.
Go to the job properties and convert both of these parameters to string type. Atleast for the date.

kishoreramachandran · Post by **kishoreramachandran** » Mon Jan 22, 2007 4:34 pm

when i define it as a string the job compiles well but it not executing as it should be.the result tables are blank, no records.

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 5:18 pm

Did you remove the quotes from the Date?

kishoreramachandran · Post by **kishoreramachandran** » Mon Jan 22, 2007 9:48 pm

no, the dates have got double quotes, thats the way it was created when i wrote it to a sequential file.

kishoreramachandran · Post by **kishoreramachandran** » Mon Jan 22, 2007 9:56 pm

actually in the exec command stage i have given cat and then the full path name, but am i supposed to give cat or type.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 22, 2007 10:23 pm

cat if the server is on UNIX, type if the server is on Windows (you can also use cat on Windows if the DataStage version is 7.5x2, in which it will be executed by MKS Toolkit).

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 10:41 pm

kishoreramachandran wrote:no, the dates have got double quotes, thats the way it was created when i wrote it to a sequential file.

Dont create it with the quotes then. The quotes are the culprit. Or change your sql. Create the sequential file with quote character 000 to get rid of quote character.

kishoreramachandran · Post by **kishoreramachandran** » Tue Jan 23, 2007 8:37 am

perfect now it is working.
thanks for the service.
now when I create a sequential file how will I eliminate the " that the system is putting.
In the job sequence if I have 3 job activity then does it mean I should have 3 command stage before those activitiies.( 1 in front of each)

DSguru2B · Post by **DSguru2B** » Tue Jan 23, 2007 8:45 am

kishoreramachandran wrote:now when I create a sequential file how will I eliminate the " that the system is putting.

Read my previous post again to see how to populate date without the quotes. The system does not do anything. Your job does that.
I suggest have all your parameters in a file, read them as i have suggested and pass it to one Master Job Activity. This job activity will have your sequence jobs. This way all you need is one Execute Command Stage going into single job activity. That job activity will have all your sequence and so on.
That is one way to do it. There are others. Search for more design info.

kishoreramachandran · Tue Jan 23, 2007 12:45 pm

sequential file is fine now.
I have to pass 1 parameter which will be a user keyin value to the job sequence. If I define that in the job activity of the job then how will I associate that with the properties in the sequence job.

DSguru2B · Post by **DSguru2B** » Tue Jan 23, 2007 12:48 pm

That job activity will pass it down the chain. You will feed the parameter to the a single job activity as "Master". It will set the parameter for that Master. Inside Master you will have, say five job activities. You will choose Master's job prameter and feed it to where ever you want to in the subsequent job activities.

kishoreramachandran · Post by **kishoreramachandran** » Tue Jan 23, 2007 1:16 pm

how can i put many jobs ina job activity, it allos me to put only 1 job . what you mean by master

DSguru2B · Post by **DSguru2B** » Tue Jan 23, 2007 1:20 pm

You can have a sequence inside a sequence inside a sequence. The top level sequence is what i referred to as Master. In your drop down, you can also choose sequence jobs.