Search found 53125 matches

by ray.wurlod
Thu Nov 10, 2005 3:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uv command to create ds project
Replies: 27
Views: 11697

Code: Select all

INSERT INTO UV.ACCOUNT(@ID, PATH) VALUES ('ProjectName', '/dir/dir/projecctdir');

You need to be in the UV account and in the dssh shell (uvsh shell) to execute this command.
by ray.wurlod
Thu Nov 10, 2005 3:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row Count for Individual links
Replies: 3
Views: 2687

Link row counts are logged for all active stages in the "active stage finishing" messages in the job log.
by ray.wurlod
Thu Nov 10, 2005 3:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage upgrade 5.2 to 7.5 - Please help me
Replies: 5
Views: 1396

Make sure you have a good backup (readable) before you start. :wink:
by ray.wurlod
Thu Nov 10, 2005 3:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Differenc Math in Transformer
Replies: 8
Views: 2065

Search the Forum for a link to a paper called "Date Conversion Demystified" which is an easy introduction to date conversions.
by ray.wurlod
Thu Nov 10, 2005 3:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing DATASTAGE 7.5.1a where 7.5 EE exists
Replies: 4
Views: 1083

You can have them both installed, but you can only have one at a time running unless you do some configuration, such as changing the shared memory identifier prefix in one of the instances and increasing the kernel parameters for shared memory and semaphores (particularly) to double the recommended ...
by ray.wurlod
Thu Nov 10, 2005 3:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error writing to Teradata Enterprise Stage
Replies: 11
Views: 6431

Welcome aboard! :D Whoever creates the table, or someone with DBA privilege, can grant appropriate privileges to anyone else, such as the user ID under which DataStage jobs will connect to Teradata. You should make the user ID and password (and database name) job parameters, because they will be dif...
by ray.wurlod
Wed Nov 09, 2005 2:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Differenc Math in Transformer
Replies: 8
Views: 2065

The 'M' in 'DMY' is for a numeric month. You should be able to try a couple of difference things off the top of my head... Try "DDMBY2" as 'MB' is the abbreviated month name. Or just a "D2" all by itself, as the default format of 'D' is 'DD-MON-YYYY' and the two at the end tells it a two digit year...
by ray.wurlod
Wed Nov 09, 2005 2:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to use version controll in Datastage
Replies: 2
Views: 806

The Version Control manual takes you through all the steps in quite a clear fashion.
by ray.wurlod
Wed Nov 09, 2005 2:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating job from template
Replies: 6
Views: 2453

The problem I had was developers destroying the template jobs by opening them, developing in them, and clicking Save.

I maintain the templates on the shared drive using Notepad - a template is an XML-tagged DSX file.
by ray.wurlod
Wed Nov 09, 2005 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warnings from lookup against Teradata Enterprise Stage
Replies: 8
Views: 5517

If you have "disable combination" set to True, there is one player process per Orchestrate operator on each processing node mentioned in the configuration file. If you have "disable combination" set to False, then some player processes will manage more than one operator, so there will be fewer playe...
by ray.wurlod
Wed Nov 09, 2005 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lots of issues upgrading to DS 7.5.1A
Replies: 2
Views: 1063

2) Export bypasses the index because it selects all job names with which to populate the drop-down list.

The command is DS.REINDEX ALL
by ray.wurlod
Wed Nov 09, 2005 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need help to reuse reject datset of lookup
Replies: 4
Views: 2081

My suggestion was made in the absence of that new knowledge. If you use the Continue rule you could test the result of a lookup column, which should be null if the lookup failed. Make sure not to test a column that might actually return nulls. That is, the same technique as you might use in a server...
by ray.wurlod
Wed Nov 09, 2005 2:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter stage and dynamic file creation
Replies: 4
Views: 1748

My bad. Failed to take into account that the print was an awk print - that is, in an awk block. Come's from replying after my bed time.
by ray.wurlod
Wed Nov 09, 2005 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparse Lookup against DB2 ignores WHERE clause?
Replies: 11
Views: 5043

Go for the top. Sue the company. Oh, they don't exist any more. Shame.
by ray.wurlod
Wed Nov 09, 2005 3:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: undo DELETE VOC LOGIN
Replies: 5
Views: 1224

In case they wanted to put in other stuff for interactive processes.