Search found 53125 matches

by ray.wurlod
Fri Sep 13, 2013 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to compile a custom operator for RHEL 5
Replies: 4
Views: 5951

Custom operators are compiled within the stage, irrespective of platform. The compiler is specified through environment variables such APT_COMPILER, and the Build stage allow you to specify additional flags if necessary.
by ray.wurlod
Thu Sep 12, 2013 7:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Transformer Constraint Otherwise Not Working Correctly
Replies: 6
Views: 3053

Check the output link execution order. Is the Otherwise/Log link being executed first?
by ray.wurlod
Thu Sep 12, 2013 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Transformer Constraint Otherwise Not Working Correctly
Replies: 6
Views: 3053

Only the obvious observation that none of your records meet any of the critera on the first four constraints. You would need to provide values of the tested fields in order for us to decide that one way or the other.
by ray.wurlod
Thu Sep 12, 2013 4:22 pm
Forum: General
Topic: Commandoutput not working
Replies: 9
Views: 2729

Try

Code: Select all

 ls - 1 #$env_File_Path_Clearing_Source# | wc -l
as the command.
by ray.wurlod
Thu Sep 12, 2013 4:21 pm
Forum: General
Topic: Obtain SQL Statements from the jobs
Replies: 5
Views: 3060

Code: Select all

EVAL "@RECORD<17>"
included in a query will extract field number 17.
I leave it up to you how to parse out the SQL statement. Something like

Code: Select all

Field(string[Index(string, "[CDATA", 1)+6, 9999], "]", 1)
by ray.wurlod
Thu Sep 12, 2013 4:17 pm
Forum: General
Topic: ISM won't open - fresh 9.1 installation
Replies: 5
Views: 3067

Check the xmeta user to see whether it has a large number of failed logins and, if so, reset the failed login count to zero. Then check that you're using the correct xmeta password.

Other than that, a PMR will get you excellent and professional assistance.
by ray.wurlod
Thu Sep 12, 2013 5:26 am
Forum: General
Topic: Minimum Database versions support in Datastage 9.1
Replies: 4
Views: 1434

Do you mean supported for the metadata repository, or simply sorted for connectivity?

Information about version 9.1 can be found in the Information Center - in particular information about database versions for the repository on the System Requirements link.
by ray.wurlod
Wed Sep 11, 2013 8:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Month to date mismatch
Replies: 2
Views: 1056

You're trying to compare a string to an int8. A string comparison is performed, in which "09" <> "9". Apply a conversion function such as AsInteger() to the string to force both operands in the comparison to be integer types.
by ray.wurlod
Wed Sep 11, 2013 4:35 pm
Forum: General
Topic: Different data layout in a single sequential file
Replies: 3
Views: 1398

Yes.
by ray.wurlod
Wed Sep 11, 2013 4:35 pm
Forum: General
Topic: Commandoutput not working
Replies: 9
Views: 2729

Are you executing your ls command against the correct directory. As per your example you are executing it against your project directory, which will never be empty.
by ray.wurlod
Wed Sep 11, 2013 4:33 pm
Forum: General
Topic: ISM won't open - fresh 9.1 installation
Replies: 5
Views: 3067

Check your install log carefully. Look for any errors or warnings, especially for any marked as SEVERE.
by ray.wurlod
Wed Sep 11, 2013 4:32 pm
Forum: General
Topic: Did anyone notice IBM released Information Server 9.1.2?
Replies: 4
Views: 1566

I knew about this a month ago because the Concierge group mentioned it just as we were planning to install 9.1.0.1. And they called it a Fix Pack.
by ray.wurlod
Wed Sep 11, 2013 4:30 pm
Forum: General
Topic: Obtain SQL Statements from the jobs
Replies: 5
Views: 3060

Do the same again, but use LIST.ITEM rather than LIST.

Code: Select all

SEARCH DS_JOBOBJECTS
LIST.ITEM DS_JOBOBJECTS
From this you will learn the field number in which the SQL statement resides, and which you can use in an EVAL expression to extract it.
by ray.wurlod
Wed Sep 11, 2013 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sorting duplicates after matching stage
Replies: 4
Views: 1181

How about the difference between the master in each block and each other record in the block?
by ray.wurlod
Wed Sep 11, 2013 1:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sorting duplicates after matching stage
Replies: 4
Views: 1181

The easiest way is to specify Sort-Merge collector on the Sequential File stage and request that a sort be performed on whatever column you want.