Search found 35 matches

by htrisakti3
Mon Sep 26, 2005 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting first occurance of number from String
Replies: 14
Views: 8389

create this into a function & call it using your string as argument.. mystring is used for illustration: mystring = "ABCD4XXYYZ22Z33" temp1 = Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZ", " ", mystring) * temp1 is now:" 4 22 33" temp2=TRIM(temp1) *temp2 value: &qu...
by htrisakti3
Sun Sep 25, 2005 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: checking 'running' status
Replies: 9
Views: 3171

checking 'running' status

I have a main job-control/JC (multi-instance enabled) This main JC needs to call other Jobs that are NOT multi-instance. So, I put a logic as follows: - check status of Job_X - if it's running, loop & sleep 10seconds & check again - if Job_X not running, dsprepare & dsrunjob Job_X now, t...
by htrisakti3
Thu Sep 22, 2005 6:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Duplicates/Sorting question
Replies: 17
Views: 9145

hash may not work?

I saw that from your example, you need to keep "the most complete combination" ?? ie: NONE, 100, AUCTION -- this row is combination of 1,3,4,5 if you use hash (destructive write) i think you'll endup with NONE, ,AUCTION here's what I'd do: (dunno how to make drawing based on ascii, so bare...
by htrisakti3
Thu Sep 22, 2005 5:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control promote wrong job
Replies: 7
Views: 1913

Version Control promote wrong job

hi folks.. This is weird & 's been happening to me few times in the last week.. I use version control to promote ds jobs from Dev --> Test --> other env What I did & found is as follows: 1. Initialize job_A from dev --> version 2. promote job_A from version --> test I end up with job_A but i...
by htrisakti3
Wed Jul 06, 2005 12:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: run job once otherwise exit
Replies: 2
Views: 872

run job once otherwise exit

I need help to do the following: 1 job is to populate/refresh hash-files only 1x/day. Can I have a logic that checks the recency of the hash-files, if they're > 24hrs old, open DB connection & re-create them.. otherwise just exit from the job without openning DB. this is due to slow DB performan...