DSXchange

Hello samp, ...(My company has not the job sequence activated) It is not possible to disable use of job sequences in DataStage and this looks like a perfect use for this type ... by "disable" i mean, we're in xp sp2 and the pop up doesn't work on a job sequence... my company has not got t...

I Guess u can have a regular expression to do that job. While reading from the source directory. Read it as <PATH>/*.bad. no i tried. i think it is possible with filter command in the sequential input but i can't achieve it ! i don't know what i should put in the filname text box as i have put &quo...

Hi, i would like to treat all ".bad" files located in a repository. all my files have the terminaison ".bad" and i wish to treat all of them one by one using the same job. like *.bad files ---> transformer ---> append in file. which stage can i use in a server job? (My company ha...

Hi, i would like to test if my sequential file in source (csv separated ;) is good before run job. i explain. i would like to check if all my columns have got datas. my goal is to isolate if it is possible the bad line (ex: wrong date) before running the job in order to eliminate the potential abort...

hi, working on ds7.5, unix environment i've got a pb. i don't understand this part of my routine: ------------------- Seq = "" Rep="" ***define Rep<-1>="NameofJob" : @VM: "nameofdirectory" seq<-1>=resultofaroutine1. -------------------- the @VM corresponds to ...

At least i have found a way to delete my job. 1 - Open datastage Administrator and, in your project, open command window. 2 - execute the following SQL : DELETE FROM DS_JOBS WHERE NAME = 'JobName' 3 - Execute at least the DS.CHECKER command . It will find some files previously attached to yout job :...

This is my output. COMO DSR_CHECKER established 15:52:13 25 JUN 2007 ********************************************************************** Checking job files ********************************************************************** *** Processing: DS_JOBS... Number of jobs found: 596 *** Processing jo...

i try a DS.CHEKER, but same result. same error. if i try to compile the job : i obtain the error : Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES (Subroutine failed to complete successfully (30107)) + (40503) A call to an OLE server has failed...

i stop and start the ds server, and the server itseft... it hasn't solve the problem...

i do that, i have copied and renamed my job in order to use it. it works.
but now i would like to delete the wrong one, and i can't.
it's not clean .

is there a way to re-link the executable file ?

Hello, when i would like to delete a job, i have the message : "Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES (Subroutine failed to complete successfully (30107))" first , i thunk that my job was locked, but i could edit it !, trans...

Can you not do 2 lookups and performthe IF 0 logic in the transform stage?" which means ?? i always must replace the zero value by the last non-zero value ... it seems simple, but stage variable just keep in memory the value of the previous row ... that's why i put in a hash file all my non-ze...

ok, but the problem is a little bit hard. i have one hash file that contain a date and a value associate to this date. this value is different from 0. ex: date1 | val ----------------------- 01/01/04 | 25 08/01/04 | 26 29/01/04 | 32 the reference link contains all datas (values could be equal to 0)....

hi, i would like to know if it's possible to replace a value by the value on the line before. I think it is possible in a transformer but i'm not sure. i explain . i have this kind of file : week value 1 25 2 0 3 56 and i want to replace the 0 by 25. 1 25 2 25 3 56 thanks

I know that datastage is not a reporting tool. my question was not to construct intervals but finding a way in datastage (using routine or other things) to generate a file wich indicates the number of simultaneous connections . my first idea was to create a routine and test for each line all the oth...