DSXchange

I recently encountered this error while updating a DB2 table. For testing I was updating a "clone" of the target table but I neglected to put a primary key on the clone. The lack of the PK caused DB2 to lock at the table level so in the parallel job, update_0 locked the table and update_1 ...

Our ETL source application was recently upgraded and many tables had new columns added. In testing our suite of ETL staging jobs (just to see if they would still run) two jobs out of dozens choked on the extra columns. I'm not asking how to fix this, I can make the jobs work easily by adding referen...

We are trying to add an ODBC datasource to connect to a DB2 database on an AS400. When the admin adds the entry to the .odbc.ini file and re-starts Datastage the entry does not appear in the drop-down list of DSNs to import table defs from. IBM's web site says that we must run a 'bind' process for t...

Thank you Craig. That's what I needed to hear. If I cannot use parameters within parameters, so be it. We'll hardcode!

Arnd, Yes I am. The query works if I take other parameters out of it. Here is the query "SELECT DISTINCT CUSTOMER_NAME FROM #$SAPDWSchema#.DW_VERTICALS WHERE CUSTOMER_NAME NOT IN (SELECT MGMT_CUSTOMER_NAME FROM #$SAPDWSchema#.DW_BILLTO_CUR)". If I change the #$SAPDWSchema# to a hardcoded s...

I want to put a query in a parameter and use it in an ODBC enterprise stage against a UDB database. In the stage, under source, the code is invoked as Query=#Query#. The query is defined as a job level parameter and its initial value is the query code (SELECT CUSTOMER_NAME .....) It doesn't work, I ...

I have the task of replacing some hardcoded text (schemas) with environmental variables. In a shared container I cannot figure out how to add a single parameter. The properties editor seems to only allow parameter sets. The editor shows existing parameters so they must have been entered individually...

Kryt0n - Yes there is a join but it is a left outer. The number of rows after the join is the same as the left hand table. I developed a server job to do the same aggregation and the numbers came out correct although the job is WAY slower. I am now confident that the problem is related to parallelis...

Sorry for the delay folks, system problems.

I tried using a hash on the grouping keys but got the same results. In this shared environment I cannot constrain the software to one node.

Would simply making this a server job solve the prob? I'll try it.

Two nodes. Partition is set to auto.

I am using an aggreagtor stage to sum an amount field. In the resulting table the value is exactly twice the expected value. If I sum the incoming data manually with a SQL query, it is correct. It sounds suspicious to me that it is exactly double. Am I making some stupid mistake? Is there a known is...

I don't see handle_null() in the Developer's Guide. Do you have a reference?

Thanks Ray,

It figures that when I try to do my homework by reading the manual, the manual is wrong!!!

I solved a similar problem with the last column on a record by appending a delimiter on the record. You can bring in the record as one large chunk, append the delimiter of your choice in a transformer and then break out the columns in another transformer with "field" statements that feel f...

I have created the routine to set $Userstatus. It compiled and tested OK. When I try to use it in the column derivation (per the posts) it stays red (Variable 'userstatus' not defined).

Am I doing something wrong?