Search found 53125 matches

by ray.wurlod
Fri Mar 25, 2011 1:10 am
Forum: General
Topic: To run a job from Command line
Replies: 11
Views: 4090

Header file dsapi.h or JOBCONTROL.H (which you will find on the server) contains this information. Incidentally, 0 is not "successful". 0 is "running".
by ray.wurlod
Thu Mar 24, 2011 10:43 pm
Forum: Data Quality Best Practices
Topic: Data Quality Dashboard
Replies: 3
Views: 10585

Have checked with "them" (the ones who put it together) to learn that granularity is not a problem provided that the rule definition, derived data rules or rule sets are all available in the common metadata repository. While not in the demo for next week's conference, it should be possible...
by ray.wurlod
Thu Mar 24, 2011 9:55 pm
Forum: Data Quality Best Practices
Topic: Data Quality Dashboard
Replies: 3
Views: 10585

Would have to verify that - can certainly use the data rule metrics on the dashboard, but I suspect that the individual rules might be too fine a granularity for a dashboard. It would certainly be possible but, I suspect, "too much information" for the management level at which we're aimin...
by ray.wurlod
Thu Mar 24, 2011 9:03 pm
Forum: Data Quality Best Practices
Topic: Data Quality Dashboard
Replies: 3
Views: 10585

Data Quality Dashboard

My company is unveiling a DQ Dashboard solution next week. You can view a press release here - we're trying to make DQ less a theoretical and more a practical issue, by putting the value/cost of data quality onto managers' dashboards.

For more information please visit Zenith Solutions website.
by ray.wurlod
Thu Mar 24, 2011 7:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
Replies: 8
Views: 7103

You can intercept the null in the routine and convert it to an in-band value before invoking DSSetParam() function.
by ray.wurlod
Thu Mar 24, 2011 5:34 pm
Forum: General
Topic: Can i used DMLsentences in DS engine shell ?
Replies: 4
Views: 1669

The DS shell is attempting to find a DataStage (UniVerse) table of that name. It doesn't exist.
by ray.wurlod
Thu Mar 24, 2011 2:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file corruption
Replies: 5
Views: 4481

Not true. The -file option takes a pathname as its argument.
by ray.wurlod
Thu Mar 24, 2011 2:06 pm
Forum: General
Topic: Can i used DMLsentences in DS engine shell ?
Replies: 4
Views: 1669

Short answer: No.

Teradata DML statements must be executed in a Teradata environment such as BTEQ. You can, of course, invoke that environment from the DataStage environment.
by ray.wurlod
Thu Mar 24, 2011 1:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file corruption
Replies: 5
Views: 4481

Both fixtool and uvfixfile can be run from the command line. For example

Code: Select all

$DSHOME/bin/uvfixfile -file hf_DR07BU0D_cnts 
(You need to have run the dsenv script first.)
by ray.wurlod
Thu Mar 24, 2011 1:27 pm
Forum: General
Topic: DSGetJobInfo
Replies: 1
Views: 1368

The easiest way would be a server routine that inspects the sequence log.
by ray.wurlod
Thu Mar 24, 2011 1:26 pm
Forum: General
Topic: To run a job from Command line
Replies: 11
Views: 4090

Verify that parameter set NameTest has a values file called Test.
by ray.wurlod
Thu Mar 24, 2011 1:25 pm
Forum: General
Topic: Version Control vs Information Server 8.5 functionality
Replies: 4
Views: 2668

Information Server Manager 8.5 integrates directly with some source code control tools (the IBM ones), and you can use Eclipse plug-ins for others. We're using SubVersion. There's also an API, but I haven't investigated that. SubVersion looks after the versioning, and also provides check out/check i...
by ray.wurlod
Thu Mar 24, 2011 1:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to reject rows from transformer
Replies: 8
Views: 7011

The Reject link handles rows that cause an internal exception. The Otherwise/Log link handles rows that are not processed by any preceding output link.
by ray.wurlod
Thu Mar 24, 2011 1:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To read Foxpro .DBF files
Replies: 12
Views: 7240

It's not there. No FoxPro ODBC driver ships with IIS 8.5.