Search found 11 matches
- Thu Nov 18, 2010 4:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedures in Oracle connector stage
- Replies: 13
- Views: 20494
It does not help, i tried running this in a standalone job with only stored procedure stage. the error i got is Stored_Procedure_45: OCIAttrGet - Must be an anonymous pl/sql block being prepared. Stored_Procedure_45,0: Error occurred in call to ORPHCallActivePluginInitialize(). Stored_Procedure_45,0...
- Wed Nov 17, 2010 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedures in Oracle connector stage
- Replies: 13
- Views: 20494
- Wed Nov 17, 2010 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedures in Oracle connector stage
- Replies: 13
- Views: 20494
- Wed Nov 17, 2010 7:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedures in Oracle connector stage
- Replies: 13
- Views: 20494
- Wed Nov 17, 2010 6:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedures in Oracle connector stage
- Replies: 13
- Views: 20494
Stored Procedures in Oracle connector stage
Can we execute stored procedure from After SQL statement in oracle connector stage? I get a error when i run the same...The following SQL statement failed: EXEC DBMS_STATS.gather_table_stats('XYZ','TABLE_NAME',method_opt => 'for all columns size auto'). TABLE_NAME: [IIS-CONN-ORA-001003] The OCI func...
- Mon Aug 18, 2008 2:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Record count to be sent in Dssendmail subroutine
- Replies: 9
- Views: 4083
i need to send a mail to sourcing team, in the body of the mail i should mention 107 records have been rejected. this count 107 should be inserted in the body of the mail For sending the mail i am using Dssendmail routine in the afterstage subroutine In the Dssendmail routine inside the body of the ...
- Mon Aug 18, 2008 12:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Record count to be sent in Dssendmail subroutine
- Replies: 9
- Views: 4083
this is how i code in the afterstage subroutine From:abc@x.com\nTo:cba@x.com\nserver:x.com\nAttach:D:\Seq_reject.txt\nBody:%DSGetLinkInfo(DSJ.ME,DSJ.ME,DSJ.ME,DSJ.LINKROWCOUNT)% reject found \n%report% can we use the DsFunction inside the body of the Dssendmail subroutine, if yes is the syntax right...
- Sun Aug 17, 2008 12:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Record count to be sent in Dssendmail subroutine
- Replies: 9
- Views: 4083
Record count in Dssendmail
What have you tried? And define 'rejects' in this context as sequential files don't typically generate reject records. ... its not the reject comes out of seq file. its from the xfm stage where records are rejected with a constraint set in xfm stage. using @outrownum i can have the number of record...
- Sun Aug 17, 2008 11:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Record count to be sent in Dssendmail subroutine
- Replies: 9
- Views: 4083
Record count to be sent in Dssendmail subroutine
I would like to send a mail to sourcing team about rejects. I am using Dssendmail subroutine in the after subroutine stage(xfm stage). i need to include the no of records rejected in this routine to be sent out in the mail. My job design is src----xfm---seq file - - - - Reject seq file
- Tue Aug 12, 2008 3:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: conditional send mail
- Replies: 1
- Views: 1390
conditional send mail
i need to send mail notification only if some records (i.e reject count>0) are rejected in a particuar stage.
Currently i am using Dssendmail routine in transformer stage to send out a mail in the after stage subroutine.
Can some constraits be imposed for the after subroutine to initiate
Currently i am using Dssendmail routine in transformer stage to send out a mail in the after stage subroutine.
Can some constraits be imposed for the after subroutine to initiate
- Mon Aug 11, 2008 7:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: unable to execute 'Telnet Backup command'
- Replies: 1
- Views: 1484
unable to execute 'Telnet Backup command'
I am trying to backup the existng file in remote location, before sending the new file. I am using the Ftp plug in stage. I have set the following properties Backup file - Yes Telnet Backup commnad - mv a.log b.log move a.log b.log Also the file is in \ and not in any directory Director gives the fo...