DSXchange

hi wasim, right now i m using ODBC stage where I registered a SP . JOB flow is like this ODBC---->Transformer---> SEQ FILE when I run the job I set the parameter in job properties Job accepts the date parameter but prob is that it runs and gives 0 rows instead i cross checked with backend for same d...

hi ,

can any-body guide me on how to call a stored procedure in datastage with INPUT parameter?

Right now I regeister procedure in datastage,but it's giving me 0 rows in datastage ,

however If i ran same procedure in backend it rans successfully and return rows ..

hi chulett caould you please tell in brief that where to look for these option in DAtadtage 7.5 server edition--in odbs source? as i was not able to see any of the options told by you. Sure. Enable 'Create table in target database' on the Input link, Update Action 'Insert without clearing'. Then a n...

hi all, I designed a stored procedure like create temp table then insert into temp table from a select statement then select * from temp table then pass all selected values from temp table My procedure is having only OUT parameters. So how to call a stored procedure in datastage which is having only...

Hi,
I have multiple query set like
create temp table
then
insert into temp table from a select statement
then
select * from temp table

can I pass this all statements in ODBC -SQL sources/

Urgent Help appreciated.

HI when I ran one job it throws following error ,Could any body please confirm me what is this error cause ,I need solution for this urgent Following are the warnings thrown one after one by job --- 1 GetInvDelays: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thro...

HI when I ran one job it throws following error ,Could any body please confirm me what is this error cause Following are the warnings thrown one after one by job --- 1 GetInvDelays: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. 2GetInvDelays: An error has b...

can u elaborate more on this with detailed steps?

chulett wrote:And then realize what a pain it might be to use.

How are you managing this currently? I would build a Sequence job and just feed this job in a loop. UserVariables, Start/End Loop. ...

There is one particular job ,which accepts, run time file name thru job parameter and appends output to the another file(based on condition like select only those records from i/p file where dept=10 and append it to o/p file ) . but as number of files to be run for each job are high(near @ 100 file...