DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 17, 2004 7:32 pm Reply with quote    Back to top    

how to call oracle pl/sql sequences in data stage.

_________________________________________________________________
Stay informed on Election 2004 and the race to Super Tuesday.
http://special.msn.com/msn/election2004.armx

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 17, 2004 10:17 pm Reply with quote    Back to top    

hi

In an OCI stage, go to output tab in that you will
find user-defined sql. Write SQL in the Before tab.

Ex. select Nextval. from dual.

mahesh
mgotur_mca@yahoo.com















--- indumathi venketapathi
wrote:
> how to call oracle pl/sql sequences in data stage.
>
>
_________________________________________________________________
> Stay informed on Election 2004 and the race to Super
> Tuesday.
> http://special.msn.com/msn/election2004.armx
>
> _______________________________________________
> datastage-users mailing list
> datastage-users@oliver.com
>
http://www.oliver.com/mailman/listinfo/datastage-users


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 9:59 am Reply with quote    Back to top    

have you read your manual yet

indumathi venketapathi wrote:

> how to call oracle pl/sql sequences in data stage.
>
> _________________________________________________________________
> Stay informed on Election 2004 and the race to Super Tuesday.
> http://special.msn.com/msn/election2004.armx
>
> _______________________________________________
> 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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 1:40 pm Reply with quote    Back to top    

Sequences are not part of PL/SQL. They are independently created objects in the Oracle database.

You invoke them from DataStage the same way you invoke them anywhere else, by referring to them in an SQL statement.

You may need to switch from generated to user-defined SQL to do this.
For example, you want to insert a row containing four columns, the first of which is to have its value obtained from a sequence.

Your job design has THREE columns on the input link to the stage (you do not supply a value from the job for the sequenced column).

Your SQL will have the appearance
INSERT into tablename(col1, col2, col3, col4) VALUES (seqname.NEXTVAL, :1, :2, :3);

The parameter markers refer to the three columns delivered from your DataStage job.

----- Original Message -----
From: "indumathi venketapathi"
Date: Wed, 18 Feb 2004 01:32:43 +0000
To: datastage-users@oliver.com
Subject: Sequences

> how to call oracle pl/sql sequences in data stage.
>
> _________________________________________________________________
> Stay informed on Election 2004 and the race to Super Tuesday.
> http://special.msn.com/msn/election2004.armx
>
> _______________________________________________
> 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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours