DSXchange

Looks like cursor output is not available for Oracle.

CursorOutput.
The stage returns data or a result set from the stored procedure. The stage must contain an output link. CursorOutput is available only for DB2 and SQL Server.

Thanks

Hi All,

Is it possible get the output from Ref cursor used in oracle store procedure in datastage ?I tried searching the forum but did not find much information .

I am calling stored procedure from Datastage and store procedure returns the multiple rows via ref cursor .


Thanks

Hello, I am new to XML stage in datastage. I am unable to get the desired output using XML output stage input data fundname|symbol ABC|1 XYZ|1 I am getting below output: <INV> <fundname>ABC</fundname> <fundname>XYZ</fundname> <symbol>1</symbol> </INV> But desired output is : <INV> <fundname>ABC</fun...

Ernie,
Is there way to import Namespace from XML file ?Source system is not providing any schema for the input XML file .As you said I am also 100% sure its either xpaths or Namespace issue.

Hi All, Job Design: I am getting text file with Col 1,col2,col3,XML_CLOB: XML input does not provide/parse correctly and hence no output data File ->Filter ->XML_inputStage->Dataset: Since Source system is not providing XSD so I am typing in the namespace declarations(transformation setting) and xpa...

Something strange happening.

If I change the upsert mode to update only the jobs runs 20k rps but with upsert mode set to update and insert then the job runs with 2k rps .

Did anyone faced the some problem ?

Thanks,

Kapil

I am working with DB2 DBA and he told me due to some problem the run stat script which runs every week was not finishing completely. I will run my job once load stats finishes. UPDATE ODS.ADDRESS SET PRIM_TBL_CD = ORCHESTRATE.PRIM_TBL_CD, SCND_TBL_CD = ORCHESTRATE.SCND_TBL_CD, DT_LOAD = ORCHESTRATE....

Here is job design. db2ent(Stg) ----> db2ent(Target) The source has 2 Million records and target has 8 Million. Write method is Upsert(auto generated update and insert) . There are few inserts(1000 may be) and more updates. The target table doesn't have any primary keys but it has unique index on co...

Thank you Craig and ArndW for the reply. I will make sure next time to post in the correct forum

Hi,
How can we rename folders in the repository in data stage 7.5.2?In the Data stage 8.x we can right click on the folder in the repository and rename the folder.

Thank,

yes it not working for regular developer ID.

Command utility in data stage administrator is grayed out.It is enabled by administrator but still it is grayed out.Please help what other changes needed to enable it.

How do i suppress XML declaration in the XML output file.
my job design i am reading from the sequential file and outputting into XML file using XML output stage.
i want to remove "","<?xml version="1.0" encoding="UTF-8"?> from my XML output file.

i am getting the output message as <parentinfo> <personid>1 </personid> <name> <fn>micheal </fn> <ln> johnson </ln> </name> <age>40 </age> </parentinfo> <relatedstudent> <stud_FN>james </stud_FN> <stud_LN>johnson </stud_LN> </stud_FN> </relatedstudent> <parentinfo> <personid>2 </personid> <name> <fn...