Search found 31 matches
- Thu Apr 21, 2005 12:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Stored proceadure
- Replies: 4
- Views: 1993
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
- Mon Mar 28, 2005 11:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Basic command to capture if insertion is sucessful
- Replies: 2
- Views: 1602
Basic command to capture if insertion is sucessful
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...
- Mon Mar 14, 2005 4:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Stored procedure-Job Hangs
- Replies: 3
- Views: 4660
- Mon Mar 14, 2005 4:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Stored procedure-Job Hangs
- Replies: 3
- Views: 4660
Problem with Stored procedure-Job Hangs
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...
- Thu Feb 24, 2005 11:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing a Job Parameter for picking up a dynamic File Name
- Replies: 10
- Views: 4283
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...
- Tue Feb 15, 2005 4:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Routines
- Replies: 8
- Views: 6066
- Tue Feb 15, 2005 3:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Routines
- Replies: 8
- Views: 6066
Problem with Routines
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 ...
- Tue Feb 15, 2005 1:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Conversion-Varchar to Integer
- Replies: 2
- Views: 2048
Conversion-Varchar to Integer
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
- Thu Dec 23, 2004 3:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to retrive unmatching records from lookup
- Replies: 8
- Views: 4292
how to retrive unmatching records from lookup
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 ...
- Mon Aug 16, 2004 10:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server versus Parallel Job
- Replies: 2
- Views: 1496
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...
- Mon Aug 16, 2004 12:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: RowMerger
- Replies: 3
- Views: 1965
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...
- Thu Aug 12, 2004 2:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use Link Partitioner?
- Replies: 3
- Views: 3669
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...
- Tue Aug 10, 2004 4:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: execute stored proc in job?
- Replies: 5
- Views: 3285
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...
- Wed Aug 04, 2004 6:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC and OCI Stages
- Replies: 3
- Views: 1719
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...
- Wed Aug 04, 2004 6:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Routine
- Replies: 1
- Views: 2245
Problem with Routine
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...