Search found 42189 matches

by chulett
Fri Nov 21, 2008 8:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception Handler
Replies: 4
Views: 1600

I don't believe so. Suggest you build a small test set and check for yourself.
by chulett
Fri Nov 21, 2008 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error 6 initializing SQL*Plus
Replies: 6
Views: 3666

Welcome!

If everything was set correctly, this error wouldn't occur. Have you configured your dsenv file correctly for Oracle?
by chulett
Fri Nov 21, 2008 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two Jobs of same name error
Replies: 5
Views: 1490

Project indices are corrupted, I'd wager. Search the forums for DS.REINDEX for discussions on the process to correct the problem.
by chulett
Fri Nov 21, 2008 12:01 am
Forum: General
Topic: Getting Triggered Mails
Replies: 1
Views: 750

Probably from another Project. We sometimes get emails like that from the QA folks when they're testing and haven't properly reset the email parameter to notify them.
by chulett
Thu Nov 20, 2008 11:58 pm
Forum: General
Topic: MQ Series Invoke DataStage Job.
Replies: 20
Views: 7967

WebSphere Information Services Director is typically abbreviated as WISD. All iterations of the product can be discussed in the "SOA Editions" forum.
by chulett
Thu Nov 20, 2008 6:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Execute Command Activity error
Replies: 4
Views: 1287

mandyli wrote:In the Execute Stage i used ReturnValue = 1 or 1

Literally that? :?
by chulett
Thu Nov 20, 2008 3:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Flat File
Replies: 6
Views: 2148

Or simply:

Code: Select all

cat file1 file2 file3 > file4

So as to not destroy the original "file2" file and allow it to rerun without much in the way of shenanigans.
by chulett
Thu Nov 20, 2008 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Flat File
Replies: 6
Views: 2148

What is your source for these other records? There's probably some fancy PX way to do that, but you could also write those out to two other files and then cat them together in the proper order after job. Worst case. :wink:
by chulett
Thu Nov 20, 2008 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure Stage calling SQL Server Stored Proc
Replies: 3
Views: 1428

Thanks for posting the solution! :D
by chulett
Thu Nov 20, 2008 3:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to write a unix condition
Replies: 13
Views: 3395

Apparently, more like the small mountain range you sit on. :wink:
by chulett
Thu Nov 20, 2008 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to write a unix condition
Replies: 13
Views: 3395

Why in the hell do something like that? :evil:

As to the filename question:

http://www.soccerhelp.com/Soccer_Tips_D ... html#cards
by chulett
Thu Nov 20, 2008 2:32 pm
Forum: General
Topic: how can i use NOT operator in TCL Command
Replies: 10
Views: 3821

"UNLIKE", eh? Cute.

I should have looked closer at some of the Kim Kode I have stashed away, I found examples of this syntax there. Well... now that I know what to look for, that is. :wink:
by chulett
Thu Nov 20, 2008 2:19 pm
Forum: General
Topic: Data souce (DSN) using ODBC driver for Excel
Replies: 4
Views: 1333

There's no documentation for something that doesn't ship with the product, if you mean the ODBC driver. You can find plenty of discussion here, if that helps, by searching for "ODBC Driver for Excel" and sticking with the posts that are marked as UNIX. For example: m Please ignore my rather confused...
by chulett
Thu Nov 20, 2008 1:44 pm
Forum: General
Topic: Data souce (DSN) using ODBC driver for Excel
Replies: 4
Views: 1333

To leverage a UNIX ODBC driver for Excel, you would need to purchase one as far as I know. One doesn't ship with DataStage, at least not up through the 7.x version and I don't believe that has changed in the 8.x release.