DSXchange

Hi,

Please let me know if any of the services needs to be explicitly stopped before installing the server/client. I have installed .NET framework 2.0 and 3.0.

Thanks in advance,

What is your client platform? Does this happen to everyone or just you? DS Designer also I am running it from Windows 2003 server. But If I connect to same server from Windows XP OS with the designer then I did not find any issue. Only if I am opening designer on Windows 2003 server I am getting th...

Installed DS Server on Windows 2003 with sp2
Whenever we login to the server using DS Designer its logging in and the designer is getting closed immediately. This problem is not observed with DS Administrator, DS Manager or with DS Director.
DS Version 7.5.1

Hi, Thanks for the response. If we dont use DSWait function, how can we be sure that the job which has been started has completed. Because there are chances that the controlling routine will finish before all the jobs have been completed. Alternative is in the end i can check if all JobHandleArray h...

Hi, We are using a LoadBalancing routine to run "N" jobs in parallel from a given list of jobs. Given below is the code snippet for the same. The code below achieves the following functionality :- It starts N jobs in parallel but only after all the N jobs finish execution it takes the next...

Convert the ^~ to a single delimeter by using CONVERT and use the field function Convert("^~","|",InputLink.Col) Thanks for the reply, but the reason for using multiple char as delimiter is that such type of combination of char (not exactly what is given in the example )may not ...

hamzaqk wrote:are the smile coming through in your data too ?

Hi,

Please consider the example as below for clarification:-
input_string = A:B^~C:M^~E:F
We want to get individual strings A:B, C:M, E:F
Delimiter is "^~".

Thanks,

Hi, We have a requirement wherein we need to extract substrings from a string where the delimiter is "^~"(basically delimiter is more than 1 character.) Field function supports delimiter with a single character. For example :- input_string = A:B^~C:D^~E:F We want to get individual strings ...

sachin1 wrote:please elaborate what you want to achieve, may be you need to custom code in JOB-Control tab.

Hi,

We have a seq named "JobSeq1".
And a job named "Job1".

I want to run/call the JobSeq1 from Job Control tab of "Job1".

I hope this clears the question.

Hi,

Our requirement is to control a Job Sequence from another job(in job control). Is it possible to do it or is there any other alternative available to acheive the same.

Any help in this regard would be greatly appreciated.

Thanks in advance,

Thanks for the reply Craig.

You need a script to call sqlplus, one that can check for errors and pass them back.

Can you point me to where to find it and how to go about it.

hi, we are using before/afterjob subroutines to call stored procedures through sqlplus before/after our job executes. We are not able to get back errors when there are some issues with Stored Procedure execution. For example even when there is no such Stored Procedure present in database, the job te...

Hi, We have requirement to execute some SQL statements from a routine. The DataStage server is on Windows and the database is Oracle. The command that we use in the routine to get this done is, Call DSExecute("NT", Cmd, Output, SysRetCode) The second argument 'Cmd' is the single line of co...

Hi, We wish to fire some SQL commands from a before job subroutine. I searched DS Manual and this forum but could only find ways to fire SQL over ODBC connection through subroutines. We are using oracle native client to connect to oracle(we are using oracle stages) and do not wish to use odbc connec...

ArndW, shutting DS server down and restarting the machine also didn't help. kcbland, we are using same windows local user to connect to DS. Ours is a small team and each user use the same username/pwd to connect to DS; since different developers are working on different jobs it has not caused any is...