Search found 4992 matches

by kcbland
Tue Aug 08, 2006 4:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete Hash file
Replies: 3
Views: 1413

Created in the project? TCL command DELETE.FILE from DS Administrator. In an external directory, Unix command "rm -r yourhashedfile"
by kcbland
Tue Aug 08, 2006 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read Access for DS Jobs
Replies: 6
Views: 2251

Check out Operators versus Developers when configuring user access.
by kcbland
Tue Aug 08, 2006 11:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get number of working days in a month in SQL
Replies: 12
Views: 4485

There is no sample code. Whether a day is a business day or not cannot be programmatically determined by anyone. You need a TIME dimension table, from that you can get your answer quite easily. If you're going to assume that every Monday thru Friday is a working day, you can write something. However...
by kcbland
Tue Aug 08, 2006 8:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get number of working days in a month
Replies: 5
Views: 2051

Why did you post in the Testimonials forum?

The standard solution is to use a Time dimension table and then a simple count of the days for a given month with their business day indicator set.
by kcbland
Tue Aug 08, 2006 8:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Verify installation of Datastage server Engine
Replies: 1
Views: 455

Connect with a DS Client app, import metadata from all sources and targets, run a job.
by kcbland
Tue Aug 08, 2006 8:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Before Job Sub Routine
Replies: 4
Views: 1126

Stay with using a function, use it as the initialization step of a Stage variable in a transformer. The derivation of the stage variable is just the stage variable itself. At startup, the function will be called, returning your value. The stage variable will always be that value. Now you can use it ...
by kcbland
Mon Aug 07, 2006 9:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: operands for DSJOB command
Replies: 5
Views: 1429

So I went over to www.dictionary.com, typed in "operand", and chose the third definition which seemed appropriate: <programming> An argument of an operator or of a machine language instruction. So if dsjob is an instruction , then the arguments to that instruction must be the operands . Hence, I sug...
by kcbland
Mon Aug 07, 2006 7:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: operands for DSJOB command
Replies: 5
Views: 1429

Hey, seems that question has been posed before by a job seeker looking for hints at passing a technical interview. Funny to see it again The question is best answered by just typing in dsjob and seeing the output. You'll have all of the operands listed that you need. Now, just read the manual for de...
by kcbland
Mon Aug 07, 2006 6:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transfering data from VARCHAR field to a NUMBER field
Replies: 1
Views: 462

If it is truly a number stored in a varchar column, there's nothing to do in Server. It's obvious you are not loading a number, but something else. Consider removing any symbols that are used in string representations of numbers such as the following:

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

Folks, if the Sequential stage can't read the file correctly, then you can't do fixes like EREPLACE or CHANGE.
by kcbland
Mon Aug 07, 2006 2:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unix AIX/DataStage
Replies: 13
Views: 3990

Where's FRED when you type in alias? The example worked (although I don't know why you put an ip address in when I wanted hostname, although any command would have worked I like that one). It is apparent that alias is working, but why FRED isn't in your alias environment after typing in alias is a m...
by kcbland
Mon Aug 07, 2006 1:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unix AIX/DataStage
Replies: 13
Views: 3990

Also, just type in "alias" and hit enter to "see" if you have an alias setup. For what it's work, single quotes are really preferred, but it shouldn't make a difference. If you can't see aliases, then my only guess is somehow it's disabled.
by kcbland
Mon Aug 07, 2006 1:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unix AIX/DataStage
Replies: 13
Views: 3990

Can you type in an alias, like

Code: Select all

$ alias FRED="hostname"
$ FRED


Does it work?