DSXchange

Hi all
i want to learn profile stage ,
do any one have Profile stage doc/tutorial.
It would be greatfull if anyone give me the software .
if anyone has documentation plz forword to my mail
kreddy29@gmail.com

Regards
KK

i want to read the jobstatus in a routine i am not sure of the invocation id
i want to check the log file of the job with any invocation id running
how can i get it in a routine ??
thanks for ur replies

dear Gurus i have a question where the datastage job log file is stored . i have s secnario where i am running the multiple jobsequence instance like jobseq A is a multiinstance job with jobb jobc jobd as sub jobs before running joba i have to check any multiinstaance job running for joba and have t...

Hi ,
Can any one help me how to create,insert update and delete records into a hashed file ,without using hashed file stage ,i mean by using Datastage Routines or unix script , if u have any example script or the place where can i find information Plz let me know .

Regards
KK

Job_Activity_3.$JobStatus = DSJS_STOPPED

i am getting the warning message Variable 'DSJS_STOPPED' never assigned a value.


Regards
Kk

Job D is executing the JobA is stopped programatically .
if the user press the stop button at that time job d is not executing
can any one tell me where i am wrong


regards
KK

How to Execute A Job or Routine in a sequence if a job is stopped intentionally by user . I hace a senario Like Job a ------if ok ------ job b if failed ----jobc if stopped by the user --- jobd can any one help me how to catch the stop request .present i am using the joba.$JobStatus=DSJS.STOPPED whi...

Dear DSGurus, when i am running the Job sequence i am getting the following errors Can any one explain me what for the following errors APT_CombinedOperatorController(0),0: Failure during execution of operator logic APT_CombinedOperatorController(0),0: Fatal Error: Tsort merger aborting: Scratch spa...

Hi Gurus , can any one help me how to implement the following query in DSEE as i am new to Datastage SELECT distinct col1,col2,col3 FROM tableA WHERE ( AP > 0 or SP > 0 ) and lf = '01' and ce = '01' and rd = '00'and col1 not in ( select col1 from tableA where col4 = '01' and col5 = '01' and col6 = '...

Hi,
Can any one help me in how to clean up the datasets and other files created by a parallel job ,
my disk is running out of memory and need to clean up the files ,

Thanks in advance for ur replies

Raag

Hi all ,
when i tried to open properities of a activity i am getting the error message as

fieldToProp:Internelerror- Bad number of sub objects

could anybody help why i am getting the message ,

thanks in advance

kkr

Dear ALL , at last i got answer


i added option indexmode = rebuild for oracle stage in properities


Cheers :D

Dear Guru's my job is like seq stage ----- skeygenerator stage -- oraclestage i have a single row in seq file and i am genetating a unique key for that record , this record is not inseting into oracle , it is throwing errors Oracle_Enterprise_47,0: system(sqlldr username@orcl CONTROL=ora.2936956.472...

even i am unable to open those jobs in designer and getting the error "this item has no design time information" , and abe to run those in director ,

thanks smith for ur reply
regards
Kiran

Dear Guru's
i am unable to export jobs as xml from dsmanager, it is showing

noobjects were found to export

.
what could be the reason .

thanks in advance for ur reply

Regds
Kiran