Search found 55 matches

by ashwin2912
Tue Apr 26, 2005 11:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with BASIC transformer in parallel job
Replies: 8
Views: 4944

Hi Ray, I am not querying for every row processed, I am just running the query once the job is over to get the log in a file..thats it! Also @ID is part of the query and not in transformer....the error I am facing is Full Text. BASIC_Transformer_34,0: Operator terminated abnormally: runLocally did n...
by ashwin2912
Tue Apr 26, 2005 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with BASIC transformer in parallel job
Replies: 8
Views: 4944

Problem with BASIC transformer in parallel job

I have a BASIC transformer and one i/p file and o/p file in a parallel job...getting the following error...very surprising...I have no clue what is happening!!! Just attached the job log below: @ID FIELD ( TRANS ( RT_LOG109 , //JOB.STARTED.NO , 1 , X ) , ( char ( 252 ) ) , 1 ) Timestamp. 2005-04-11 ...
by ashwin2912
Tue Apr 26, 2005 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_LOGNN latest run only
Replies: 10
Views: 4175

Code: Select all

where EVAL \"@ID\" NOT LIKE '//%'

Code: Select all

CAST(EVAL \"FIELD(TRANS('RT_LOG32','//JOB.STARTED.NO',1,'X'), @SVM, 1)
Can u tell me what these actually do?
by ashwin2912
Tue Apr 26, 2005 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_LOGNN latest run only
Replies: 10
Views: 4175

Thnx Ray....
hmm...Inspection :twisted:
by ashwin2912
Tue Apr 26, 2005 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_LOGNN latest run only
Replies: 10
Views: 4175

Hi Kim, First of all...thnx a lot But can you throw some light on this error: $DSHOME/bin/uv "select TIMESTAMP, SEVERITY, FULL.TEXT from RT_LOG32 where EVAL \"@ID\" NOT LIKE '//%' AND @ID > CAST(EVAL \"FIELD('RT_LOG32','//JOB.STARTED.NO',1,'X')\" AS DECIMAL) order by @ID;&qu...
by ashwin2912
Mon Apr 25, 2005 9:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort job on reject threshold
Replies: 3
Views: 1443

Other than using a transformer for counting the records going into reject, I was trying this one: I took the reject link and put it in a copy stage. One o/p from copy stage going to the Sequential file(reject file) and another one into a wrap stage....(wrap stage calling a UNIX script which will wc-...
by ashwin2912
Mon Apr 25, 2005 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_LOGNN latest run only
Replies: 10
Views: 4175

RT_LOGNN latest run only

Hi

I am running this command:

Code: Select all

$DSBIN/uv "select TIMESTAMP, SEVERITY, FULL.TEXT from RT_LOG32 where EVAL \"@ID\" NOT LIKE '//%' order by @ID;"
Is there any way i can filter out only those entries for the latest run of the job.

Thanks,
Ashwin
by ashwin2912
Sun Apr 24, 2005 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort job on reject threshold
Replies: 3
Views: 1443

Abort job on reject threshold

I need to abort a job on a reject threshold. The link is from a lookup/filter stage and going to a sequential file. I need to abort the job when the records in this link cross a pre-defined threshold. This is a parallel job. (Is it advisable to use a BASIC transformer in a parallel job? Esp in such ...
by ashwin2912
Wed Apr 20, 2005 11:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob error in UNIX
Replies: 8
Views: 4214

Thanks everyone... I did not know about dsenv as it was not required on Windows platform to run dsjob... Regards, Ashwin If the $DSHOME/bin directory is in your PATH you can execute the dsjob command from anywhere. Or you can use the full pathname of dsjob, as illustrated below. But you do need the ...
by ashwin2912
Wed Apr 20, 2005 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob error in UNIX
Replies: 8
Views: 4214

dsjob error in UNIX

I am getting this error for dsjob on UNIX. Is this right way to run this command. The following command runs properly on Windows (DOS prompt) $ dsjob -server <server_ip> -user <userid> -password <password> -run <project name> <jobname> ld.so.1: dsjob: fatal: libvmdsapi.so: open failed: No such file ...