DSXchange

While loading the Parameters in StoredProcedure Stage -> Stage window ParameterName MapToColumn Parameter Maker/literal ParameterType ReturnValue MustSpecifyColumn ? Function @dateFrom MustSpecifyColumn ? Input @dateTo MustSpecifyColumn ? Input Please let me know how can we pass the values here ? Th...

Hi All, Iam using Datastage 9.1 Version. Iam supposed to use StoredProcedure Stage to call SQLServer Stored Procedure. ReturnValue = Sp_CallSales(dateFrom, dateTo) Here ReturnValue is 0/1 dateFrom, dateTo are input parameter to pass the dates The procedure gives the data from specific table joins an...

Hi All,

I have restarted the Datastage server(version 8.5) because of login problem DS Client.

After restart it is able to login, but not able to view the job in folders.

Just showing only the folder in the Repository.

Please help me on this.



Thanks In Advance....
Krishna B

Hi all, Presetly iam working in parallel jobs. In that i configured the no of nodes : 4 nodes. Unable to start ORCHESTRATE process on node node3 :APT_PM_Player .. APT_PM_Player:fork() fails........ Unable to start ORCHESTRATE process on node node2 APT_PM_Player .. APT_PM_Player:fork() fails........ ...

Latest version in datastage..

And what are the new features between 7x and 8x.

Thanks&Advance,
Krishna.

Hi All,

how can i release the lock in datasage job level...
And also Some time the target table was locked because of two jobs are using the same table.....
How can i release the table in db2...

-------------------
thanks&Advance,
Krishna

hi all,

When iam running the jobs some timesiam getting the error like this:

Unable to start ORCHESTRATE process on node...

----------
Thanks & Advance,
Krishna.

Thank U.

Hi,

Is there any wizard is there for SCD's in datastage like as Informatica Mapping Wizard......

Hi All,

How can we implement SCD's in Datastage parallel jobs.

In Informatica we have mapping wizard tool menu option is there to create the SCD's

Mapping Wizard - type 1, type 2, type 3.


Thanks In Advance...