DSXchange

Thanks for the Reply criag.

I tried it with one node it is completed in 4 minutes.
In the sense it is not executing.

Please suggest me on the same.

Hi All, I am using Stored Procedure stage to call stored procedure from SQL Server 2005. We are working on Data stage 8.5 We are connected to SAP. I had designed a job to call stored procedure is by a row generator stage and Stored procedure stage. RowGen -----> Stored Procedure. It will take min 4 ...

Hi All, I want to add a sequence No at the end of the date as 2011070700 as the Extract_seq_no. The situation is based on the date if it is executing 3 times on the same day then it should be incremented by 1 every time and should move to 2011070703. Then by the next day it should start with 00 agai...

I didnot get what will be the output stage for this.
Because source table & Target Table were defined in the Procedure.
Ther lies the confusion for me.
So please let me know on this.

thanks in Advance

I have to call stored procedure in the job.
I want to create job for the stored procedure.
By using Stored Procedure stage.
Can you please give me some tips to design the job.
That will be help full for me.

Hi , I have to design Data stage Job for the stored Procedure. In this stored procedure the source and target were defined so that what is my output stage if iam taking stored procedure stage. Please help me puit how to design this thanks in advance. The following is the stored procedure. USE [Temp1...

Hi All, I am trying to import Stored Procedures which i had created but when i was trying to import the Stored procedure was not able to view only system designed Stored procedures are viewable. I am trying to Import in Server Version. What ever the procedures which are designed are unable to view. ...

I had checked it with that my Source is SQL Server in that it is specified as NULLABLE NO.

It is Declared as nvarchar & should be converted it into Double.
at that time I am facing this warning.

I had declared POL_ID as Nullable no inthe source still I am Facing this Warning. My Source is SQL Server & Target is Oracle. I neeed to change the Data Types & load in the Oracle. "Data_Set_0: When checking operator: When binding output schema variable "outRec": When binding ...

There is a high possiblity that load from /dev/null command will lock the table. Contact your DBA to release the lock and try.

So i want to know whether there will be any other issues.
If this is the only issue then DBA can resolve this issue.
So DBA can resolve this problem.

Hi guys, I want to remove records from Db2 table. I had 20 lakh records in the table. I had executed "del from table name" it is not working. Then i tried to execute "load from /dev/null of del replace into Schema.tablename nonrecoverable" now i am unable to open the table when i...

You need to have the data sorted on Id, ID1 and Csid for the Remove Duplicates. If you sort on Id, Eff_Date, ID1 and Csid your data will still be sorted on Id, ID1 and Csid. Ditto if you sort on Id I had added column Id1 & CsId to Sort Stage but still I am facing the same warnings. So any thing...

Hi guys, I am facing a warning at runtime the warning is ass follows. "User inserted sort Sort does not fulfill the sort requirements of the downstream operator RemoveDuplicate" My job design is Dataset look up with DB2 table & filter then sort them based on Id & Eff_Dt then Remove...

check the format of the input value StringToDate(Eff_Dt,"%yyyy%mm%dd") for example %mm% is getting value 15 from source file means wrong because maximum month value is 12, so validate your input, one more thing for null field column you cannot directly use the transformation functions lik...

If you want specific help with a specific warning - then post the exact message. My Code is (StringToDate(Eff_Dt,"%yyyy%mm%dd") > DateFromDaysSince(CONFIG_DT, CurrentDate())) This is used to load the date with the config date. If the Eff_Dt is Null Then I am Facing an Error i.e " Con...