Search found 53125 matches

by ray.wurlod
Mon Jan 05, 2015 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the syntax to not_nullable column using Modify Stage
Replies: 4
Views: 1659

There's no syntax that can magically change the source from non-nullable to nullable in a Modify stage. You can, however, specify that the target is nullable.

Code: Select all

CompanyIdentification:nullable string[10]= substring[1,10](MyIdentification)
by ray.wurlod
Mon Jan 05, 2015 3:28 pm
Forum: General
Topic: MySQL ODBC Connection Issue - "SQLSTATE = IM003"
Replies: 9
Views: 10737

Are these entries identical to those on the production server?
by ray.wurlod
Sun Jan 04, 2015 4:03 pm
Forum: General
Topic: ERROR:80011:Failed to open project
Replies: 12
Views: 4195

You need to ensure that the value passed through $DS_PROJECT is correct: correctly spelled, correctly cased.
by ray.wurlod
Fri Jan 02, 2015 4:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of readers value in sequential file stage
Replies: 7
Views: 2171

Notice that the property name is actually Number of Readers Per Node (emphasis mine).
by ray.wurlod
Fri Jan 02, 2015 4:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Charts & Graphics
Replies: 4
Views: 3459

In a word, NO.

DataStage is an ETL tool, it has no business in the presentation layer.
by ray.wurlod
Fri Jan 02, 2015 4:45 am
Forum: IBM QualityStage
Topic: NUMERIC Comparison Takes Too Long
Replies: 7
Views: 4466

Can you take a look at the job log to see whether any particular process takes a very long time? Perhaps enable some of the reporting environment variables (especially APT_PLAYER_TIMING)?
by ray.wurlod
Wed Dec 31, 2014 5:30 pm
Forum: General
Topic: SRVE0255E: A WebGroup/Virtual Host to handle localhost:9080
Replies: 10
Views: 4570

Check the response file or install log to ascertain whether your site is using a non-default port number (that is, something other than 9080).
by ray.wurlod
Sat Dec 27, 2014 2:48 pm
Forum: General
Topic: Finding a Input Dataset used in jobs
Replies: 9
Views: 4104

The table structures (and column names) have changed since version 7.x.
by ray.wurlod
Fri Dec 26, 2014 6:01 pm
Forum: General
Topic: Finding a Input Dataset used in jobs
Replies: 9
Views: 4104

DSguru2B wrote:Use the following query at the uv account or admin command, once logged into your project.
This is not a suitable answer for version 7.x. Also it would not work in the UV account.
by ray.wurlod
Mon Dec 22, 2014 1:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi instance job
Replies: 7
Views: 2742

You have to find the previous run FOR THAT INVOCATION. If there have been many runs with different invocations that particular previous run may already have been purged.
by ray.wurlod
Mon Dec 22, 2014 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion to Timestamp
Replies: 6
Views: 2884

What format of timestamp is your Teradata instance expecting?
by ray.wurlod
Fri Dec 19, 2014 12:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: You say EBCDIC, I say ASCII, let's call the whole thing off
Replies: 6
Views: 2433

If NLS is enabled, parallel jobs use UTF-16 internally.

UTF-16 shares code points 0 through 127 with ASCII. Most implementations of UTF-16 share code points 0 through 255 with "extended", or 8-bit, ASCII.

The story is different for server jobs.
by ray.wurlod
Fri Dec 19, 2014 12:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hash partition with difference in numeric key columns
Replies: 2
Views: 1858

That said, it is working as documented.
by ray.wurlod
Fri Dec 19, 2014 12:47 pm
Forum: General
Topic: Failed to invoke GetRuntime using phantom process helper
Replies: 2
Views: 2262

Specifically, the folder H:\Datastage_Projects\EIS_Ent/RT_STATUS1554 and its contents.
by ray.wurlod
Thu Dec 18, 2014 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenate the rows
Replies: 5
Views: 3004

Looks like you just want to accumulate source columns into a single row until the key changes?

Is the number of source rows per key constant or variable?