DSXchange

I've got a table with duplicate keys, but different data values in a single data column. For various reasons, I need to create a single record for each key, with the different data values for the single column concatinated in a single column(or multiple columns in a single row). The server plugin ca...

Where can I find documentation of the correct format for entries in the Job.ini file?
What we had worked fine in 6.0, but is not working in 7.5.

Thanks,

Ande

Finally heard from Ascential. I have a back-level .dll file in the switcher. I can't install the mulit-switcher that came with 7.5 because no-one is allowed to be an administrator on a PC. No one. And Ascential requires this to install the switcher service. I tried doing it myself, as I have all the...

This is running on AIX 5.1
I did a find on VB* and found nothing.
I don't have VB anything.
On my PC running XP prof, I've got VB6 libraries.
I do not have .net installed.
I looked at the installs on the server and there is nothing different from the server that has no problem.

Ande

New install on AIX of 7.5A Enterprise. Seems to work okay except when I log into the Admin GUI, pick a project and click Environment. I get the run-time error '374': followed by: Failed to activate control 'VB.UserControl'. This control may be incompatible with your application..... I havn't found t...

The only way that we've seen to do this in 6 was to create a custom plug-in. Not a difficult task, and you can create your own sequencing using environment variables or inputs/operands given to the stage.

Andet

Also make sure that your PX and DS libraries are defined in the LIBPATH before any database libraries.
In the case of UDB, there are files with the same name and you want to make sure you are picking up the one from Ascential.

Ande

Are you specifying any environmental variables, overriding defaults?

Also, we've had some problems on compiles because the projects directory is actually on another server and sometime the network gets overloaded.

Ande

It's a messy setup: 2 nodes/servers, each having 2 partitions; 2 partitions on one node is the ODS and 2 partitions on the other node is the Data Mart. The SQL having the problem is copying a staging table from the ODS node to a table in the Data Mart. Both tables are partitioned. [I did not design ...

Dump it to disk (text file) in an intermediate stage, then read it from there. At the end of dumping any SELECT locks can be released. yes - that would work. Unfortunately, this job runs on the production system with no problem. It's the fail-safe system where it doesn't work. They don't want to to...

I guess that as the DB2 stage is running in parallel and so the close command is being run 'once for each node' and thus causing the deadlock. If so you'll have to force the job to use only one node. Try running the job with only one node in the DataStage/Configuration/<FileName>.apt ? Doesn't an a...

I thought of two ways: 1. Cycle the records through a transformer, and use staging variables to hold the information from prior records to compare against current records. 2. Split the file into two streams, one of header records and one of detail - send the detail through transformer/aggregator and...

This is not contributing to a solution to the problem.

Can anyone with a possible solution help?

Thanks,

Ande

I agree..mostly..but you missed the whole point: The client wants this to work. Since it was designed and coded by a developer supplied by Ascential/Torrent, how could it be wrong....etc. It's certainly not something I'd come up with or code for a client. This is not a choice, and if you're a contra...

1. This job doesn't. 2. Yes - 100% sure 3. Sort of. This particular job was left by an Ascential supplied contractor. It consists of a row generator creating 0 rows of a variable in one column. This streams to the DB2 stage(only 2 operators in job) which does a write to a dummy table and on the clos...