Search found 97 matches

by devanars
Mon Aug 17, 2009 10:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i recollect deleted jobs
Replies: 8
Views: 2971

How ever may be the terminology. Is there any way to get back or restore the same if any job was deleted accidently.
by devanars
Mon Aug 17, 2009 9:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i recollect deleted jobs
Replies: 8
Views: 2971

How can i recollect deleted jobs

Can anyone help me how to recollect deleted jobs.Thanks
by devanars
Thu Aug 13, 2009 8:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number format
Replies: 3
Views: 1209

can we use the same in parallel jobs also
by devanars
Wed Aug 12, 2009 2:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number format
Replies: 3
Views: 1209

Number format

How can i replace the number from 0009998888 to 000-999-8888
by devanars
Tue Aug 11, 2009 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commit Interval
Replies: 1
Views: 882

Commit Interval

How can i commit freequency of records when i use sql loader
by devanars
Mon Aug 10, 2009 5:15 pm
Forum: General
Topic: Seq Increment
Replies: 6
Views: 2017

May i know what is this second one. anything missing below logic.
svSeq: If svNewId Then 1 Else svSeq + 1

Please correct me if i am wrong
by devanars
Mon Aug 10, 2009 3:38 pm
Forum: General
Topic: Seq Increment
Replies: 6
Views: 2017

Sort_23,0: Input not sorted at record 2 is the error coming and job is getting aborted. advise please
by devanars
Mon Aug 10, 2009 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Scheduler
Replies: 7
Views: 3065

I was new as a admin so that requesting you guys.
what is the exact path i can look for those. thanks
by devanars
Mon Aug 10, 2009 2:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Scheduler
Replies: 7
Views: 3065

I was also a sysadmin can you please explain where can i apply these. Thanks
by devanars
Mon Aug 10, 2009 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Scheduler
Replies: 7
Views: 3065

I do not have idea how to give those cros.sllow and at.allow and where.
by devanars
Mon Aug 10, 2009 1:53 pm
Forum: General
Topic: Seq Increment
Replies: 6
Views: 2017

Seq Increment

I have a requirement like id phone 001 9393 001 3232 002 3222 002 4332 002 2213 003 4567 ...... i need the target like id value phone 001 1 9393 001 2 3232 002 1 3222 002 2 4332 002 3 2213 003 1 4567 can anyone help me to how to implement this.
by devanars
Mon Aug 10, 2009 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Scheduler
Replies: 7
Views: 3065

Job Scheduler

not able to schedule jobs through datastage director giving an error like Error adding to schedule: at: 0481-108 You are not authorized to use the at command. (Command was: at -s 16:00 today ) (Data was: /opt/IBM/InformationServer/Server/Projects/DEV/dsr_sched.sh /opt/IBM/InformationServer/Server/Pr...
by devanars
Fri Jul 31, 2009 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increment of row number
Replies: 9
Views: 2848

Yes i am getting the max val of that col when executed but not in datastage source stage. server stage is working fine only the issue with parallel oralce stage.
by devanars
Fri Jul 31, 2009 1:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increment of row number
Replies: 9
Views: 2848

I am getting an eroor while trying to get max(col) through sql in source stage. is there any way to get the max value

Error executing View Data command:##E IIS-DSEE-TOPK-00007 15:19:17(010) <_PEEK_IDENT_> Input dataset does not have field:
by devanars
Thu Jul 30, 2009 1:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increment of row number
Replies: 9
Views: 2848

Earlier i did this sequence number by using stage variable in transformer.but now i need to take max value of that and need to process it again to another job/table.