DSXchange

He was misdirecting you deliberately. The actual password is Agent86.
Sorry about that, Chief!

Yes it's possible but you'll need to:

• (a) use an If..Then..Else to determine whether the year is first or last (use Matches operator)
  
  (b) use a business rule to resolve ambiguity about whether 01/02 is January 2nd or 1st February (for example)

Stuart outlined why it's not working in the "out of the box" rule set. Making it an input pattern override, which is applied before the basic rule set rules, bypasses the - let's face it - wrong code in the rule set.

That also explains (well, suggests) why the input pattern override worked. In the override the two numeric tokens were directed into Box Value and House Number respectively.

You have at least two problems that I can see. 1. The number of columns is likely to be inconstant across links in a job design, which mitigates against a generic solution to "columns used in a job". 2. Different record types in DS_JOBOBJECTS have different structure, so there is no single...

From the command line (script), no.

You could recompile the jobs, using dscc, but that's not the same as clearing the status even though it has that as one of its effects.

But are you permitted to recompile in production?!!! Not at any site I run.

What's really strange is that, if you create an input pattern override for BB^^+T. it parses this address quite happily.

Does space occur in your STRIPLIST?

When you build your input pattern override, you get "<" when you select <space> from the drop-down list. Are you specifying "drop current token" with the "<"? This might be what is bringing the two numeric tokens together.

Can't think of one that will reliably handle an arbitrary length numeric value. Other than a custom parallel routine, of course.

But the BASIC Transformer is a parallel job solution.

Use a Column Import stage to parse the records into separate columns that can be pivoted.

If you're using LDAP for authentication then you need LDAP tools to generate lists of users. How you identify any particular user as a DataStage user can depend only on your in-house conventions. There may be other tables in XMETA - I have not got time to search for them.

It can be accomplished easily. Simply open the job design in Designer and inspect. The Columns grids in most cases have row numbers. This will make your task easier.

The "MD" conversion with Iconv() will remove currency symbols AND thousands delimiters.

Is there a limit on the number of simultaneous connections to the database server? For example Oracle is limited by the number of listeners that have been configured.

I have a urgent requirement... Any idea how can this be accomplished ? By signing up with your support provider for priority service, where you will learn the true cost of "urgent". We don't do "urgent" here. DSXchange is an all-volunteer site whose members post when they can, a...