Search found 124 matches

by Roopanwita
Tue Jun 17, 2008 1:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading from COBOL file
Replies: 5
Views: 1113

COBOL file column defn Netive type =DECIMAL, Length =2 ,Scale=0,Level number =02,Sign indicator =Signed, Usage= COMP-3
by Roopanwita
Tue Jun 17, 2008 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading from COBOL file
Replies: 5
Views: 1113

Reading from COBOL file

Hi, My job reads from COBOL file(used sequential file as source) and write into ORACLE stage. In my sorce file columns are Decimal & NChar. The job is getting aborted with arror msg " seq_src,0: Field "<column name>" has import error and no default value; data: {0c 00 00 00 "...
by Roopanwita
Wed Jun 04, 2008 5:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing part of job log using routine
Replies: 28
Views: 8995

With modified value of TO_MAILID & FROM_MAILID (as u mentioned to define as TempTO_MAILID) , the routine is running for long time and unable to send mail msg.
by Roopanwita
Wed Jun 04, 2008 3:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing part of job log using routine
Replies: 28
Views: 8995

It is throwing error ,while compiling - "3 Errors detected, No Object Code Produced."
by Roopanwita
Wed Jun 04, 2008 1:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing part of job log using routine
Replies: 28
Views: 8995

Routine is compiling successfully but unable to send mail.
by Roopanwita
Tue Jun 03, 2008 11:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing part of job log using routine
Replies: 28
Views: 8995

Hi, Thanks for help. I have checked with Notification Activity Stage. It sends the status msg (like finished successfully/finisished with warning/Aborted) only. I want to capture the error msg line(in case of fatal error) from the job log, so that in case of job failure i can understand the reason o...
by Roopanwita
Tue Jun 03, 2008 5:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing Job Log in a file using UNIX script
Replies: 3
Views: 863

I wrote a script n I have provided proper connection detail,still it is throwing error "Unable to connect to project" (I am passing Project name as parameter)
Also, throwing error "Improper redirection " in stage of checking ,if file already exists or not.
by Roopanwita
Tue Jun 03, 2008 4:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing Job Log in a file using UNIX script
Replies: 3
Views: 863

Writing Job Log in a file using UNIX script

Hi, My requirement is to write a UNIX script which will write the job status ( will capture actual msg like, if it is aborted ,it will capture Fatal error msg line) in a file. I searched in DSXCHANGE,got some info also but i m unable to use info properly.(wrote a script ,but it is not working) Also,...
by Roopanwita
Tue Jun 03, 2008 12:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error via email
Replies: 12
Views: 4435

Thanks for your help.
This process is working fine,but my requirement is different.
Here error msg sent is static.I want to capture error msg from job log & sent through mail notification.

Can you please help me out.
by Roopanwita
Thu May 29, 2008 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error via email
Replies: 12
Views: 4435

Thanks for reply.
Than I am not aware of it.Can you please guide me ...
Thanks ...
by Roopanwita
Thu May 29, 2008 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error via email
Replies: 12
Views: 4435

Thanks for clarification. By using built in stage ,I am able to send only job status( finished/finished with warning/aborted) only..So I am trying to write a Routine/Script which will capture the error msg also from log... While searching I came across this script... I have one more qn,if the job is...
by Roopanwita
Wed May 28, 2008 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error via email
Replies: 12
Views: 4435

Hi,
I got a query for the post...
which parameter is $4?
Can I use DSRUNJOB script of Ascential to run the sequence?
by Roopanwita
Tue May 27, 2008 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing part of job log using routine
Replies: 28
Views: 8995

My requirement is to post Error msg by mail,in case of job failure.I coudn't get your msg.
Can you explain it again.
by Roopanwita
Tue May 27, 2008 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture stage
Replies: 20
Views: 6214

sorry by mistake I have posted same msg thrice.If I delete this post will it delete entire post?