Search found 53125 matches

by ray.wurlod
Wed Apr 21, 2010 9:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cleanup Repository
Replies: 4
Views: 1610

Not really. The command line has no way of determining "unused".
by ray.wurlod
Wed Apr 21, 2010 9:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with creation of score file
Replies: 5
Views: 3086

Interesting - it was 775 a few posts back. Have you tried running the job since the permissions were changed?
by ray.wurlod
Wed Apr 21, 2010 9:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Websphere 6 - Does not start (Java not recognized command)
Replies: 4
Views: 3725

You need to find out who "disappeared" it (since clearly it has been there previously, because things worked). Can it be restored from system backups?

Another thought - should the bat file be executing javaw rather than java?
by ray.wurlod
Wed Apr 21, 2010 9:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrade Websphere Application Server
Replies: 2
Views: 1654

I will, then.

Version 6.1.0.27 is the ONLY version of WAS that supports Information Server version 8.1 in a 64-bit operating system environment.
by ray.wurlod
Wed Apr 21, 2010 9:02 pm
Forum: General
Topic: Sequential File Stage and file name variable
Replies: 8
Views: 2627

Code: Select all

Field(InLink.FileNameColumn, "/", Count(InLink.FileNameColumn, "/") + 1, 1)
Maybe you can mark this thread as Resolved?
by ray.wurlod
Wed Apr 21, 2010 8:58 pm
Forum: General
Topic: CheckSum() Function
Replies: 11
Views: 7878

Strange, that's the first time you've mentioned that. I have a vague recollection that UniVerse used to include a CRC function of some kind, but CRC-16 is not a complex algorithm (search the internet) so you would be able to create your own quite easily - even in stage variables in a Transformer sta...
by ray.wurlod
Wed Apr 21, 2010 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter Stage - Custom function
Replies: 4
Views: 3130

Move the trim to an upstream Transformer or Modify stage.

Of course, if you're going to use a Transformer stage, you can eliminate the Filter stage and use constraint expressions in the Transformer stage instead.
by ray.wurlod
Wed Apr 21, 2010 1:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with creation of score file
Replies: 5
Views: 3086

Under what user ID does the job run? To which groups does this user ID belong? Is that the group associated with /tmp?

It's more usual to have /tmp writable by everyone.
by ray.wurlod
Wed Apr 21, 2010 1:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Job not running
Replies: 6
Views: 2162

Is this repeatable? Or could it have been a transient glitch in the network?
by ray.wurlod
Wed Apr 21, 2010 1:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Bulk Load Stage
Replies: 3
Views: 2551

Use the bulk load option in DB2 Connector or DB2 Enterprise stage.
by ray.wurlod
Wed Apr 21, 2010 1:53 am
Forum: General
Topic: CouchDB
Replies: 2
Views: 1602

Welcome aboard.

An internet search suggests that there's a REST API, ODBC access and JDBC access to CouchDB, so there are lots of ways that you could deploy DataStage to connect to CouchDB.
by ray.wurlod
Tue Apr 20, 2010 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date dimension in data warehouse
Replies: 2
Views: 1527

I typically use a server job (with a Transformer stage as a row generator) or a parallel job (with a Row Generator stage) to generate the dates and surrogate keys. Attributes in a date dimension vary with different customers' requirements. Typically they will include: date components (day, month, qu...
by ray.wurlod
Tue Apr 20, 2010 4:19 pm
Forum: General
Topic: CheckSum() Function
Replies: 11
Views: 7878

Why should every checksum function generate the same value? There's no single industry-standard algorithm out there. Checksum can do whatever its author likes, as it doesn't need to be reversible, only repeatable. Encryption, on the other hand...
by ray.wurlod
Tue Apr 20, 2010 4:15 pm
Forum: General
Topic: finding delimiters
Replies: 7
Views: 2037

Much easier in server job or using BASIC Transformer stage in parallel job.

Code: Select all

MatchField(InLink.TheColumn, "0N1X0N0X", 2)