Search found 53125 matches

by ray.wurlod
Sat Apr 09, 2011 4:17 pm
Forum: General
Topic: Datastage Admin ,the things need to know
Replies: 5
Views: 2774

See if you can find the IBM class (I think it's DX337) that covers DataStage Administration for version 7.
by ray.wurlod
Fri Apr 08, 2011 5:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file stage using schema file
Replies: 5
Views: 7843

Your Sequential File stage used for writing does not have Null Field Value property in the Format or Columns tab, but your design includes at least one column marked as nullable.
by ray.wurlod
Fri Apr 08, 2011 5:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSR.ADMIN error
Replies: 8
Views: 3637

Write failure from DSR.ADMIN is almost always caused by the executing user not having write permission to one of the files in the project, typically this is the DSParams file.
by ray.wurlod
Fri Apr 08, 2011 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to know about the scratchdisk ?
Replies: 3
Views: 1950

Some of the early gramophone disks are a bit scratchy. Particularly the shellac disks and the 78rpm ones.
by ray.wurlod
Fri Apr 08, 2011 4:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting in datastage 8.0.1
Replies: 2
Views: 2149

This information also appears in the status bar when you're selecting objects to be exported. "Read only" objects are those that are installed into every project, such as stage types and example routines and table definition. By default they're not included in any export to keep the export...
by ray.wurlod
Fri Apr 08, 2011 4:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How is data in a Dataset stored
Replies: 2
Views: 2003

Data are stored in Data Sets in the same way that they are stored in memory (the operator to read or write a Data Set is copy ). Details are not specifically in the public domain but may be inferred from information in Chapter 2 of the Parallel Job Developer's Guide and in the DataStage Programmer's...
by ray.wurlod
Fri Apr 08, 2011 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use Modify Stage ?
Replies: 2
Views: 6093

Vincent McBurney has also published a blog on the Modify stage at IT Toolbox
by ray.wurlod
Fri Apr 08, 2011 4:48 pm
Forum: General
Topic: Rgarding 39125 Issue in datastage
Replies: 8
Views: 3398

There is NOTHING that will cause VOC etc to be "deleted automatically". Start by finding what's deleting them. Then prevent that from happening. After that, post back that you're ready to progress.
by ray.wurlod
Fri Apr 08, 2011 4:42 pm
Forum: General
Topic: Largest Datastage site by data volume and
Replies: 2
Views: 1558

There's quite a few large, but non-grid, sites out there. Are you interested in these too?
by ray.wurlod
Fri Apr 08, 2011 4:38 pm
Forum: Enhancement Wish List
Topic: Job is being accessed by another user
Replies: 1
Views: 7791

Version 8 not only gives you the session ID that owns the lock, but also allows you to open the job design read-only while it's still locked for editing by the other user.
by ray.wurlod
Thu Apr 07, 2011 8:48 pm
Forum: General
Topic: I need a help to pass Invocation ID at run time to a Sequenc
Replies: 4
Views: 2299

You seem a little confused about how to invoke multi-instance jobs. "StartJob", for example, is a constant. Also, the invocation ID follows, rather than precedes the job name. Best practice is to determine the sequence's invocation ID (probably in a routine activity) and pass that to the J...
by ray.wurlod
Thu Apr 07, 2011 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file read running if the wrong delimeter
Replies: 6
Views: 5226

My guess is that it would read the entire line into the first field, if there are no commas in the line but your metadata prescribe comma as the field delimiter.
by ray.wurlod
Thu Apr 07, 2011 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server and Datastage sorting
Replies: 0
Views: 2236

Sorting order under NLS is governed by the COLLATE category of the locale.
by ray.wurlod
Thu Apr 07, 2011 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to do a COMPUTE STATISTICS with Oracle Connector Stage
Replies: 3
Views: 2164

I'm sure they'd post it if they do, next time they log in.
by ray.wurlod
Thu Apr 07, 2011 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restoring entry in VOC
Replies: 5
Views: 3050

You don't need to set a pointer to UV VOC. You should always reinstate records into VOC from NEWACC.

Code: Select all

COPY FROM NEWACC TO VOC 'LIKE'