DSXchange

**bump**

just bringing up .. sorry abt that

Yes. We do have CHAR fields with no values. Even if we have non-empty values, if the length of value doesnt match length specified, we are getting errors. We can safely change char to varchar .. but what about decimal fields? its also giving similar errors :? I am not sure if anybody else ran into t...

Hi there, I have a server job that reads from a sequential file and processes the data. Recently we got EE at our site and we are now trying to convert this particular job to parallel job (for performance reasons) I have saved metadata/schemaDefinition from the server job and used the same in parall...

OOOps .. sorry about that Roy.

BTW, I have worked my way through it. Just went through some of the code posted by Kim on his website and modified to suite my needs. I hope thats fine

Thanks.

Hi Ray .. thanks for the reply. I have modified DSJobReport to get start/end time of job during its last run. So I am fine with that. as for getting the list of jobs from sequence it was covered before, search for it. I did that .. went through atleast 10 pages of results :lol: .. may be I am doing ...

Hi,
I was wondering if there is a way to get a list of jobs called by given sequence?

thanks

Is DSWaitForFile before/after sub-routine an option?? This basically waits on a file in a specified location and as soon it finds the file starts processing. Again this depends upon the accessibility of the windows share from DataStage

Thank you for that clarification. You can edit your current SDKSequences file to change the KeyValues to what ever you like or you might consider creating a simple DS Job that updates the SDKSequences file to the values you want. Yeah. Thats what I have done. Just wanted to confirm that migration ca...

Hi, We have jobs that use this function to generates keys for our reference table. Recently we have installed EE that replaces our SE. During this time we exported complete project and imported back to EE. Now when we are running the jobs involving this function, we have noticed it is starting from ...

Never mind.
I got it. I wrote a routine that can be called from transformer.

thanks

Hi I am fairly new to datastage and still in learning stage. I know, We can get this information by calling dsjobreport routine as after job routine. But I am wondering if there is any way to get this info from command line or if can write a script for doing so taking job name as an input or even a ...