Search found 53125 matches

by ray.wurlod
Sun Sep 23, 2007 4:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Monitor and Performance Statistcs not displaying
Replies: 1
Views: 894

Is the job monitor application actually running? Search for JobMonApp.
by ray.wurlod
Sun Sep 23, 2007 4:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About the Filter Stage
Replies: 4
Views: 1918

Welcome aboard.

Why not try it, or look in the on-line help or in the Parallel Job Developers Guide (the chapter on the Filter stage)?
by ray.wurlod
Sun Sep 23, 2007 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pivoting data in rows to column
Replies: 9
Views: 19789

Procedural Note
We don't hijack threads. A new topic requires a new thread, in the appropriate forum.
by ray.wurlod
Sat Sep 22, 2007 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Document or reading materials on DS EE
Replies: 5
Views: 1759

DataStage development is a skill. Please do not rely upon theoretical learning - it's just not enough - you have to get hands-on experience. If you have access to a DataStage clients, you have all the manuals. Find them in C:\Program Files\Ascential\DataStagex.x.x\Docs where x.x.x is the DataStage v...
by ray.wurlod
Sat Sep 22, 2007 2:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: EBCDIC file with \307 delimeter
Replies: 3
Views: 2543

You dou't have to type them in if you can import them from somewhere, such as an Oracle table or a text file. But there is no facility for reading a "metadata file" of the kind you describe. You can enter a three digit decimal field separator - read the on-line help (you can also enter it in hexadec...
by ray.wurlod
Sat Sep 22, 2007 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: EBCDIC file with \307 delimeter
Replies: 3
Views: 2543

Match the data types to the column names. The field delimiter goes in to the Sequential File stage, but must be given in decimal (that is, 199 in your example).
by ray.wurlod
Sat Sep 22, 2007 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Debugging Phantom Error
Replies: 21
Views: 6122

Should have been DSD_BP in the VLIST command.
by ray.wurlod
Sat Sep 22, 2007 6:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file stage-Active or passive stage?
Replies: 7
Views: 2612

Applying a hashing algorithm does not change the data; it only locates a key in one of a finite number of groups (pages). Most (if not all) passive stages are capable of destructive overwrite; this is not a change to the record being processed.
by ray.wurlod
Sat Sep 22, 2007 12:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data type mismatch.
Replies: 3
Views: 1485

I am certainly surprised to see no record schemas in the generated OSH. It was these I was hoping to use to shed some light on where the data type mismatch may have occurred. Did you edit them out? If so, please inspect them and identify whether there is a type mismatch between any two virtual Data ...
by ray.wurlod
Sat Sep 22, 2007 12:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequential File
Replies: 22
Views: 3256

You failed to tell the tr command which file to process and where to send the output. That's why it failed. Arnd's approach would suffice, unless you were using tr as a Filter command, in which case you would not redirect stdout.
by ray.wurlod
Fri Sep 21, 2007 7:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error running a simple C routine.
Replies: 6
Views: 1507

Compiling and linking C routines is usually achieved using what's called a "make file". Research this term in your C language manuals. Under the covers the compiler gets involved, so too might other commands such as ld - it really depends on what your routine requires. It's impossible, really, to gi...
by ray.wurlod
Fri Sep 21, 2007 7:21 pm
Forum: General
Topic: linux installation sugestion
Replies: 2
Views: 1148

DataStage itself does not require much disk space; since you've specified server edition, 100MB should be more than enough for the software. Beyond that, however, a small amount of disk space (or maybe a large amount) is required for projects. If you keep your projects tidy, your logs purged, and so...
by ray.wurlod
Fri Sep 21, 2007 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValue & KeyMgtGetNextValueConcurrent
Replies: 9
Views: 2959

The first holds a lock on the "sequence" for the duration of the job, so that only the job using it can generate keys. The second locks the sequence only for the duration of obtaining (and incrementing) the key value, so more than one job can generate keys from the same sequence at the same time. Th...
by ray.wurlod
Fri Sep 21, 2007 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error calling conversion routine timestamp_from_s
Replies: 10
Views: 6118

Welcome aboard.

Currently your question falls into "my car won't go, what's wrong?" class. You have not provided enough information.

Please post the exact error message from your job log.
by ray.wurlod
Fri Sep 21, 2007 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file warning message
Replies: 3
Views: 1452

Not correct. Import errors occur when you are trying to READ. And is agnostic regarding what U might be doing at the time. The field in question is empty, but your data type precludes an empty string being a valid value. You need to provide either a Default property or a Null Field Value property or...