DSXchange

Problem in QualityStage: When I add some user overides in the unhandled pattern for the FRNAME rule-set. They will still not be used in the standardisation stage that uses this rule-set. When I test the changings with the rule-set annalyzer it works. Example: This name must me standardized: Mr. L At...

Hello,

Does Datstage 8.0 supports the use of Sybase ASE stored procedures?

Peter

Hello, This one works for my situation: - Use Sybase OC stage to create a single row (SELECT 1) - Use the Link Collector stage to append the source rows of the sequential file with this extra row. - Use the Aggregator stage to count the number of rows - Subtract one of this count to get the number o...

Hello,

I want to calculate the number of rows in a sequential file by using the Count rows option in the aggregator stage.
Unfortunately, I get no rowcount when the sequential file is empty.

Any idea how to solve this?

Peter

Hello, I have a requirement to shorten incoming addresses by replacing addressparts like STREET in STR, or AVENUE in AVE, SECOND in 2nd, NORTH in N etc. For instance: address 'SECOND AVENUE NORTH' becomes '2nd AVE N' Of course, I could build the (couple of hundreds) substitution rules in a routine. ...

Hi,

Arg1 is an input-only parameter.

I already tried your suggestion but that didnt work too.

Peter

Hi,

The routine with the call statement was automatically created by Datastage as a result of importing an activex dll function (External Function Definition in DSManager).

I tested the routine within the routine itself (button Test...). I haven't tried to call the routine from a transformer

Peter

- I don't know where to find DSD.WriteLog?
- As far as I can see/understand, the routine that was generated during the import, only contains a call to the activex function

Peter

Hello,

In that case the routine compiles without warnings. However, when I test the routine I still get the same error.

Peter

hi,

Is there someone who can help me with this problem?

Peter

Hi all, I imported succesfully an external function in Datastage. This created the following transform function: ***************************************** $INCLUDE DSINCLUDE DSOLETYPES.H str1 = Arg1 * Automation Class name and OLE function name SNAME = 'UltraDLL.UltraDLLObject' MNAME = 'ultradll_spl...

Thanks Ray,

I was able to import the functions after providing the functions with an input parameter.

Peter

Hello, I recreated the activex library dll again in delphi and the error does not appear anymore. :? The dll consists of 2 simple functions, both without input parameters; the first one returns an integer, the second one returns a string. I did the following steps to import the dll: 1. register the ...

Thanks
The writen routine works for my problem. :D

This job seqeunce is the first job in my process to run all other processes after each hour. But when a process is still busy. The first job seqeunce must start all other processes with a new invocation id. The problem is if a job is started in the seqeunce the job seqeunce will wait until the job h...