Search found 53125 matches

by ray.wurlod
Fri Oct 23, 2009 10:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file stage bug
Replies: 2
Views: 893

I have not seen/experienced the behaviour you describe. Does it happen on all clients at your site, or just yours?
by ray.wurlod
Fri Oct 23, 2009 10:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Quote character within a quoted text field
Replies: 6
Views: 1580

In which case set the Quote character in the format to none.
by ray.wurlod
Fri Oct 23, 2009 10:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file read
Replies: 4
Views: 1329

Double click on the row number in the Columns grid for a column definition that is nullable. Find the Null Field Values in the available properties to add when the Nullable folder is selected.
by ray.wurlod
Fri Oct 23, 2009 10:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are getting ended before the start time of the Job.
Replies: 7
Views: 2210

Only the conductor node does logging. Can we please see event detail for events 144587 and 144588, which is where the time slip has actually occurred?
by ray.wurlod
Fri Oct 23, 2009 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert error while loading the timestamp data
Replies: 4
Views: 2481

Re: Insert error while loading the timestamp data

deesh wrote:Datastage taking as binary( 8 )
What precisely do you mean by this?
What data type is reported when you import the table definition using the orchdbutil facility?
by ray.wurlod
Fri Oct 23, 2009 10:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Recursive Routine
Replies: 4
Views: 2172

Indeed. There is no need for recursion. A single call would remove all the numbers generated as the list index variable's value.
by ray.wurlod
Fri Oct 23, 2009 10:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to connect to Host: project:UV
Replies: 6
Views: 3182

Look at line #4 of the dsenv in the initiating post in this thread. ************* ORACLE_HOME=/app/oracle; export ORACLE_HOME TNS_ADMIN=/app/oracle/network/admin; export TNS_ADMIN LD_LIBRARY_PATH=/app/oracle/lib; export LD_LIBRARY_PATH PATH=$PATH:/usr/bin:/app/oracle/bin; export PATH *************
by ray.wurlod
Fri Oct 23, 2009 10:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IBM infosphere datastage
Replies: 1
Views: 990

No idea. Have you tried it?

Given how long Windows 7 has been generally available (one day as I post this) I doubt it, and can guarantee that IBM will not have certified their products on Windows 7 thus far.
by ray.wurlod
Fri Oct 23, 2009 10:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MetaData mismatch error
Replies: 2
Views: 1371

Not really. You could export the project and do a global search and replace, but you need to be aware in this case that the SQL type is stored as an enumerated value. Are you using imported table definitions?
by ray.wurlod
Fri Oct 23, 2009 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to connect to Host: project:UV
Replies: 6
Views: 3182

This statement in dsenv destroys pre-existing shared library search list.
LD_LIBRARY_PATH=/app/oracle/lib; export LD_LIBRARY_PATH


It should read:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/app/oracle/lib; export LD_LIBRARY_PATH
by ray.wurlod
Fri Oct 23, 2009 10:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Recursive Routine
Replies: 4
Views: 2172

That and do something that will allow you to exit, such as using (Counter + 1) in the recursive call. Otherwise you appear to be calling the routine an infinite number of times with Counter set to 200.
by ray.wurlod
Fri Oct 23, 2009 10:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can not get exclusive access to log for Job "jobname&qu
Replies: 4
Views: 1594

The "someone" might even be you, if you have Director open on the same job.
by ray.wurlod
Fri Oct 23, 2009 10:31 am
Forum: IBM QualityStage
Topic: Matching MULT_UNCERT
Replies: 3
Views: 1708

Try using a CHAR match. I suggest this because your requirement is that the words must be the same. An upstream Standardization will have placed main name and first name into the correct buckets, overcoming the order problem, and generated the NYSIIS value on which you're blocking.
by ray.wurlod
Fri Oct 23, 2009 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file read
Replies: 4
Views: 1329

Have you set a Null Field Value property for each of these fields? For example if you have set ten spaces as the Null Field Value of a Char(10) field, then the import operator will convert this to NULL.
by ray.wurlod
Fri Oct 23, 2009 12:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are getting ended before the start time of the Job.
Replies: 7
Views: 2210

Can you please show the Event ID and Timestamp of all 15 events in the job log?