Search found 48 matches
- Tue Mar 31, 2015 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise stage in parallel mode?
- Replies: 4
- Views: 4195
i second that.. As a general rule, Datastage Enterprise Edition automatically combines pipelining, partitioning and parallel processing. The concept is hidden from a Datastage programmer. The job developer only chooses a method of data partitioning and the Datastage EE engine will execute the partit...
- Tue Mar 31, 2015 9:32 am
- Forum: General
- Topic: OPTION to parameterize different jobs in the Sequence JOB
- Replies: 1
- Views: 1707
OPTION to parameterize different jobs in the Sequence JOB
We have two versions of the code a generic version of the code already developed that applies across all clients (makes use of the generic stage) a traditional method specific for each client I developed. In the existing generic method the sequence job calls the file extraction job, followed by data...
- Fri Mar 27, 2015 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update Table NO RCP
- Replies: 6
- Views: 5407
- Fri Mar 27, 2015 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update Table NO RCP
- Replies: 6
- Views: 5407
- Thu Mar 26, 2015 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update Table NO RCP
- Replies: 6
- Views: 5407
- Thu Mar 26, 2015 12:57 pm
- Forum: General
- Topic: JobControl Job aborted
- Replies: 6
- Views: 3277
- Thu Mar 26, 2015 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update Table NO RCP
- Replies: 6
- Views: 5407
Update Table NO RCP
Source stage (Flat File): Target stage (ODBC Connector) Usage: Write mode = Update; Generate SQL = Yes; Table name = #target_table# NO RCP with this job.. I have the primary key I want to update on selected in the target ODBC connector stage which matches the primary key in the database table At run...
- Thu Mar 26, 2015 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parallel job reports failure (code 139)
- Replies: 8
- Views: 6259
- Thu Mar 26, 2015 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trailing characters. Cant get rid
- Replies: 8
- Views: 5896
- Mon Mar 23, 2015 3:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Warning: The DTS does not have a status link
- Replies: 6
- Views: 4511
- Mon Mar 23, 2015 3:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order of Columns in Select Query and metadata!!!
- Replies: 2
- Views: 2347
- Tue Mar 17, 2015 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TrimLeadingTrailing NULLS
- Replies: 9
- Views: 6906
- Tue Mar 17, 2015 1:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TrimLeadingTrailing NULLS
- Replies: 9
- Views: 6906
if lookup doesn't happen then the fields from that link are set to NULL with the Continue option. That is the null i am talking about In Transformer I am checking and if it is null then set the internal error code (300) else 0 before i check the null I am trimming the value coming in the gender fiel...
- Tue Mar 17, 2015 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TrimLeadingTrailing NULLS
- Replies: 9
- Views: 6906
- Tue Mar 17, 2015 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TrimLeadingTrailing NULLS
- Replies: 9
- Views: 6906
TrimLeadingTrailing NULLS
does TrimLeadingTrailing() remove nulls from lookup?? doing lookup upstream onb gender and if lookup fails then being set as continue. This means if lookup fails then the The fields from that link are set to NULL and Continues processing any further lookups before sending the row to the output link....