Search found 4 matches

by Umbix0562
Wed Sep 30, 2015 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Connector - Bulk load. RDBMS 2500 error
Replies: 1
Views: 3094

Teradata Connector - Bulk load. RDBMS 2500 error

Hi I'm trying to run a parallel Job, Datastage 8.1, reading a flat file and loading a target teradata (v 14.00) table. In the teradata connector I use the Bulk method and Load type (that is...a fastload). The job ends with this fatal error: [IIS-CONN-TERA-005004] RDBMS code 25000: Error occurred dur...
by Umbix0562
Fri Dec 10, 2010 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetJobInfo
Replies: 0
Views: 1823

DSGetJobInfo

Hi everybody

I develop a Server routine capturing the start and the end timestamp of a Job received as parameter.

Why the statement "DSGetJobInfo(JobHandle, DSJ.JOBENDTIMESTAMP)" does not work? The routine's test return -5

Thank you very much in advance
by Umbix0562
Tue Nov 30, 2010 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference Between join, Lookup and merge
Replies: 6
Views: 14102

Hi I have some problem with join,lookup and merge stages. I am giving my requirement below. I have two seq files each of which are having one column with name ROWNUM, and in both the file data is 3 records like below 100 100 100 if i use join stage to join these two files and performing innerjoin a...
by Umbix0562
Tue Nov 30, 2010 4:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Retrieve the number of rows inserted or update in a Table
Replies: 4
Views: 7214

Retrieve the number of rows inserted or update in a Table

Hi I have a Job Parallel (datastage 8.1) writing in a table (Oracle 10g) by an upsert. I would to create e routine to capture some information as, for example, the number of inserted or updated rows, as they appears in the Job's Log. May anybody suggest me a solution? How can I retrieve these inform...