Search found 53125 matches

by ray.wurlod
Sun Sep 09, 2012 1:44 am
Forum: General
Topic: UTF-8
Replies: 8
Views: 2158

I think it's reasonably safe to infer, because Craig's post was quoted, that Craig's suggestion was the resolution.
by ray.wurlod
Sat Sep 08, 2012 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Decimal - losing negative sign
Replies: 2
Views: 1311

What are the precision and scale settings for the Decimal target column? Does it have a specifically set display width?
by ray.wurlod
Sat Sep 08, 2012 2:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can we use server routines in parallel environment directly
Replies: 2
Views: 1110

Before-job and after-job subroutines are always server routines, even in parallel jobs. You can use the BASIC Transformer stage to call server routines for each row processed, as Arnd noted. You can also use server Shared Containers in parallel jobs, subject to some restrictions that are documented ...
by ray.wurlod
Sat Sep 08, 2012 2:20 am
Forum: General
Topic: Universe program does not run in 8.7
Replies: 12
Views: 3860

This is a stand-alone "UniVerse" program. It is neither a FUNCTION nor a SUBROUTINE. It may have an optional PROGRAM declaration at its beginning. It requires a STOP statement to end it but the friendly compiler will put that in if the programmer forgets.
by ray.wurlod
Fri Sep 07, 2012 2:22 pm
Forum: General
Topic: Universe program does not run in 8.7
Replies: 12
Views: 3860

Within the code find out how the hashed file is opened. If the Open statement is used, there must be a VOC entry in the same project that points to the hashed file; this can be created using a SETFILE command. A hashed file can be opened via its pathname with an OpenPath statement. If that fails, ch...
by ray.wurlod
Fri Sep 07, 2012 2:16 pm
Forum: General
Topic: DataStage project creation error
Replies: 23
Views: 7285

On the global security page in the WAS administration console. You manage those users in the web console for Information Server; it will select users and groups from whichever user registry is in use. You don't really have to look in the WAS administration console.
by ray.wurlod
Fri Sep 07, 2012 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading the sequential file
Replies: 4
Views: 3922

Alternatively you can have an operating system command, such as grep or awk, select the rows for you. You would implement this by means of a Filter command in the Sequential File stage.
by ray.wurlod
Fri Sep 07, 2012 6:58 am
Forum: General
Topic: DataStage project creation error
Replies: 23
Views: 7285

You don't add users there; you map users defined in whatever user registry WAS is using to authenticate to operating system user(s) on the engine tier.
by ray.wurlod
Fri Sep 07, 2012 1:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: facing issue with remving duplicates
Replies: 5
Views: 1642

Specify how the data are partitioned.
by ray.wurlod
Fri Sep 07, 2012 1:12 am
Forum: General
Topic: Parameter Set Changes
Replies: 2
Views: 1262

Yes. Use values files.
by ray.wurlod
Fri Sep 07, 2012 1:12 am
Forum: General
Topic: Issue with isalite
Replies: 4
Views: 1248

No idea, because you did not vouchsafe what values you used for these.

What was the value given through DB2INSTANCE environment variable?
by ray.wurlod
Thu Sep 06, 2012 9:20 pm
Forum: General
Topic: Issue with isalite
Replies: 4
Views: 1248

Which user ID did you use to run ISALite and was the DB2INSTANCE environment variable set for that user?
by ray.wurlod
Thu Sep 06, 2012 9:19 pm
Forum: General
Topic: Universe program does not run in 8.7
Replies: 12
Views: 3860

So where is the source code for CCYCONV ? This one of yours, not one of IBM's.
by ray.wurlod
Thu Sep 06, 2012 9:17 pm
Forum: Cognos (IBM BI)
Topic: Why Cognos can't find some terms in Business Glossary?
Replies: 9
Views: 13582

So, resolved now? Not too bad a turnaround time to produce a patch.
by ray.wurlod
Thu Sep 06, 2012 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SaveInputRecords and GetSavedInputRecords
Replies: 3
Views: 4696

Can you outline how you are trying to use these functions? They are intended to be used when processing groups of records.

SaveInputRecord() pushes the current record onto a queue and returns the number of records now on the queue.

GetSavedInputRecord() pops one record off the queue.