DSXchange

I agree with Ken but if I was going to do this then I would create the project first. Next I would overlay the project with the one from the other machine. This would update the necessary files in the UV account. We tried this but we could not see the jobs in the designer. We made sure the copy was...

Hi All Can we move a Datstage project from one box to another on UNIX. 1.Both the unix boxes are exactly the same 2.Both have the same ver of Datstage installed. 3.Both have the same directory structure for datatsage projects. Instead of exporting and importing the jobs from one box to another,we we...

Hi All Can we move a Datstage project from one box to another on UNIX. 1.Both the unix boxes are exactly the same 2.Both have the same ver of Datstage installed. 3.Both have the same directory structure for datatsage projects. Instead of exporting and importing the jobs from one box to another,we we...

I submitted this case to Ascential and they said we have to update our Oracle from 9 to 9.2. I sent them the process sizes and there seems to be a memory leak. I was thinking that the memory leak is b'coz of Datastage and not database version.May be they should have told us before that thier Oracle ...

Hi KC It just says abnormal termination detected.Its one of those tough ones. I already have a rejects file..,i dont see anything in that file. It fails at different row numbers each time.So,its not the data issue and usuallly it fails towards the end of the file.To me it looks like some scratch fil...

HI I have a job which loads data from seq file to oracle table. The job has a seq file input---transformer (has trims on all columns)-----Oacle stage(Insert or update) The job runs fine for small datasets but aborts for bigger ones. I have a file which has 530,000 records in it and it usually aborts...

Hi I did some more testing.., There is a funnel stage in the job that builds the file set. Once i removed the funnel and used a user defined sql to do the join it worked.I was using a continuous funnel. Pls feel free to add any comments. regards Hi I have a parallel extender job which does a lookup ...

Hi I have a parallel extender job which does a lookup on a file set using the lookup stage.I have around 100,000 rows in my file set.The lookup works for some rows which are at the beginning but does not work for other rows which are towards the end of the file. When i reduced the number of rows in ...

Hi All

How can i connect to sql-server from parallel extender.
I dont see a odbc stage on my parallel canvas pallatte.I only have it on my
serve canvas.
Does Ascential sell SQL SERVER plugins for PX???

Thanks

Thanks Kenneth and Ray! We avoid having stage variable solutions if possible b'coz the code is not re-usable.Actually the Routine does a lot of verifications(lengthy code) and its kinda hard to implement it as a stage variable. Anyway, now that Ray has passed it,I will use it in peace :-) regards Es...

HI I have a routine(I call it fom the Transformer) which checks the validity of a coulmn and call Abort if the value of the column is not valid. The Business Requirement is to error out the job if we get a invalid value without any further processing. Ray has mentioned that it is not a good practice...

Hi I have written a routine to call a DataStage job using the regular DSAttachJob and DSRunJob functions. When i call this routine from the transfomer of my main Datastage job , the Routine(and the job that is called from it) runs successfully the first time(i.e for the first row returned extracted ...

Hi,

i am using datastage 0S390 4.2.My program has some 15 lookups and 4 transformer stages.when i save the job and generate code.It gets stuck while genrating the code.COuld anyone help me on this?


thanks,
deep

Hi All 1.Is it safe to read from the same SEQUENTIAL file multiple times in the same job. 2.Can diffrent jobs read from the same SEQUENTIAL file at the same time. 3.Is it safe to read from the same HASH file multiple times in the same job. 4.Can diffrent jobs read from the same HASH file at the same...

Yeah..,Thazz wat i did..,But dont think its a bug.
There should be a way to pass quote(') right!!