Search found 53125 matches

by ray.wurlod
Fri Jul 02, 2010 6:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: escape character for \n in DataStage
Replies: 4
Views: 17407

Yes it's possible. Use the parallel Ereplace() function published here on DSXchange by DSGuru some time back.
by ray.wurlod
Fri Jul 02, 2010 6:43 am
Forum: General
Topic: Table value to local variable
Replies: 27
Views: 5848

I prefer to use the job's own user status area. This is accessible directly to downstream activities in the sequence as an activity variable of the job activity.
by ray.wurlod
Fri Jul 02, 2010 6:42 am
Forum: General
Topic: DSMACRO,DSFUNCTION & DSROUTINE
Replies: 2
Views: 1326

Where do you encounter "DSFunction"?
by ray.wurlod
Fri Jul 02, 2010 2:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Weird result:- sequencial file reading improper data
Replies: 7
Views: 1686

Are you absolutely sure that "first line is column names" is false? For example, might you have changed it from "true" and not re-compiled?
by ray.wurlod
Fri Jul 02, 2010 2:28 am
Forum: General
Topic: Table value to local variable
Replies: 27
Views: 5848

Find out the format of a timestamp expected by Sybase, and construct an expression to provide that.

Or use user-defined SQL and the appropriate token for Sybase SQL (something like CURRENT_TIMESTAMP) to provide the value for this field.
by ray.wurlod
Fri Jul 02, 2010 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_PMwaitForPlayersToStart failed while waiting
Replies: 1
Views: 1163

Thank you for sharing that.

It might also indicate overloaded servers.
by ray.wurlod
Fri Jul 02, 2010 1:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fatal Error:write fail for record id
Replies: 3
Views: 1344

Search would be favourite.

You have a dynamic array mark character (probably a field mark) in your key value. These are not permitted.

Or maybe your hashed file is corrupted. You will need to check.
by ray.wurlod
Thu Jul 01, 2010 10:08 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: about web services
Replies: 11
Views: 6885

Open up the \Stage Types\Parallel\Real Time branch of your repository.
Open the properties of each stage type in turn noting in particular what's documented in the Long Description field. This should answer your question.
by ray.wurlod
Thu Jul 01, 2010 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String concat based on a group of values
Replies: 5
Views: 1842

That only means that your stage variable expressions need some work. The technique is sound.
by ray.wurlod
Thu Jul 01, 2010 4:42 pm
Forum: General
Topic: Is there a way to give someone read-only access in 8.1?
Replies: 10
Views: 4016

Provide a separate client (e.g. TOAD) for them to have read-only access to the production data?
by ray.wurlod
Thu Jul 01, 2010 4:41 pm
Forum: General
Topic: DS installation - packages - fix pack
Replies: 5
Views: 3104

I doubt that you'd be installing the client on AIX !
by ray.wurlod
Thu Jul 01, 2010 4:39 pm
Forum: General
Topic: Another id to create project
Replies: 4
Views: 1421

chulett wrote:Hmmm... I thought there was some kind of command line option for that. Ah well.
There is (mkproject) but it's not documented.
by ray.wurlod
Thu Jul 01, 2010 4:37 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: about web services
Replies: 11
Views: 6885

Are you clear about what WISD is for? It is not for connecting to web services, it is for exposing your job as a web services. Connecting to web services is an entirely different kettle of fish. Please clarify what it is you wish to accomplish.
by ray.wurlod
Thu Jul 01, 2010 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dummy column
Replies: 4
Views: 2666

My preference would be a Column Generator stage.
by ray.wurlod
Thu Jul 01, 2010 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to unlock a job
Replies: 3
Views: 1536

This task is performed using the Web Console for Information Server by a user who is credentialled as an Information Server Suite Administrator. It involves identifying the active session (the ID of which is given in the "locked" message) and identifying the owner of that session. Efforts ...