DSXchange

Welcome aboard.

You might like to try PR3 (www.pr3systems.com) or ProTech Training (www.protechpts.com). IBM provides on-line training.

Note the word "published" in Vincent's answer. Only Data Rules that have been published can be imported.

The same is true of using Data Rules in the DataStage Data Rules stage.
Only published rules (or rules created within DataStage, and which can be published from there) can be used.

There is (it's a manual process). Usually it's a day or two. I'll open the post since you're new and have done the right thing.

Welcome aboard. Your after-job subroutine can obtain the link row count for the reject link using DSGetLinkInfo() and then send the email before any other action (for example setting ErrorCode to a non-zero value or invoking DSLogFatal() if you really still want to abort the job. I don't believe abo...

What if you CAST them as LONG VARCHAR ?

Or that DCount(field, '@') = 1... No, sorry, that won't give the required answer - it will only be true if there are NO @ characters in the string. Further, it's less efficient to use DCount() than Index() because DCount() must process the entire string whereas Index() can stop as soon as its condi...

karthi_gana wrote:any inputs?

Why are you so impatient, particularly on weekends? Get a life.
People post as and when they can on DSXchange, and are under no compulsion to do so. It's an all volunteer site.

1. This depends on the partitioning algorithm on the reference input. Auto=Entire, which means all rows on all partitions. 2. You can hash or modulus partition on the reference input using identical criteria as used on the stream input. In an SMP environment this doesn't achieve much, because Entire...

Make the assumption that it's a valid email address, and therefore contains only one "@". If you want to check this, search for the second occurrence of "@". If Index(InLink.EmailAddr, "@", 2) Then "invalid address" Else Index(Field(InLink.EmailAddr,"@&qu...

Is there an entry for MySQL_QM_Stage in the list of ODBC data source names at the top of .odbc.ini ?

Is there a Documentation folder in the is-server folder? In 8.5 (if I recall correctly) the documentation installed on the engine tier (services tier?) and is opened from there by the client.

Error code 2 usually means "file not found". Unfortunately your error message provides no clue as to which file was not found. Is PATH the same when you're executing DataStage as when you're executing from the operating system? How about the shared libaray search list LIBPATH?

On an 8.5 site at the moment. Will be on an 8.7 site next week and check it then.

Are the PDFs on the installation media?

There are several possibilities. Are you running Information Server version 8.7 (in which case IE must be at at least version 7)? Is Java enabled in IE? Are you logged in as Information Server Suite Administrator?

Is there anything unusual with the WSDL itself?

I recall having to change WSDL once because DataStage was not coping well with namespace prefixes. Replacing these in the WSDL with explicit xmlns URLs made all the difference.