Search found 7 matches

by bharatagnihotri
Mon Mar 01, 2010 9:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with order of primary keys
Replies: 4
Views: 2071

Thanks

[quote="chulett"]No, there's no rule as to where or in what order they need to be declared in the table. That's a people thing. ...[/quote] Thanks for your reply, just one more thing, will it impact the job (if we don't add this key) in any way i.e. will it require job change or anything o...
by bharatagnihotri
Mon Mar 01, 2010 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with order of primary keys
Replies: 4
Views: 2071

Issue with order of primary keys

DS - 7.5.1 (DB2 API and EE stages) Is there any know issue with the sequence of primary keys for a DB2 table (DB2 API or EE stages) ? i.e. say we have a table T1 with following structure: Collumn Primary Key C1 Y C2 N C3 N A datastage job is created for this table structure. After this now the table...
by bharatagnihotri
Wed Oct 25, 2006 12:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is VOC? What is it used for?
Replies: 10
Views: 4953

Re: What is VOC? What is it used for?

Good Old C days!! VOC is all about pointers .. The concept of VOC holds quiet good in server edition especially with HASH files.. As you know in case of Hash files the pointers are kept and are stored... That is one of reasons when people clean up their disk space and delete hash file directories al...
by bharatagnihotri
Wed Oct 25, 2006 12:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rule of Thumb on Runtime Column Propagation
Replies: 15
Views: 14070

Re: Rule of Thumb on Runtime Column Propagation

I do agree with Arnd on this one!! I am a frequent user of RCP and it works quiet smooth with the concept of generic jobs. Especially when we want to built something with varying Meta data! For example say we have a job, which combines or compares data between two inputs. But what meta data will be ...
by bharatagnihotri
Wed Oct 25, 2006 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warnings with join
Replies: 16
Views: 5228

Re: warnings with join

What is the DS version you are working on ?
by bharatagnihotri
Thu Dec 30, 2004 2:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Derriving difference of two timestamps
Replies: 3
Views: 2178

Thanks, But in the meanwhile we got some other solution to achieve the same. We defined a stage variable and defined it as decimal , the derivation of which is as follows.. DFloatToDecimal(SecondsSinceFromTimestamp(INPUT_TIMESTAMP,CURRENT_TIMESTAMP)) It is working fine....... "FEEDBACK IS THE B...
by bharatagnihotri
Wed Dec 29, 2004 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Derriving difference of two timestamps
Replies: 3
Views: 2178

Derriving difference of two timestamps

Hi,

We are trying to derive difference between two timestamps(in hours)

Any ideas are welcome