DSXchange

hi,
I have a requirement where I need to capture job name and elapsed time for every job in project. Rightnow I am doing in manually...Is there is any betterway.

Legendkiller

Hi Ray, I generally occurs in one of the stage variable definitions. And I can confidently say that there is noting malicious in the stage variable definition that should have caused this. FYR, I am pasting "the" stage variable definition that's causing the problem "this" time, I...

I have been using 7.5.x for quite some time and never came across this problem which was trobling me a big time. I have a transformer in the job with a good number of transformations and conversions, the problem is transformer just wont compile and the reason it gives is crazy 0000 05:16:15(682) <ma...

okk....I thought transformer is not so efficient stage ..hence I want to get rid of it to improve performance :D

Hi, I have job in which I am using transformer to to check whether particular value has onlly integer or not (I am using is Isvalid function). I am passing records only with integer value in particular col. Now I want to replace transformer from this job, I there is any other stage ( modify, filter ...

are you doing hash partitioning and sorting on boyh the links? Is the number of records on both link are same?

In most of stages ...where you specify property value ..there is provision to include job parameters as value.. For example in transformer you can pass job parameter to output column definition by going to derivation and by right clicking and selectiong job parameters. refer documentation docs for m...

In most of stages ...where you specify property value ..there is provision to include job parameters as value.. For example in transformer you can pass job parameter to output column definition by going to derivation and by right clicking and selectiong job parameters. refer documentation docs for m...

I am getting following error

SQLAllocHandle: Failed to allocate environment handle 'ENV'.

when reading from db2 table

my query looks
SELECT column list....
FROM #Environmnet variable#Table A E, #Environmnet variable#Table B I
WHERE condition;

I guess we also need to take care of partition...you may have to put hash partion of column A and then put same partion in transformer..or you can run transformer in sequential mode

May be a afterjob subroutine / routine to search through log file for fatal entries and then stop sequencer based on result.

I am sure there are function like Getloginfo ...etc which will give if log contains fatal msg or not....

if you are using advance version of DS post 7.5 then DS has inbuilt restart point facility...otherwise you may have to design restartable job sequence...for example u can write job name to file and while start of sequence read that file and decide which job to run.,,,

what are the requirements for establishing the connection between the datastage and DB2

Can sumbody tell me column defination of RT_LOGnnn file. ( I searched on forum but could not get it) I want to dump log file for each job into delimiter file. Also by Dsjob command can I copy complete log into file I have tried c:\Ascential\DataStage\Engine\bin\dsjob -logdetail #$DS_PROJ_NAME# <Job ...

can anybody tell me how to create job to dump the requisite contents from DataStage job logs into, for example, delimited text files.