Search found 53125 matches

by ray.wurlod
Wed Apr 01, 2009 11:53 pm
Forum: General
Topic: The file system is full
Replies: 2
Views: 4394

Welcome aboard.

"File system" here is the disk onto which you are writing the file. There simply is not enough room for it. The only remedies are to delete some unwanted things from that disk or write to a disk that has more free space.
by ray.wurlod
Wed Apr 01, 2009 8:25 pm
Forum: General
Topic: Import Table Definition (XML)
Replies: 0
Views: 969

Import Table Definition (XML)

A question about importing a table definition from an XSD. Is there any way to include the documentation attribute for each column (element) in the imported table definition? It seems a shame that, if a vendor has gone to all the trouble of documenting the schema fully, that documentation were not a...
by ray.wurlod
Wed Apr 01, 2009 6:58 pm
Forum: General
Topic: Issue with KeyMgtGetNextValue routine
Replies: 3
Views: 1537

Because, just like a sequence in - say - Oracle, what's stored in the sequence is the next available key value. Not the one you've just generated.
by ray.wurlod
Wed Apr 01, 2009 6:56 pm
Forum: General
Topic: Contextual Help (Help Button) doesn't work
Replies: 12
Views: 3034

Possibly related to this issue

Make sure you have access to this pathname on your Information Server server, and have credentials to use reporting.
by ray.wurlod
Wed Apr 01, 2009 4:01 pm
Forum: General
Topic: InfoSphere v8.1 Training Course / Certification???
Replies: 5
Views: 1749

Go to the Information on Demand 2009 Conference in late October.

There they offer a "certification preparation" class plus you can take the exam for free.
by ray.wurlod
Wed Apr 01, 2009 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting type conversion warning when transforming data
Replies: 1
Views: 885

The number of reject datasets "0" is less than the number of input datasets "1".
Search DSXchange for this exact message. Or just the first five words of it.
by ray.wurlod
Wed Apr 01, 2009 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating XML files
Replies: 4
Views: 1646

Ernie, can you cite any worthwhile "XML for Dummies" reference?
by ray.wurlod
Wed Apr 01, 2009 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Convert string to numeric value
Replies: 2
Views: 3354

What U has ought not to concern srai. The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of English on DSXchange, because even good English is difficult enough for non-native speakers, and also because DSXchange is n...
by ray.wurlod
Wed Apr 01, 2009 3:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Reference input
Replies: 1
Views: 891

There are two kinds of input link, stream (get next row) and reference (get row by key). One SQL statement relates to the former, the other to the latter and contains a WHERE clause that refers to the key column(s).
by ray.wurlod
Wed Apr 01, 2009 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Special character issue in Sybase OCI stage
Replies: 1
Views: 1737

Try declaring the field to be VarChar(512). (If Oracle, use 768).
by ray.wurlod
Wed Apr 01, 2009 3:27 pm
Forum: General
Topic: Can we read a binary file in DataStage.
Replies: 4
Views: 6995

Are you on the same project as theppaks, who posed the very same question in the QualityStage forum?
by ray.wurlod
Wed Apr 01, 2009 3:25 pm
Forum: General
Topic: Getting current value from SDKSequences
Replies: 2
Views: 1083

Or you can simply use a Hashed File stage pointed at SDKSequences with "made up" metadata - one VarChar (key) column and one integer column.
by ray.wurlod
Wed Apr 01, 2009 3:23 pm
Forum: General
Topic: check the presence of required fields and format of fields
Replies: 5
Views: 1704

Use stage variables for the target of your parsing, and detect whether each is populated.
by ray.wurlod
Wed Apr 01, 2009 3:21 pm
Forum: IBM QualityStage
Topic: Extract Binary Data
Replies: 3
Views: 1823

There are many possibilites. Probably the easiest is to use a Complex Flat File stage.
by ray.wurlod
Wed Apr 01, 2009 2:02 am
Forum: IBM QualityStage
Topic: Extract Binary Data
Replies: 3
Views: 1823

Yes, DataStage can do that. Where are the binary data?