DSXchange

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 ...

Hi,

I have been treing the same(using odbc stage), but could not make it.

How I can map the cursor resultset to columns defined in the odbc stage?

Any help is greatly appreciated.

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...

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

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...

Hi,

The SP is already existing one, we cant change it. Can I use shell script to call that procedure process the result set...

please give your inputs.

Hi,

Thanks for your information. If STP doesn't support Ref. cursor, is it possible to call that procedure using routine and get the result set?
Any help is greatly appreciated....


Thanks and regards,
Jags.

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...

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...

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...

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 ...

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 ...

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?