Search found 53125 matches

by ray.wurlod
Thu Feb 28, 2008 2:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ReadSeq status codes
Replies: 10
Views: 2244

ReadSeq takes its Else clause if EOF is encountered. You don't need to worry about status, codes, or anything else.
by ray.wurlod
Thu Feb 28, 2008 1:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Version clarification
Replies: 11
Views: 2893

... whereas i am sitting about 20,000km from Udo. It's going to be a mad Friday - breakfast in Cairns, lunch in Sydney, dinner in Canberra!
by ray.wurlod
Thu Feb 28, 2008 1:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINE TO GET FILE DATE
Replies: 5
Views: 1238

ls -1 instead of DOS /O/B - and, of course, "UNIX" rather than "DOS" as the shell argument to DSExecute - otherwise the technique is identical.
by ray.wurlod
Thu Feb 28, 2008 1:55 pm
Forum: General
Topic: selecting table name with _ in the name in ODBC stage
Replies: 4
Views: 1383

DB2/UDB (universal database) - according to certain IBM sales folk I've met, the only database you'll ever need.

Check (using a different db2 client) that the table actually exists and does not need to be qualified with a different schema (owner) name.
by ray.wurlod
Thu Feb 28, 2008 5:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Process meta data not available in database
Replies: 8
Views: 9415

There's no such thing as MetaStage in version 8. Process metadata do get collected in version 8, and stored. They can be used by, among other things, the Resource Estimation tool. It would appear that, in the case being reported here, either the collection of the process metadata has gone awry or th...
by ray.wurlod
Thu Feb 28, 2008 5:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

Telnet uses well-known port number 23. SSH uses well-known port number 22. It is possible to change these assignments, but almost never worth it.
by ray.wurlod
Thu Feb 28, 2008 4:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob -run -param
Replies: 4
Views: 1500

No spaces around the "=", either.
by ray.wurlod
Thu Feb 28, 2008 4:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To Run the sequence job in loop
Replies: 6
Views: 2554

Run this sequence from another sequence with its own loop. Exit from that loop when the time reaches/goes past 6PM.
by ray.wurlod
Thu Feb 28, 2008 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with conditional lookup
Replies: 1
Views: 668

The columns are not visible when you're entering the conditions. They are visible in the body of the Lookup stage. You may need to scroll down to see them.
by ray.wurlod
Thu Feb 28, 2008 4:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: [b]shall we use the peek stage as a target[/b]
Replies: 7
Views: 2171

While still developing I prefer a sequential file stage if I need View Data capability - they're easier to dispose of afterwards.

As a stub I often use a Copy stage with no outputs - it eats rows beautifully and makes zero copies of them.
by ray.wurlod
Thu Feb 28, 2008 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column import warning
Replies: 4
Views: 1729

Note that the problem is in an import operator, not in an export operator. So the problem's unlikely to be in your Column Export stage. Look at the stage that generates an import operator (which you can determine by inspecting the generated OSH).
by ray.wurlod
Thu Feb 28, 2008 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINE TO GET FILE DATE
Replies: 5
Views: 1238

I did.

Premium membership would allow you, among other things, to read the entirety of premium posters' contributions. All revenue from premium memberships is devoted to defraying the hosting and bandwidth costs incurred by DSXchange.
by ray.wurlod
Thu Feb 28, 2008 4:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file after FTP
Replies: 48
Views: 8030

I just read that gays cause earthquakes. Is it true? (It was in the Hobart Mercury (newspaper - one of Rupert Murdoch's) so it must be true.)

Come on, attribute your sources. None of this "I heard" or "my invisible friend told me" please!
by ray.wurlod
Thu Feb 28, 2008 4:18 am
Forum: General
Topic: database
Replies: 6
Views: 1640

Query is harmless but beware that, once you move to version 8.x, the repository will be DB2, Oracle or SQL Server.