Search found 5168 matches

by kumar_s
Tue Sep 05, 2006 7:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 4456

LEN should retun 10 but have you tried LEN(TRIM())?
by kumar_s
Tue Sep 05, 2006 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Generating a Key between a Header and Detail Record
Replies: 4
Views: 1419

If you already have the detail record following the header record, what else you exactly looking for?
by kumar_s
Tue Sep 05, 2006 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to get the latest record from dimension table?
Replies: 3
Views: 1798

If timestamp or data shouldnt be used, then to fetch the latest information, you need to have another column which represents the version of the data. Or as simply utilizing the surrogate key as Ray suggested, which will increase sequentially.
by kumar_s
Tue Sep 05, 2006 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Datastage PX
Replies: 6
Views: 1411

Unix is also not a cheap product. Unless you go for Linux.
by kumar_s
Tue Sep 05, 2006 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 4456

If you intend to check Null you can optionally use LEN(TRIM(Link.Column))=0 which will give you the desired result.
The "00 00 hex" is configurable in Datastage Adminstrator client in Environmental variable.
by kumar_s
Tue Sep 05, 2006 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reg Contain Terminators
Replies: 2
Views: 1207

If that special character creates the line to break, i.e., which creates a new line character, the rest of teh columns might not get data. And hence you got the error.
By specifing explictly, datastage will wait till the specified character is met.
by kumar_s
Tue Sep 05, 2006 7:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer GUI problem in Windows XP Professional client
Replies: 4
Views: 1135

The usual problem. Update with lates service pack. If already been upgraded, search for a patch dsclient xps2.
by kumar_s
Tue Sep 05, 2006 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: kicking off sequences one after the other and knowing errors
Replies: 9
Views: 2050

There are lot of ways for all of your question. If you go through the pdf given for the JobSequence, you might understand that this can be done easily. If SeqA and SeqB are linked to a Sequencer with ALL mode and SeqAB continuing that, your requiement is solved. On failur you can use the notificatio...
by kumar_s
Sun Sep 03, 2006 10:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: writing into a unix file from datastage
Replies: 11
Views: 9118

Use dsjob command from unix prompt to get these details and divert it to a file.
dsjob -linkinfo/logsum/-logdetail/-lognewest...
can be used for this option.
by kumar_s
Sun Sep 03, 2006 10:39 pm
Forum: Site/Forum
Topic: Warehouse Architecture and Modelling Section
Replies: 5
Views: 3212

Perhaps the another General forum out of Datastage. Or New DataWarehouse forum for gateleys option.
by kumar_s
Fri Sep 01, 2006 12:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fetch job Stats
Replies: 8
Views: 2137

Kim has mentioned one way. You can get that from his signature link.
There are some other option from DSGetJobInfo funciton in datstage.
DSJ.JOBELAPSED
DSJ.JOBLASTTIMESTAMP
DSJ.JOBSTARTTIMESTAMP
You can also leverage the
dsjob -log
-logsum
-logdetail options for it.
by kumar_s
Thu Aug 31, 2006 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: writing into a unix file from datastage
Replies: 11
Views: 9118

There are various ways to achive this. Read the file using Execute command activity and pass the value of ReturnValue as parameter to the Notification stage.
by kumar_s
Thu Aug 31, 2006 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reject link
Replies: 7
Views: 2314

If your intention is to collect the records not equal to any of these 'u','i','d', have another condition in filter stage itself.
Else you can find one such scenario in vincents blog, use copy stage and enable the RCP to collect the sqlcode.
by kumar_s
Thu Aug 31, 2006 6:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Annotation Jobs
Replies: 2
Views: 633

If it is well designed, the annotation should give you the full detial of the job.