Search found 13 matches
- Wed Sep 13, 2006 12:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the resultset from Oracle stored procedure
- Replies: 4
- Views: 1579
Hi, We cant write embedded Sql in the stages( client requirement), Any Insert or Select should be done through stored procedure. So I need to call this procedure to get the resultset and map it to the output columns. We can call procedure and declare all the columns in the in the output tab of odbc ...
- Mon Sep 11, 2006 1:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the resultset from Oracle stored procedure
- Replies: 4
- Views: 1579
- Wed Aug 30, 2006 6:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the resultset from Oracle stored procedure
- Replies: 4
- Views: 1579
Getting the resultset from Oracle stored procedure
Hi, I have a oracle procedure which returns resultset to datastage using Ref. cursor. Understood from the earlier posts that STP stage does not support REf. cursor. Can I use ODBC/OCI stages to call that procedure and get the resultset data from that procedure? Is there any other way to get the resu...
- Fri May 19, 2006 3:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to capture the rejected Rows from Sybase BCP load
- Replies: 1
- Views: 1391
How to capture the rejected Rows from Sybase BCP load
Hi,
Is there any way to capture the rejected rows while loading to sybase using sybase BCP? I've tried using Link variables(REJECTED,REJECTED CODE....) in transformer for rejected link, but seems it doesn't work with BCP..
Any resolutiion is greatly appreciated.
Thanks and regards,
Jagadhish
Is there any way to capture the rejected rows while loading to sybase using sybase BCP? I've tried using Link variables(REJECTED,REJECTED CODE....) in transformer for rejected link, but seems it doesn't work with BCP..
Any resolutiion is greatly appreciated.
Thanks and regards,
Jagadhish
- Fri Apr 21, 2006 9:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: calling oracle SP which returns ref.cursor using STP
- Replies: 14
- Views: 8859
Hi rleishman Im trying out pipelined function. but while creating the function, CREATE FUNCTION my_func (p1 IN NUMBER) RETURN my_typ_ary PIPELINED AS rc SYS_REFCURSOR; t my_typ; BEGIN my_proc(p1, rc); t := my_typ(); LOOP FETCH rc INTO t.col1, t.col2; EXIT WHEN rc%NOTFOUND; PIPE ROW(t); END LOOP; END...
- Wed Apr 19, 2006 7:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: calling oracle SP which returns ref.cursor using STP
- Replies: 14
- Views: 8859
- Wed Apr 19, 2006 6:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: calling oracle SP which returns ref.cursor using STP
- Replies: 14
- Views: 8859
- Thu Apr 13, 2006 11:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: using STP stage with Sybase
- Replies: 3
- Views: 1384
using STP stage with Sybase
Hi, I'm using DAtastage 7.5.1.A, from documentation i can see that STP stage supports Sybase. I'm using STP stage to call a Sybase stored procedure, but while excecuting the job I'm getting the following error message, Stored_Procedure_0: ct_connect ServerNotFound Could anyone tell me reason for thi...
- Thu Mar 16, 2006 6:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling stored procedures
- Replies: 5
- Views: 1851
Hi Naveen, The error message I got was stored_proc..ODBC_0.DSLink4: DSD.BCIGetNext call to SQLFetch failed. SQL statement:select log_history_load from dual SQLSTATE=S1000, DBMS.CODE=14551 [DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-14551: cannot perform a DML operation inside a query ORA-065...
- Thu Mar 16, 2006 6:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling stored procedures
- Replies: 5
- Views: 1851
Calling stored procedures
Hi, I am using datastage version 7.1 We have a function with simple dml statement in oracle. CREATE OR REPLACE function log_history_load return number as begin insert into log_history values('user_name','status'); return 1; end; / I am calling this function in odbc stage using user defined SQL selec...
- Wed Mar 15, 2006 4:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: System variables
- Replies: 5
- Views: 4508
System environment variables
Thanks Arnd. Just to make things a little more clear, I have created a system environment variable in Windows (say, Variable Name = username and Variable Value = abc). Can I use this environment variable(i.e. username) in a DataStage job. From what I made out from your previous reply, you said that ...
- Wed Mar 15, 2006 4:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: System variables
- Replies: 5
- Views: 4508
System environment variables
Thanks Arnd. Just to make things a little more clear, I have created a system environment variable in Windows (say, Variable Name = username and Variable Value = abc). Can I use this environment variable(i.e. username) in a DataStage job. From what I made out from your previous reply, you said that ...
- Wed Mar 15, 2006 3:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: System variables
- Replies: 5
- Views: 4508
System variables
Hi Everyone,
Need some help with accessing system variables in datastage.
I know that we can access a pre-definded system variables using @LOGNAME, @PATH and so on.
But if I create a new system variable, how can I access that variable in datastage?
Need some help with accessing system variables in datastage.
I know that we can access a pre-definded system variables using @LOGNAME, @PATH and so on.
But if I create a new system variable, how can I access that variable in datastage?