Search found 10 matches

by wilcywilliam
Mon May 23, 2005 11:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSjobreport
Replies: 5
Views: 3004

XML report can be obtained by specifying argument 1 of the DSJobReport routine 'report type' as '2'. Argument 3 of the DSJobReport routine 'XSL stylesheet' optionally specifies an XSL style sheet to format an XML report.
by wilcywilliam
Tue Apr 26, 2005 7:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 'Read-only', should be checked for release jobs ?
Replies: 1
Views: 1452

Select this check box to export any read-only items selected in the Components tab. By default, read-only items are not exported.
by wilcywilliam
Tue Apr 26, 2005 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Schedule
Replies: 8
Views: 3632

DataStage 7.0 version
In the development enviroment we have written a routine that loops n times and a Sleep time is specified for the interval.
In production environment we use an external scheduler 'Autosys'.
by wilcywilliam
Thu Apr 21, 2005 6:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error When Saving a Job
Replies: 6
Views: 2527

Try importing and exporting components into the repository from the command line using 'dscmdimport' and 'dscmdexport' commands. Both these commands have a parameter "omitflag" which is set to to 1 to omit the username and password if you are connected to the DataStage Server via LAN Manag...
by wilcywilliam
Thu Apr 21, 2005 5:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Differnce betn using Omit option and normal login method
Replies: 2
Views: 1367

If you are connecting to the server via LAN Manager, you can
select the Omit check box. The User name and Password fields
gray out and you log on to the server using your Windows NT
Domain account details.
by wilcywilliam
Fri Apr 15, 2005 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: non-root Upgrade
Replies: 7
Views: 2042

Advantage of Root Install In Root Install, auto start is enabled with impersonation mode, so that the DataStage services start automatically whenever the machine is restarted whereas in Non-Root Install, the administrator will need to manually start the DataStage services whenever the machine is res...
by wilcywilliam
Fri Apr 15, 2005 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: create and append text to sequential file in the same stage
Replies: 6
Views: 4496

The output to the sequential file is in the same order as the input. So if the rows first satisfy the 'append' constraint, then those rows are written first. Specifying the link order in sequential file stages doesn't ensure that all outputs to the 'create' link are written first followed by the 'ap...
by wilcywilliam
Fri Apr 15, 2005 6:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Tuning of the server JOB which is taking 4hrs ?
Replies: 3
Views: 1665

Change the lookup tables to hashed file stages. Use the inter-process (IPC) stage which provides a communication channel between DataStage processes running simultaneously in the same job. It allows you to design jobs that run on SMP systems with great performance benefits.
by wilcywilliam
Fri Apr 08, 2005 5:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: invalid quotes problem ( " )
Replies: 11
Views: 4231

The quote character should contain the character used to enclose strings. Enter 000 to suppress the quote character. In your case the row 99879 violates the sequential file definition, you can use the incomplete column in the columns tab to specify the action taken if the column contains insufficien...
by wilcywilliam
Fri Apr 08, 2005 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 50 Warnings Limit
Replies: 11
Views: 6298

The Job Run Options dialog box allows you to change the job parameter values and default limits for row processing and warning messages each time you run a job.