DSXchange

My requirement is like, my sourse is oracle table, I need to make many transactions on each record, first I have to validate, check its existense in the target(2 targets), if so I need to update one target and insert in other target. I coded all these in different jobs, now with the help of sequence...

I wanna process a set of Jobs on each record in a file.
All the jobs should be processed with one record before second record starts getting processed.
I am not getting how to use the loop state(sequence stage).
Please help.

I wanna update a row in the sequential file, please let me know the way.

I am trying to insert into SQL Server table using Stored procedure. I am getting the error "Elex_Level2..ToLoadTSub.RecstoTSub: DSD.BCIPut call to SQLExecute failed. SQL statement:{call ELEXTEST."dbo"."USP_InsertSubmissionDetails"(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,...

Hi,

Srinivas, Iam able to import the SP from the SQL Server.
I am not getting how to pass the values from the sourse to SP and how to take the written value from th SP

How can I use a stored producer(SQL 2000) in data stage,please find the stored procedure below. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER proc USP_GetSubmissionDetails(@AISTARTID int,@PRODUCTCD VARCHAR(4),@PRIMOREXCESS VARCHAR(1)) as BEGIN Declare @retval char(1) if exists(select * fr...

How can I use a stored producer(SQL 2000) in data stage,please find the stored procedure below. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER proc USP_GetSubmissionDetails(@AISTARTID int,@PRODUCTCD VARCHAR(4),@PRIMOREXCESS VARCHAR(1)) as BEGIN Declare @retval char(1) if exists(select * fr...

Yes , ur argument is correct is correct it the Stored procedure is in oracel, but the stored procedure is in SQL 2000, for SQL 2000 there is no concept of TNS names, only DSN

Sorry Boss, I cant get u, can u be still more clear

I am getting the error "TNS Names could not be resolved" when I amusing a stored procedure stage. This stroed procedure is in the SQL 2000 database. DSN was setup on the Data stage server, I am not sure why it is asking for TSN, please let me know the solution.

Thanks for all the suggestions. I did this way, If UnAssigned(Arg1) Or IsNull(Arg1) Then Ans = @NULL End Else If Arg1 Matches "8N" Then Test = Iconv(Arg1, "D4YMD") ; If Status() = 0 Then Ans = @TRUE ; End Else Ans = @FALSE ; End End Else Ans = @FALSE ; End End

Yes, I think there is some problem with the DSTransform DateGenericIsDate.Even I am trying the following condition, it is returning ED001. If Not(DateGenericIsDate(Date() )) Then "ED001" Else " OK" Can anyone please give me some idea to validate a YYYYMMDD string.To check whether...

Please find the condition in which I tried, If Not(DateGenericIsDate(ICONV(In.DateString [1,4]:'-': In.DateString [5,2]:'-': In.DateString [7,2],'D4-ymd') )) Then "ED001" Else " OK" The value of In.DateString is 20050501, the result should be "OK" but I am getting "...

My Input date is in the format YYYYMMDD , it is non delimited, I am trying to validate the input date with the DS Transform DateGenericIsDate , but this transform will accept the date in the DS internal format, so I am trying to convert the input date(YYYYMMDD) into DS internal format using DS trans...