Search found 53125 matches

by ray.wurlod
Fri Oct 23, 2009 12:42 am
Forum: General
Topic: Rejection of Rows while copying from one file to another
Replies: 4
Views: 1237

Is your source a file, a database connection, or something else? From which stage did you create the reject link? Can you advise the record schema of your source stage and a couple of example reject records?
by ray.wurlod
Thu Oct 22, 2009 11:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IBM Infosphere (8.1) Login error and unable start the server
Replies: 3
Views: 1965

With what commands (exactly and completely) did you try to start the servers?
by ray.wurlod
Thu Oct 22, 2009 11:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trusted ssh connection or trusted rsh connection
Replies: 1
Views: 1695

Set APT_STARTUP_STATUS and APT_SHOW_RSH environment variables and the log will report what commands are issued during the startup.
by ray.wurlod
Thu Oct 22, 2009 11:48 pm
Forum: General
Topic: Rejection of Rows while copying from one file to another
Replies: 4
Views: 1237

Not enough information. Why are they being rejected? Are you capturing the rejects and, if so, can you see any pattern in them? What command are you using to move records from current to previous? Do the current and previous files interact with the source in any way? Which stages are running in para...
by ray.wurlod
Thu Oct 22, 2009 5:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File name with wild card on basic
Replies: 4
Views: 1544

No, but... Yeah, but...

Your routine could process the wildcard and check the size of each file in turn. Invoke ls through DSExecute, for example.
by ray.wurlod
Thu Oct 22, 2009 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File name with wild card on basic
Replies: 4
Views: 1544

Yes you can.

Open the file with OpenSeq then use the Status statement on the file variable. Field #6 of the dynamic array returned by Status contains the file size.

Code: Select all

OpenSeq filepath To file.fvar
Then
   Status FileInfo From file.fvar
   Then
      FileSize = FileInfo<6,1,1>
   End
End
by ray.wurlod
Thu Oct 22, 2009 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting of date range
Replies: 14
Views: 3125

The specification is clear. We're now in think time, because nothing immediately comes to mind. It's easy in a server routine, but your question asks how to do it in a DataStage parallel job (which would probably need to execute in sequential mode).
by ray.wurlod
Thu Oct 22, 2009 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commonly used parameters
Replies: 5
Views: 1741

As well as those two I always include APT_DUMP_SCORE (default False), because the score is one of the most useful diagnostic tools you have. The default value of APT_CONFIG_FILE I set to $PROJDEF.
by ray.wurlod
Thu Oct 22, 2009 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping Using Stage Variable
Replies: 4
Views: 1965

Code: Select all

Right(MatchField(InLink.Code, "0N0A0N", 2), 1)
by ray.wurlod
Thu Oct 22, 2009 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpoint Does not WorkWhen A Sequence is Stopped
Replies: 5
Views: 1945

Who stopped it? "Stopped" means stopped by user intervention.
by ray.wurlod
Thu Oct 22, 2009 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Use of a DS function EReplace in a Server Routine
Replies: 6
Views: 3475

Yes recursion is possible, but (like any language) make sure you have an exit strategy. Otherwise you will have an infinite loop that will only exit when you blow your stack space.
by ray.wurlod
Thu Oct 22, 2009 3:48 pm
Forum: General
Topic: Failed to connect
Replies: 13
Views: 5512

Set up your users as Information Server users and give the product role DataStage User to each (apart from the ones you want to be DataStage Administrators). Then, using the DataStage Administrator client, and logged in as an administrator, allocate the Developer role to each of those users.
by ray.wurlod
Thu Oct 22, 2009 3:46 pm
Forum: General
Topic: What is the max size for the value stored in $UserStatus
Replies: 4
Views: 1369

The limit is primarily imposed by string space in memory. I have had 3MB strings in the user status area.
by ray.wurlod
Thu Oct 22, 2009 3:45 pm
Forum: General
Topic: result of a query in a variable activity
Replies: 9
Views: 2212

Have the Sequential File stage append to /dev/null (UNIX) or .\NUL (Windows). Then you have no file created.
by ray.wurlod
Thu Oct 22, 2009 3:44 pm
Forum: General
Topic: Regarding Loading chinese characters
Replies: 6
Views: 2060

Because View Data does not work properly with multibyte characters.

It is NOT a fault of the stage.