DSXchange

No.....I have not tried Stored Procedure stage.

I don't want to return any values from the stored procedure.

Can I use ODBC stage? If yes,then pls let me know how?

I want to call a SQL server Stored procedure by passing some input parameters

Can someone tell me how to call a SQL server stored procedure by passing parameters from datastage ?

Do we have a limitation on the space available for a particular project. I used to get xmeta exceptions in a project with a large number of jobs when I had tried to create new jobs or create a copy of a job. When I finally deleted some unused jobs, I am not getting that exception.

Thanks. I understood what you meant! Since the values in DEPTNAME are sparse hence they landed in one partition. I have one query. The Configuration file in my Production System has 8 logical nodes. If in there I receive 50,000 records for DEPTNAME='IT' and 50,000 records for DEPTNAME='HR' then the ...

Another thing. If I Set the Copy Stage to Round Robin (or Auto) and the downstream stages to Same then the records are evenly partitioned into the two logical Nodes. But yes then the records are getting split-ted wrongly which off-course is of no help. :( Also If I Set the Copy Stage to Round Robin ...

Hi James,

No there are no node constraints in use in the Job.

regards,
saraswati

Sorry for missing out the values in the table : EMP. Here they are: EMPNAME DEPTNAME SALARY ----------- ------------- -------- HARRY IT 10000 SALLY HR 30000 DAVID IT 5000 MARK HR 7500 JANUARY IT 20000 JULIAN HR 15000 Since there are 2 logical nodes. So a Hash partition on DEPTNAME should have made 2...

(1) The Oracle Connector stage has a user defined query which selects three columns : SELECT EMPNAME, DEPTNAME, SALARY FROM EMP The Oracle Connector Stage has been set to run in Sequential Mode (2) The Next Stage Copy is copying the records returned by the Oracle Connector Stage and passing it into ...

Hi Friends, I have a Job which is designed as below: <Oracle_Connector_Stage> -> <Copy_Stage> -> <Aggregator_State> -> <Sequential_File> (1)Now my job is running on a configuration file with 2 logical nodes. (2)The Oracle Connector Stage is running sequentially. (3)The Copy Stage had been configured...

CREATE OR REPLACE FUNCTION FUNC_START_DATE (delivery_date DATE, in_transit_days NUMBER) RETURN DATE IS Counter NATURAL := 0; CurDate DATE := delivery_date; DayNum POSITIVE; SkipCntr NATURAL := 0; Direction INTEGER := 1; -- days after delivery_date BusinessDays NUMBER := in_transit_days; BEGIN IF in...

The above logic doesn't work out.

Basically, I want logic to subtract N weekdays from a given date.While subtracting,we will not consider Saturdays and Sundays.

I am using Oracle database. I will explain you the business requirements. A delivery date is there for a material. There is a certain intransit days for shipment for a particular material.Currently,the shipment start date = delivery date - Intransit days. So, the number of saturdays and sundays whic...

I am only concerned about the working days( Mon-Fri) and not holidays. I will give you an example. Start_date = 20110509 End_date= 20110518 So, there is only one weekend between these days. (14th and 15th May). I need to shift the start day two days before 20110509. Now,the challenge is 20110507 and...

I am looking for a logic to get it immediately implemented using parallel transformer.

Please let me know a logic to find out the number of weekends ( Saturdays\Sundays) between two dates.