Search found 53125 matches

by ray.wurlod
Fri Nov 12, 2010 6:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameter name --> Password
Replies: 9
Views: 2665

Depends whether, at run time, you specify "(As defined)" or one of the values file names.
by ray.wurlod
Fri Nov 12, 2010 6:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to do round function in Datastage server jobs
Replies: 4
Views: 8672

FMT(InLink.TheValue, "10R1") will work but include leading space characters. You may need to wrap a TrimF() around that. For that reason I would prefer the Oconv() form.
by ray.wurlod
Fri Nov 12, 2010 6:40 pm
Forum: General
Topic: UV command
Replies: 2
Views: 2236

UV is not a command, it's a shell. Assuming the CREATE.FILE command was successful, you can query the hashed file. For example: SELECT * FROM <<PVFile>>; (subsititute the appropriate value for PVFile here. Of course, since you have not populated the hashed file, 0 records will be selected.
by ray.wurlod
Fri Nov 12, 2010 1:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation error
Replies: 3
Views: 1255

One (or more) of the input fields is not found. This could be in a stage variable derivation, a constraint expression or an output column derivation. You did not post enough of the Transformer code for this to be diagnosed any more accurately than that. Therefore I can only suggest you check your wo...
by ray.wurlod
Fri Nov 12, 2010 1:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert 5 digit julian date to calendar date ?
Replies: 14
Views: 9990

If this is true you can use StringToDate() with an appropriate date format mask string.
by ray.wurlod
Fri Nov 12, 2010 1:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to do round function in Datastage server jobs
Replies: 4
Views: 8672

Oconv(InLink.TheValue, "MD1P")
by ray.wurlod
Thu Nov 11, 2010 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Input buffer overrun
Replies: 6
Views: 3983

Your original data, as posted, lacked this \n, which is why I asked. Can you read the file as if it has only one VarChar field? Does that work successfully? If so, you can parse the rows in a Transformer stage. (This can actually be more efficient, because the parsing occurs in a parallel stage.) Yo...
by ray.wurlod
Thu Nov 11, 2010 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation error
Replies: 5
Views: 2454

There is a reference within one of the stages within the shared container to a parameter (set) called "Job name". Apparently the container does not have a parameter (set) of this name.
by ray.wurlod
Thu Nov 11, 2010 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data view parameters
Replies: 1
Views: 1192

Probably a change between the two job designs - one has parameters and the other has parameter set(s).
by ray.wurlod
Thu Nov 11, 2010 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Input buffer overrun
Replies: 6
Views: 3983

Is there a \n at the end of the first line?
by ray.wurlod
Thu Nov 11, 2010 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot remove "will partition" warning
Replies: 3
Views: 1501

Clear the preserve partitioning flag on the stages upstream on the input links to the Lookup stage. Use Entire partitioning on the reference input link unless you can be 100% certain that the stream input link uses identical Hash partitioning propagated from upstream by Same.
by ray.wurlod
Thu Nov 11, 2010 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert 5 digit julian date to calendar date ?
Replies: 14
Views: 9990

Could 09134 represent the 134th day of 2009? That format is also sometimes referred to as "Julian". And is easily converted.
by ray.wurlod
Thu Nov 11, 2010 3:10 pm
Forum: General
Topic: dsjob.exe return code -10
Replies: 4
Views: 2864

Open (or left open) in Designer or Monitor (or even, in some circumstances, Director log view) by someone else?
by ray.wurlod
Thu Nov 11, 2010 3:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 7.1 - reports for jobs scheduled in data stage director
Replies: 2
Views: 2004

In the View menu disable display of categories in Schedule view. You can sort the Schedule view by clicking on the grid headers. Once you have what you want on the screen, choose Print from the Project menu. In the common print dialog there is a "print to file" option.
by ray.wurlod
Thu Nov 11, 2010 3:06 pm
Forum: General
Topic: How to list jobs modification dates?
Replies: 25
Views: 7110

There is no other single table on the server. There may well be this information stored in the unified metadata repository (XMETA) but the structure of those tables is not in the public domain.