Search found 53125 matches

by ray.wurlod
Wed Jan 19, 2011 3:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Internal Error (39202)
Replies: 7
Views: 3222

Please re-read the question then answer it. The dsenv script has nothing to do with it.
by ray.wurlod
Wed Jan 19, 2011 3:32 am
Forum: General
Topic: Unlocking Parameter Set
Replies: 3
Views: 1710

There is a script for cleaning up defunct processes. I can't recall what it's called at the moment, but a search of DSXchange will probably find it.
by ray.wurlod
Wed Jan 19, 2011 3:30 am
Forum: General
Topic: error handling
Replies: 2
Views: 1136

Seriously, though, this is way too vague a question. Is it an interview question? As with any other programming tool, error handling is about anticipating errors of various kinds and implementing mechanisms that can intercept and, hopefully, ameliorate them. Prevention is an even better approach.
by ray.wurlod
Wed Jan 19, 2011 3:29 am
Forum: General
Topic: error handling
Replies: 2
Views: 1136

When you make a mistake in a typescript the editor marks it, usually with a red pen or pencil. That's error handling of a kind.
by ray.wurlod
Tue Jan 18, 2011 7:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file delimiter
Replies: 8
Views: 2668

Filter command cat filepath | tr -d \" in Sequential File stage to get rid of the double quotes.

If the data contain double quote characters, prefer a sed or awk command to replace all instances of "|" with | in the filter command.
by ray.wurlod
Tue Jan 18, 2011 7:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Internal Error (39202)
Replies: 7
Views: 3222

Does project blah-blah have a relative pathname set as its TMPDIR environment variable? (These are the environment variables accessed via Administrator client and stored in the DSParams file.)
by ray.wurlod
Tue Jan 18, 2011 7:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: mkdbfile: cannot create file VOC
Replies: 1
Views: 1770

Always answer "NO" to the question about creating a UniVerse account. It means that you're not attached where you thought you were. Does telnet prompt for the name of an account? If so, give it one, even if it's UV. Otherwise change your Windows home folder on the server to one that is an ...
by ray.wurlod
Tue Jan 18, 2011 3:52 pm
Forum: General
Topic: How to pass information from DS Jobs to Job Sequence
Replies: 6
Views: 5295

But cat will work, as noted. Or, particularly if the first check is done in a server job (which I recommend as best practice when only one row is being processed), the count can be placed in that job's user status area and retrieved using the $UserStatus activity variable of the Job activity.
by ray.wurlod
Tue Jan 18, 2011 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Constrain the processing nodes used by the parallel engine
Replies: 4
Views: 1673

You can not use node pools (or disk pools) until the active configuration file mentions those pools.
by ray.wurlod
Tue Jan 18, 2011 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The transaction log for the database is full
Replies: 4
Views: 3182

Is this the XMETA database (or IADB or QSDB) or a database containing your organization's data?
by ray.wurlod
Tue Jan 18, 2011 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP and adding new columns to flow
Replies: 18
Views: 10406

Welcome aboard. How do you expect juancho to know what U (one of our other posters) did? Please strive for a professional standard of written English on DSXchange. It is a web site, not a mobile telephone, so there is no need for SMS-style abbreviations. Many of our posters (and lurkers) do not have...
by ray.wurlod
Tue Jan 18, 2011 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: count routines
Replies: 1
Views: 1235

Code: Select all

SELECT COUNT(*) FROM DS_ROUTINES WHERE DSRID NOT LIKE '\\%';
by ray.wurlod
Tue Jan 18, 2011 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between V7.5.1.A and 7.5.3
Replies: 9
Views: 2802

You can also have side-by-side installations if you prefer. At least one must be an "-itag" installation.
by ray.wurlod
Tue Jan 18, 2011 3:41 pm
Forum: General
Topic: Parameters in Sequencers
Replies: 3
Views: 1691

Check the value of the parameter, simply by interrogating it, perhaps in a trigger expression that leads to a Terminator activity.
by ray.wurlod
Tue Jan 18, 2011 3:38 pm
Forum: General
Topic: Assigning Status of Execute to a variable
Replies: 3
Views: 1335

Read all about the EXECUTE statement (and, while you're at it, the DSExecute subroutine) in the DataStage BASIC manual. The EXECUTE statemet includes clauses for capturing both the output and the exit status of the executed command.