DSXchange

Obfuscation? Maybe there are lots of #define statements literally changing the syntax to make it look like BASIC? You can do the same in BASIC with EQU LIT. :lol: ok, now I tried to make 1 Parellel Routine but i am not able to bring it in runnable state the code is as follows: #include "C:\Asc...

JeroenDmt wrote: However the execution time for using a 1, 2 or 4 node configuration file are still about the same.

can you post the cofigurations like partitioning schemes used in your job
there are more possibilities but first of all check this

Hi all, we have installed DataStage 8.0.1 on AIX 5.2 but we are not able to see SQL Server Enterprise Stage. An any one tell me what are the possible causes for that? one more thing is that we want to create DSN to use ODBC connector on unix . can any one tell me how to configure a DSN to use ODBC c...

Refer to the BASIC manuals on how to open a file in BASIC which will bring the pointer to the end of file. Hence when you write again, it will get appended. You should really re-think your approach as , if you call this routine after each job and say you have 50 jobs, this one file can get really h...

and one more thing i am calling it in job sequence after a job to get statistics of that job

You are running two loops (i and j). <snip> Fine and dandy. Still don't think it is appropriate to just post a chunk of code and say "It doesn't work, please fix it for me" without something in the way of documentation or an explanation. Even if the answer is obvious, the OP needs to have...

DSguru2B wrote:You are running two loops (i and j). You initialize them but never increment them. The condition (i>10) and (j>10) is never true and hence an infinite loop.

Thanks DSguru2B Its working fine now;
can you tell me how to append that file while running next job?

When I am trying to run this routine it never ends i am unable to find why? Can any one help me to find out what is the problem? i=1 loop until i>10 DO if i>10 then exit StageName=FIELD(Stages,",",i) if StageName eq "" then exit Links= DSGetStageInfo(JobHandle, StageName, DSJ.LIN...

hi Jeawin,

can u send me your jobs to priyadarshikunal@gmail.com

thanks in advance

ArndW wrote:I'm afraid I currently don't have any examples of this to give to you, but perhaps someone else here might wish to post code. ...

thanks for reply ArndW.

please post the code is you find one!

regards,

ArndW wrote:What about page 144 of the Advanced Programmer's Guide? ...

Actually that defines the syntax of "DSGetJobInfo" i know all functions but dont know how to use those in parallel routines

sachin1 wrote:you can use

DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP)

need little formating. (server job)

i have used this in server job but parellel implementation is different i wanted to know parellel implementation

Actually I am new to datastage routines i want to generate job start time stamp, job last timestamp and job status for job start time stamp i used DS Macro "DSJobStartTimestamp" but unable to find any macro or inbuilt function. I think I should use "DSGetJobInfo" I am good in C++...

thaks to all of u !!!

I have sent a request to DBA for the SELECT privilege.


regards

Normal will provide data for an in-memory look up whereas Sparse will access the database directly. Normal might provide poor performance when the reference data is huge as it has to load large data into memory. In such scenarios a join stage may work better(It will put the data onto an internal da...