DSXchange

Hi ,


This is link, just download patch from here

http://www.ascential.com/eservice/pages ... tches.html


DS Client Patch for Windows XP SP2 Windows XP, Service Pack 2 DataStage 7.5 10/05/2004

dsclient_xpsp2.zip

spetty wrote:Hi,

I have exactly this problem. Did you manage to find the patch?

Hi,


I am executing stored prcoedure using ODBC, how to capture the result set (columns) in to variables,

so that when i run second prcoedure i want to pass this value to one of the input parameters of stored procedure.

Thanks

Thanks Ray. Can't you just pass the value along a link to the ODBC stage that invokes the second Stored Procedure? . yes, i did that. ODBC(SP1)----TRANSOFORMER---seq (first job) seq--- transofrmer---ODBC(SP2). (second job) After executing second SP, i need to pass its out put parameter value to thir...

Hi All, I am running sql server stored Prcoedure using ODBC stage, with input parameters which returns output 'sequence key, return code. i am storing its output in a sequential file. this 'sequnce key' should go as input parameter value to second stored procedure. how can i pass 'sequence key' valu...

Thanks

I got it.

Hi I am calling Stored Procedure using ODBC (select using Stored Procedure), In Parameters Tab there are 4 Input variables starting with @, and Column tab there are 2 columns mapping to output seqfile. when i run the job it is not asking for values of parameters. but when i remove the @symbol , if i...

Thanks kcbland I have one more question for you, does this subroutine returns a value if we pass input parameters to stored procedure. I One method is to write a .bat script using the command line interface to your unnamed database. If Oracle, I suggest using sqplus, if SQL-Server, OSQL/ISQL is a go...

Hi all, before i run the etl job i need to populate a table using 'begin store procedure' and after running the job i need to update the same table using 'update stored procedure'. My question is can we call stored procedures using before job/stage and after job/stage routines or do i need to develo...

Hi Arnd


Thanks

ArndW wrote:Harithay,

I haven't had this problem, but I have seen posts from others who have. It seems that there is a patch for this from IBM/Ascential. If you do a search you'll find the other threads on this subject.

Hi ,

I am getting follwing error when i try to open Sequence job. i am unable to open stage proerties in sequncer job but i am able to open server job stage properties.


it is giving
DSDesign.exe -Application error
memory could not be "read".

What might be the problem.

Thanks

Hi


I got it, i have solved ' warning'message

thanks

Hi ,

sorry for posting in server jobs.

ranga1970 wrote:This should have been post in Parrallel forum

thanks

Hi ; I am getting problem in merging of two files. when i run the job, it is aborting and giving follwing warning 'Abnormal termination of stage Mergestage_texst..Transformer_1 detected' when i reset the same job, it is giving following information: 'From previous run DataStage Job 222 Phantom 12884...

Hi all; i have source flat file(tab delimited). i have to calculate ' change in assets' for new records based on existing records based on fund name , fund_no(key columns) after matching date difference between new record and existing record should be 360 and 370,and the existing record should have ...

Hi , Thanks for ur reply I got It, By changing Sql type to "Varchar" and deleting the numbers in ' length'. Thanks Does this DATE field contain any value? If the field is having NULL value, can you assign a default value while reading sequential file and transform it back in the transforme...