Search found 4605 matches

by kduke
Tue Jul 03, 2007 9:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Category
Replies: 12
Views: 2540

These are Universe commands or options. They are documented in the Universe manuals. There are posts to where you can download these manuals. These commands are TCL commands and you can get some information with the TCL HELP command. HELP COUNT.SUP There are lots of options to suppress whatever you ...
by kduke
Tue Jul 03, 2007 9:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: same time reading and writing to hash file problem?
Replies: 4
Views: 1225

This is not wise reading and writing to the same hashed file. Hashing distributes record based on the algorithm chosen. One record might cause a group to split and therefore be processed twice. Even worse scenario is when change keys or add new records. You might process the new records again.
by kduke
Tue Jul 03, 2007 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem connects to SQL Server 2005
Replies: 4
Views: 1357

Ask Microsoft.
by kduke
Tue Jul 03, 2007 6:39 am
Forum: Site/Forum
Topic: Poll Ideas
Replies: 18
Views: 9593

How about a poll on how bad Craig's jokes are getting.
by kduke
Mon Jul 02, 2007 7:05 pm
Forum: Site/Forum
Topic: Poll Ideas
Replies: 18
Views: 9593

Do a poll for Ray's book.
by kduke
Mon Jul 02, 2007 7:04 pm
Forum: General
Topic: The NEW DSX logo
Replies: 26
Views: 9934

I am so far behind. Mine doesn't spin or have solar flares. Whoa is me.
by kduke
Thu Jun 28, 2007 10:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export DS jobs using command line in UNIX
Replies: 5
Views: 1288

I saw your answer and agree but if they really want to script it then Windows is the only solution.
by kduke
Thu Jun 28, 2007 10:38 pm
Forum: General
Topic: Migration from oracle to teradata
Replies: 7
Views: 3534

I have always liked Oracle even preferred it. Teradata is smokin fast. The different stages are not like any other database. Somethings can be slowed down by how the DBA sets up the database. There are some really good training docs by Teradata to explain the difference. Read them first.
by kduke
Thu Jun 28, 2007 10:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to create a Development Standards doc
Replies: 5
Views: 1730

IBM may share some of their standards.
by kduke
Thu Jun 28, 2007 10:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Manager
Replies: 6
Views: 986

Manager sucks or maybe motorcyles suck. Not sure what I have learned here.
by kduke
Thu Jun 28, 2007 10:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error When Array Size is greater than 1
Replies: 9
Views: 2488

I think it is a database issue. I think you need to use read uncommited or something that does not lock the source records. I think you have a database lock issue.
by kduke
Thu Jun 28, 2007 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export DS jobs using command line in UNIX
Replies: 5
Views: 1288

You will need to use dsjob.exe -ljobs to get a list of jobs.
by kduke
Wed Jun 27, 2007 7:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to create a Development Standards doc
Replies: 5
Views: 1730

Documentation tends to be owned by the customer and therefore not sharable. Sorry.
by kduke
Wed Jun 27, 2007 7:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running .exe program through Unix Command Prompt
Replies: 2
Views: 1664

I assume Ray is correct. You need to run a Windows program from UNIX. You can install UNIX utilities on Windows and run a remote shell like rsh. You can create an autosys process which waits for a file to show up in a directory. I also assume autosys is on both machines. So it waits for a UNIX file ...
by kduke
Wed Jun 27, 2007 7:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instance job and Passing Invocation ID
Replies: 3
Views: 986

You need a parameter that matches your invocation ids. These should be known and not random.