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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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)
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.