Search found 53125 matches

by ray.wurlod
Fri Nov 17, 2006 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: E TFDR 000001 (002)- not able to view the data loaded
Replies: 2
Views: 1254

Is the Data Set control file in a different directory than the one you specified?
by ray.wurlod
Fri Nov 17, 2006 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookp up stage - fatal error
Replies: 2
Views: 1864

Your "failed lookup" rule is set to "Fail". Change it to one of the other three values. If you select "Output" you will need to construct a reject output link.
by ray.wurlod
Fri Nov 17, 2006 7:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: All objects in the Job become PLUG objects.
Replies: 9
Views: 3122

On Solaris that limit is 32K subdirectories in a directory. That would allow in excess of 5000 jobs. Do you really have that many?

Code: Select all

SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';
by ray.wurlod
Fri Nov 17, 2006 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Set Variables in DataStage?
Replies: 4
Views: 6900

A User Variables activity in a job sequence allows each variable to be set based on an expression. A stage variable in a Transformer stage similarly allows initialization using an expression. If this variable needs to remain unchanged for each row processed, leave its Derivation field empty. Where i...
by ray.wurlod
Fri Nov 17, 2006 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence Hangs
Replies: 5
Views: 1333

It you killed it it may not have had the chance to log messages about timeout periods elapsing and so on. Did everything in the sequence get done and the sequence not end, or did it only get part way through the activities it ought to be controlling? You need to inspect all the individual child, gra...
by ray.wurlod
Fri Nov 17, 2006 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pass valus to UNIX script fromDS control job
Replies: 9
Views: 1711

A small change if I may. Use the -c option for SH to effect a return of control when completed. Cmd = 'SH -c "ShellScript Arg1 Arg2"' Execute Cmd capturing Output returning ReturnCode My personal preference is to use DSExecute(). Cmd = "ShellScript " : Arg1 : " " : Arg2...
by ray.wurlod
Fri Nov 17, 2006 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Client Library property required for stage
Replies: 1
Views: 1808

Welcome aboard.

Search is your friend on this site. A search on the error text yields some hits, the best of which is this one.
by ray.wurlod
Fri Nov 17, 2006 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass parameter to DSSendmail Subroutine
Replies: 8
Views: 2194

Das wrote:Can u give the code here?


The code is already in DSSendMailTester routine.

And my name is not "u".
by ray.wurlod
Fri Nov 17, 2006 7:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Pass values from a table to Parameters?
Replies: 3
Views: 1084

You have to get the parameter value from the table. That's one job, that has to store the value somewhere accessible, such as its user status area. The second job has to be passed two values decoded from that pathname. You could use Field() functions, or FinalDelimitedString() routine - search the F...
by ray.wurlod
Fri Nov 17, 2006 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Intermittent ORA-12545 through sequencer
Replies: 4
Views: 2275

Check also for hard-coded settings in the child jobs and for "set to default" settings in the Job activities in the job sequence. Use Set Defaults from the Job menu in Director to set new default values in the new environment or, if you've used $PROJDEF for environment variable job parameters, use A...
by ray.wurlod
Fri Nov 17, 2006 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: calculate Job EndDateTime and Job ElapsedTime.
Replies: 27
Views: 9719

Yes. Notify the documentation fault via your support provider. Use the tokens in JOBCONTROL.H.
by ray.wurlod
Fri Nov 17, 2006 7:12 am
Forum: General
Topic: How to export the job log of a particular job?
Replies: 5
Views: 3921

Within Director, choose Print from the Project menu, then check the Print to File check box in the common print dialog and choose whatever options you desire to govern what is exported.
by ray.wurlod
Thu Nov 16, 2006 9:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: calculate Job EndDateTime and Job ElapsedTime.
Replies: 27
Views: 9719

Are you choosing the DS Constants from the drop down list from the Expression Editor menu?

Review the header file JOBCONTROL.H in the DSINCLUDE subdirectory on the server. This contains all of the constants, as well as DEFFUN declarations for the DS Functions and the DS Macro definitions.
by ray.wurlod
Thu Nov 16, 2006 9:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: special character
Replies: 4
Views: 1169

So, effectively, the non-printing characters.

Code: Select all

(Oconv(ch, "MCP") = ch)
will identify that the character is non-printable. The expression returns 1 (true) if the character is non-printable, 0 (false) otherwise. It returns NULL if ch is NULL.