Search found 53125 matches

by ray.wurlod
Thu Nov 16, 2006 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequnce got resetted
Replies: 1
Views: 785

Sequences in SDKSequences do not get reset automatically.

Somewhere in your processing a process (routine?) is being invoked to reset the sequence.

Another possibility is that someone at your site has deleted or cleared the SDKSequences hashed file.
by ray.wurlod
Thu Nov 16, 2006 7:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in Sequence
Replies: 4
Views: 1078

Sequences in SDKSequences do not get reset automatically.

Somewhere in your processing a process (routine?) is being invoked to reset the sequence.

Computers do what they are told. Only what they are told. Not necessarily what you want them to do. There is an art to the telling.
by ray.wurlod
Thu Nov 16, 2006 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Format Delimiter ascii 168 (¿)
Replies: 11
Views: 5165

Don't use ALT. Just use 168.
by ray.wurlod
Thu Nov 16, 2006 7:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: script error
Replies: 2
Views: 789

And you will also need a "here script" to tell the FTP command when its commands list is exhausted, to effect graceful return to your script. For example

Code: Select all

ftp << end_of_commands
open...
username...
etc...
bye
end_of_commands
result=$?
by ray.wurlod
Thu Nov 16, 2006 7:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass parameter to DSSendmail Subroutine
Replies: 8
Views: 2194

You would need an appropriate DEFFUN declaration. Why not use it as a prototype for your own control job in which you call DSSendMail? If it's you calling it, you can supply whatever values you like for its arguments, whether job parameters or random strings!
by ray.wurlod
Thu Nov 16, 2006 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The property window of job activity stage
Replies: 11
Views: 2538

Someone posted recenty that the sp2 problem is fixed in 7.5.2, but is needed through to 7.5.1A.
by ray.wurlod
Thu Nov 16, 2006 7:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing parameter to stored procedure stage
Replies: 2
Views: 3685

Add an extra column to the input link. Upstream use a Transformer stage to populate that column with the value of the job parameter using a job parameter reference (that is, the job parameter name surrounded by "#" characters).
by ray.wurlod
Thu Nov 16, 2006 7:14 am
Forum: General
Topic: Job Server dosent started
Replies: 8
Views: 4596

You (or the UNIX Administrator) need to monitor the operating system, with particular emphasis on CPU (%Idle), memory (PF/S) and disk space. You have to do this at short intervals when the problem is occurring, but you also need baseline averages collected over longer periods of time with which to c...
by ray.wurlod
Wed Nov 15, 2006 9:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup space problem
Replies: 14
Views: 5226

You don't need to be a charter member or premium member to search or to follow links. Even at the non-discounted price it still represents excellent value for money imho.
by ray.wurlod
Wed Nov 15, 2006 6:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deriving Row Count on Windows
Replies: 2
Views: 2387

Curious. C:\Documents and Settings\Ray>help find find -- find files within file tree Usage: find directory ... expression Operators: ! not -a and -o or Primaries: -acl user-pattern[:[+-=]access-mask] user-pattern appears in ACL with appropriate permissions -atime # accessed # days ago -cpio cpio-fil...
by ray.wurlod
Wed Nov 15, 2006 5:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating Routines in Parallel Extender
Replies: 2
Views: 1035

Parallel Job Advanced Developer's Guide
by ray.wurlod
Wed Nov 15, 2006 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key generation, update and use within a single job
Replies: 2
Views: 1354

Welcome aboard. :D The good news is that the technique is exactly the same in parallel jobs. Split the stream into inserts and updates, and generate surrogate key values accordingly (though you have a Surrogate Key Generator stage to help with the latter). What you do need to ensure is that the look...
by ray.wurlod
Wed Nov 15, 2006 5:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenation Date and Time
Replies: 4
Views: 1269

Welcome aboard. :D One of the features of server jobs is that there are no data types, so you can use apparently weird constructions. In your case, you can strip and assemble the string data directly. But what precisely do you want to be the output format? Perhaps an ISO 8601 standard timestamp (YYY...
by ray.wurlod
Wed Nov 15, 2006 5:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fails to clear Inprocess row buffer.
Replies: 1
Views: 955

Welcome aboard. :D

Do you have inter-process row buffering enabled in this job? Try changing it to in-process row buffering, or disabling it entirely.
by ray.wurlod
Wed Nov 15, 2006 5:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deriving Row Count on Windows
Replies: 2
Views: 2387

The DOS find command is used to find files within a tree - not characters within a file. Type in find /? in a CMD shell for more information. The DOS findstr command does not have a counting capability. You ARE going to be up for processing the file. Fastest is probably a generic job that reads the ...