Search found 42189 matches

by chulett
Sat Aug 16, 2008 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to run a job or sequencer in unix
Replies: 5
Views: 1708

Read the guides Ray mentioned, it is fully documented there. You can also just type 'dsjob' at the command line and get normal usage information like any other command. Lastly, search the forums.
by chulett
Fri Aug 15, 2008 9:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup logic
Replies: 4
Views: 1603

He did. You looking for lotta bit detail?
by chulett
Fri Aug 15, 2008 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove Duplicate Error
Replies: 12
Views: 5689

Type: Fatal
Event: APT_CombinedOperatorController,0: Fatal Error: Tsort merger aborting: Scratch space full
by chulett
Fri Aug 15, 2008 2:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: function for extcting the middle part of the field
Replies: 2
Views: 1171

The substring operand is square brackets using FieldName[start position, length] notation.
by chulett
Fri Aug 15, 2008 2:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: BLOB Data
Replies: 19
Views: 12167

Valid for Server jobs or just Parallel ones?
by chulett
Fri Aug 15, 2008 2:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job parameter in Stored procedure.
Replies: 12
Views: 3931

That could very well be, considering it doesn't just give some sort of "invalid userid/password" response but instead falls over dead. Keep in mind the original question was "can we use job parameters in the SP stage" which the answer is still an emphatic yes. The issue of using User Defined Environ...
by chulett
Fri Aug 15, 2008 1:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job parameter in Stored procedure.
Replies: 12
Views: 3931

chulett wrote:Then I would assume your environment variables are not correct in the job. How exactly are they defined and how did you set them in the job?
by chulett
Fri Aug 15, 2008 11:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About MVS edition
Replies: 7
Views: 2343

How would you do it without DataStage?
by chulett
Fri Aug 15, 2008 11:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 2 Char year - YY Conversion
Replies: 9
Views: 3794

ArndW wrote:the Server equivalent setting of the CENTURYPIVOT uvconfig parameter
by chulett
Fri Aug 15, 2008 11:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job parameter in Stored procedure.
Replies: 12
Views: 3931

Then I would assume your environment variables are not correct in the job. How exactly are they defined and how did you set them in the job?
by chulett
Fri Aug 15, 2008 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null Field in Fixed Width Sequential File
Replies: 5
Views: 2544

What did you specify as the Null Field Value?
by chulett
Fri Aug 15, 2008 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Statistics in designer With Oracle database
Replies: 4
Views: 1849

If the job runs successfully, what 'Oracle connection problem' could you be having? Post your job design, listing all stages in it, so we know what other stages are in play.
by chulett
Fri Aug 15, 2008 6:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Comparison of number of input rows vs number of output rows
Replies: 3
Views: 1084

You could also check this after job (either literally or in the after job section of the current job) using the DSGetLinkInfo function and comparing the link row counts in question.
by chulett
Thu Aug 14, 2008 7:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exponential number conversion
Replies: 2
Views: 2727

Search the forums for 'exponent', this has been discussed before. From what I recall, it expects the 'e' to be in upper case to be recognized but a search should turn up the details.
by chulett
Thu Aug 14, 2008 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS Mapping Warning/error
Replies: 12
Views: 4126

How is any of this helping? As Ray notes, there's nothing in the record being shown here with a byte value over 7F so this is all perfectly normal boring text. And the semi-colons you were worried about in the first post are not an issue either. What happened to dumping the record being complained a...