However, be careful of the performance : if you have a huge number of lines
in your stream link, and for each line a lookup is done, your job can take
a lot of time to be executed.
I have succesfully used user-defined sql (as proposed by Ray) few months
ago, but it seems to me that, it works only if you put the seq.nextval as
the last column.
Kasia
At 02/03/2004 21:21, you wrote:
>Excellent!! I think this will work and gets me in the right direction.
>Thanks everyone for your help.
>
>-----Original Message-----
>From:
datastage-users-bounces@oliver.com
>[mailto:
datastage-users-bounces@oliver.com] On Behalf Of
>
Malathi_Vellanki@mckinsey.com
>Sent: Tuesday, March 02, 2004 1:59 PM
>To: DataStage Users Discussion List
>Cc: DataStage Users Discussion List;
datastage-users-bounces@oliver.com
>Subject: Re: Reference atlas.nextval from oracle
>
>
>
>
>
>
>
>How about using OCI stage to look-up/reference 'select atlas.nextval,1
>hardcoded from dual' as user defined query. 'hardcoded' can be joined to
>another hard coded value in transformer.
>
>
>
>
> Suresh Chilukuri
>
> Users Discussion List
> .state.nj.us> cc: (bcc: Malathi
>Vellanki/FIRNY/NorthAmerica/MCKINSEY)
> Sent by: Subject: Re: Reference
>atlas.nextval from oracle
> datastage-users-bounc
>
>
es@oliver.com
>
> 03/02/2004 01:02 PM
>
> Please respond to
>
> DataStage Users
>
> Discussion List
>
>
>
>
>
>
>
>
>
>I think you can use database triggers to generate sequence numbers.
>
>Robert Takkunen wrote:
>
> > Does anyone know of a good way to reference in the next value from
> > Oracle into a DataStage server job? We are building a database in
> > Oracle with DataStage and need to write the id's along with using
> > those id's as
>foreign
> > keys in other columns for tables in the same DataStage job.
> >
> > Thanks - Rob
> >
> > Rob Takkunen
> > International Decision Systems
> > Integrated Solutions Specialist
> > Direct: 612.851.3567
> > Mobile: 612.805.8826
> >
rtakkunen@idsgrp.com
> >
> > _______________________________________________
> > datastage-users mailing list
> >
datastage-users@oliver.com
> >
http://www.oliver.com/mailman/listinfo/datastage-users
>
>_______________________________________________
>datastage-users mailing list
>
datastage-users@oliver.com
>
http://www.oliver.com/mailman/listinfo/datastage-users
>
>
>
>_______________________________________________
>datastage-users mailing list
>
datastage-users@oliver.com
>
http://www.oliver.com/mailman/listinfo/datastage-users
>_______________________________________________
>datastage-users mailing list
>
datastage-users@oliver.com
>
http://www.oliver.com/mailman/listinfo/datastage-users
------------------------------------------------------------------------------
Kasia Lewicka
katarzyna.lewicka@cgey.com
ETL Team Leader
Business Intelligence / Business Solution Skill
Cap Gemini Ernst & Young France
phone +33 [0]5 56 46 72 85
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users