DSXchange

You can also write Job Control Can you tell me how to call a procedure through Job control. I have simply called my procedure thro the stages. Now if i can call a procedure through Job Control is there any way that i can control the execution of procedure as before /after Job Subroutine. Thanks SumA

What is the Basic command that will capture if a row is inserted sucessfully or not. In my case whenever i find any new data i have to insert into my target at the same time i have to run three jobs simultaneously. I have writtern a routine that is used to run the Job. But i want to run the job only...

The stored procedure gets executed sucessfully when i am working with oracle. But when i invoke the Sp thro DS i get this problem.
I am calling the SP in the UPDATE ACTION of the Target Database

Are there any limitations that DS dosent support certail PLSQL commands.

Hi I have imported a stored procedure which has no arguments. When i call my procedure in my target database the exection never stops and my job hangs. I cudnt trace out where exactly the mistake is? Also when ever i import a sp with arguments i get a warning message and While executing the Job that...

Hi,, I understand from your example that the prefix of ur File Name xxx is constant, So i can write a routine to get the sysdate Iin wat ever format u need) and concatenete with the prefix of your fileName and use the value that is returned as FIle Name. But my problem is, i am not sure what exactly...

Thanks a lot for all your responses!! But i am using many inbult Functions like MONTH.TAG,TAG.TO.YEAR, DateCurrentDateTime in my routine.In that case how should i define my routine. As said if i use DSU.MONTH.TAG i get the following error Unable to open the operating system file "DSU_BP.O/DSX.T...

Thanks Arnd and Vignesh I need some help in writing routines. In my transformer stage i am using so many built in functions to find out the number of years, number of months and no of days between two given input dates.Since this becomes so complicated i want to write a routine to do this. But i am ...

Hi I have some doubts with Date Functions. Many of the Built-in Date Transforms like TAG.TO.YEAR etc returns varchar.I want to apply some arithmetic functions on these results. Is there any way to convert these varchar to integer. Also What do the functions Num,Int Return? Thanks & Regards SumA

Hi all, I have a problem with lookup. In the source say i have 5 records,But in the Look up i have only 3 matching records.When i make a loop up i get the records that are matching. To get the records that are not matching i give the condition in the constrains IsNull(DSLink.1) where DSLink1 is the ...

Difference comes with Performance.We can greately increase the performance with Parallel Jobs Since reading and writing take place simultaneously.You can get the details from the Parallel Jobs (pdf) where it is explained clearely Here is an example from the pdf ,Hope this will help you better in und...

I understand the Basic conceptof Row merger,But still I think we have an option for multiple lines,that decides if the output contains one row or multiple rows.But i am not sure with how that works. I tried using that and i face some problem.Can any explain me about this concept?? And I have one mor...

Link Partitioner,Link collector,IPC are performance related issues. These greately increase the performance. For Example if you have Lacks of records in your source you can divide the volume of data to be sent to the transformer by using the Link Partitioner so that the transformations take place si...

Hi, U can execute a stored Procedure from Datastage.You will hv to choose the update action as call stored procedure from the target Stage. Before that you will have to import the corresponding stored procedure thro manager ,I think you must be aware of that. As you have given a condition like you a...

Can i take it in this way. Even though i am creating a DSN name for ODBC Stage ,Internally it is only the service name or SID in tnsnames.ora that Functions. SO internally both the servicename and the DSN name functions in the same way. Can i frame a Rule that service id only should be used for ORAC...

Thanks a LOT!! Its very useful.I have generated code thro Job Control tab in Job Parameter. But if i compile it in a Routine i am facing the same problem Here is the code i generated, hJob1 = DSAttachJob("test1", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: tes...