Search found 39 matches

by sankarsadasivan
Tue Dec 06, 2005 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Like searches in a string
Replies: 2
Views: 980

Like searches in a string

Is there any straight forward function to perform like searches in a string...

I did search the forum!

Please suggest

Thanks.
by sankarsadasivan
Fri Nov 18, 2005 10:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI Stage error - dsloadlibrary
Replies: 2
Views: 1058

Thanks for your response. Yes, we missed few of the installation steps mentioned in the guide. Fyi, We did the following and it is now working fine. 1) Installaed Oracle 8i Client 2) Installed Oracle 8i Enterprise Server 8.1.7.4_32 client libraries 3) Included the following varriables in the dsenv f...
by sankarsadasivan
Thu Nov 17, 2005 4:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI Stage error - dsloadlibrary
Replies: 2
Views: 1058

OCI Stage error - dsloadlibrary

We installed Datastage 5 on the unix mahcine and imported few jobs (which were running fine in another machine) We get the following error, on all the jobs using OCI stage ds_loadlibrary: error in dlopen of oraoci8.so - ld.so.1: dsapi_slave: fatal: libclntsh.so: open failed: No such file or director...
by sankarsadasivan
Tue Sep 13, 2005 7:45 am
Forum: General
Topic: Find the Last Modified Date of a Job
Replies: 12
Views: 9485

You can also find the information for manager.
by sankarsadasivan
Tue Sep 13, 2005 5:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsapi processes for a job
Replies: 16
Views: 10115

dsapi processes for a job

Is there any limit on the count of dsapi, beyond which we can say there is a malfunctioning happening in the server?
Is the count of dsapi something critical to be monitored?

Please sugggest.

Thanks
by sankarsadasivan
Mon Aug 15, 2005 5:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pre 4.2 User defined SQL behaviour in 5 version OCI Lookups
Replies: 3
Views: 1187

Pre 4.2 User defined SQL behaviour in 5 version OCI Lookups

Hi While using OCI lookup - user defined SQL query, there is an option "Pre 4.2 User defined SQL behaviour". If I dont check that option then the lookup fails with the oracle error Illegal varriable/Number. Can anyone please let me know what is the significance of that option and what is t...
by sankarsadasivan
Thu Jul 28, 2005 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cross language compatability of Datastage
Replies: 3
Views: 1713

Cross language compatability of Datastage

Will the following configuration work * DataStage server(Japanese) on a machine with the English version of the OS * DataStage Client(Englisg) on English version of the OS * Database(Japanese) on on English version of the OS For this, do we need to make any special settings. Anybody has any info? Pl...
by sankarsadasivan
Thu Mar 17, 2005 10:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job log from Multi Instance jobs
Replies: 5
Views: 1645

Job log from Multi Instance jobs

Thanks ArndW. That was quite useful, I enhanced the framework suggested by you to suit multi instant jobs and following is the code...Might be useful for some... Thanks again for your help Rgds Sankar ************************************************************** Attaching the job handle of the job,...
by sankarsadasivan
Thu Mar 17, 2005 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job log from Multi Instance jobs
Replies: 5
Views: 1645

Job log from Multi Instance jobs

Hi I am trying to get the job logs of Multi instance server jobs and trying to wirte it in an OS file. I am trying to use the following function DSGetLogSummary(JobHandle, EventType, StartTime, EndTime, MaxNumber) This function returns a dynamic array. I am not sure how to declare and access dynamic...