Search found 4992 matches

by kcbland
Mon Aug 07, 2006 1:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem With Comma Separated File
Replies: 10
Views: 2321

You stated you "have" a file, which to me meant you can't change it, so I answered how to live with it. If you can get pipes, great, just make sure there aren't pipes in the data. Otherise, use quotes.
by kcbland
Mon Aug 07, 2006 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unix AIX/DataStage
Replies: 13
Views: 3990

When you do a ". " in front of any program or command, a new environment is not "spawned". So, any environmental variables set inside the shell script are not set in a new environment, but the current environment. This is called "sourcing". So, ". ./profile" will load your environment settings witho...
by kcbland
Mon Aug 07, 2006 12:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unix AIX/DataStage
Replies: 13
Views: 3990

Did you logoff and login again? Can you source ( . ./kshrc) and see that your ll works? Otherwise, you could stick it into your .profile and see if that works.
by kcbland
Mon Aug 07, 2006 12:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem With Comma Separated File
Replies: 10
Views: 2321

If you have embedded field delimiters in your data, your only recourse is quoted fields. Set the quote character definition.
by kcbland
Sun Aug 06, 2006 5:59 pm
Forum: General
Topic: Necessary Evil?
Replies: 13
Views: 8447

Proctologists :shock:
by kcbland
Fri Aug 04, 2006 1:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete CATEGORY in TableDefintions
Replies: 1
Views: 502

All tables definitions are stored in a single internal file called DS_METADATA. Folders are logical, meaning it's just a column value and your Client session resolves all definitions into a categorized representation. Either there's a definition with a category that somehow isn't showing, or you nee...
by kcbland
Fri Aug 04, 2006 11:33 am
Forum: General
Topic: Necessary Evil?
Replies: 13
Views: 8447

If only PC OS's were as varied as car makers and with options. I mean, really, I use Windoze for word processing, email, news, shopping, etc. I remember Windoze 3.1 like yesterday, it would be absolutely sufficient for todays use. Unfortunately, all the junk added into Windoze makes it so aweful to ...
by kcbland
Thu Aug 03, 2006 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warnings from routines returning other than 0
Replies: 20
Views: 5842

Make your routines always return 0, look at using @USER0 thru @USER4 as some alternative methods for returning values from a subroutine call. The are COMMON variables that exist out there without you knowing about them. Now you do, think about using them. :wink:
by kcbland
Thu Aug 03, 2006 3:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi developer environment
Replies: 2
Views: 644

Sure, directory paths using $USER.
by kcbland
Thu Aug 03, 2006 3:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in Executing dsjob: module libvmdsapi.so not found
Replies: 4
Views: 3469

Instead of hardcoding the path to the engine, change it to:

Code: Select all

DS_HOME=`cat /.dshome`
by kcbland
Thu Aug 03, 2006 2:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to open Hash File
Replies: 4
Views: 1084

Are sure the files exist?
by kcbland
Thu Aug 03, 2006 11:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in Executing dsjob: module libvmdsapi.so not found
Replies: 4
Views: 3469

Make sure your source your dsenv file as part of your script.
by kcbland
Thu Aug 03, 2006 10:54 am
Forum: General
Topic: Necessary Evil?
Replies: 13
Views: 8447

I bought a Saturn to avoid all of the hassles, no negotiation, just pick the colors and features. I actually went in, picked everything out, they ordered it from the factory and 8 weeks later it arrived with a note from the guy who made sure it was made perfectly to order. I loved that car, but my a...
by kcbland
Thu Aug 03, 2006 7:53 am
Forum: General
Topic: Necessary Evil?
Replies: 13
Views: 8447

Choices for high-speed internet are offered by cable TV companies (cable modem), satellite dish, or DSL lines (phone companies). I almost mentioned phone companies as well. Without high-speed internet, there's no ability to work from home thru VPN. "Necessary" if your customer doesn't allow you to b...