Search found 53125 matches

by ray.wurlod
Fri May 20, 2005 5:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_SCTEMP - error number is 1
Replies: 8
Views: 4847

Are you really running a parallel job in multiple instances? In that case, it may be that one job had already created a named pipe for inter-process communication, and another instance could not, therefore, create the same named pipe. I'm guessing here, but it highlights one of the many dangers when...
by ray.wurlod
Fri May 20, 2005 5:06 am
Forum: IBM QualityStage
Topic: QS Job Run time Error:Error returned from tkGetToken
Replies: 5
Views: 3229

Can you advise us what is IN the logs?
by ray.wurlod
Thu May 19, 2005 8:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IDENTITY_INSERT is set to OFF.
Replies: 5
Views: 8472

If what you want to do is to make use of the IDENTITY property, simply leave this column out of your job design entirely. When a new row is inserted, the identity column will automatically have the next available value inserted into it.
:idea:
by ray.wurlod
Thu May 19, 2005 8:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control help
Replies: 8
Views: 2171

Version Control usually assumes that you're beginning with a development environment, so the first step will be to create the addtional projects (version_control, developement and test), then export the entire production project before importing same into the development project. You can then initia...
by ray.wurlod
Thu May 19, 2005 8:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing job parameter to routine in parallel jobs
Replies: 2
Views: 1114

Welcome aboard! :D Look in the Director log in each case, to determine what value was used (supplied) for the job parameter in question. I'm not really certain that there's any value in running parallel jobs as multiple instance - for example, unless you're really careful, you will get name clashes ...
by ray.wurlod
Thu May 19, 2005 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_SCTEMP - error number is 1
Replies: 8
Views: 4847

This is probably the operating system error number 1. I can't remember for sure what 1 is; 2 is "file not found", so 1 might be "file does not exist".
by ray.wurlod
Thu May 19, 2005 5:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: WARNING
Replies: 5
Views: 1205

Surely you can't send a space character (" ") to a date column in any case? :?
by ray.wurlod
Thu May 19, 2005 5:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing QualityStage Plugin
Replies: 6
Views: 1114

Only to get in touch with Sue or Rachna, who did most of the work setting up the original.
by ray.wurlod
Thu May 19, 2005 5:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to generate a calendar Year Using DataStage
Replies: 12
Views: 7451

The easiest job design is to use a Transformer stage to generate the dates. Seed a stage variable (for example called svMyDate) with your starting date (or the day prior) and increment this. Oconv(Iconv(svMyDate, "DYMD") + 1), "D-YMD[4,2,2]") Constrain the out...
by ray.wurlod
Thu May 19, 2005 12:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting null values in fields
Replies: 5
Views: 1842

By default, a zero-length string ("") in a sequential file is interpreted as NULL. This default can be overridden on the Format tab of a Sequential File stage. This is almost certainly the source of your null values. The job aborts after 50 warnings be default. You can override this limit when submi...
by ray.wurlod
Thu May 19, 2005 12:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing QualityStage Plugin
Replies: 6
Views: 1114

You actually have at least three things to do. 1. Install the QS plug-in stage on the server. 2. Install the QS stage GUI on the client(s) - it's probably already in place since you've been using it on the first project. 3. Create the QS project (not a DataStage project) on the new machine and - if ...
by ray.wurlod
Thu May 19, 2005 12:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage System Logs
Replies: 2
Views: 1908

Two ideas. One is to enable server-side tracing, so that you might get some idea of any pattern of activity prior to disconnections. You might also use some kind of network monitor. The other is to install the client on your server machine, at least temporarily, and see whether disconnections still ...
by ray.wurlod
Wed May 18, 2005 11:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Import Issue
Replies: 4
Views: 1000

That is definitely a bug. :oops: Report it to your support provider.
by ray.wurlod
Wed May 18, 2005 11:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Missing account name or path for remote UniVerse connection
Replies: 7
Views: 1890

Is there an entry for the UniVerse data source in uvodbc.config, specifying DBMSTYPE = UNIVERSE and, if it is remote, the host name?
by ray.wurlod
Wed May 18, 2005 11:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: current timestamp
Replies: 9
Views: 3938

There is absolutely nothing wrong with your original formulation.

Code: Select all

OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:") : ".000"
Why do you claim that it is wrong?