DSXchange

When migrated from Test to production, I am getting what I think is a config or environment error stating "RECORD DSDB2 in file DS_STGETYPES does not exist". Also, my DB2 table objects have a "plug and socket" icon now. Is this correct? Is there a setting or config type option th...

Doing it in DataStage is ugly, that's why I gave you an "elegant" SQL solution. Write source table "A" into a hash file, leaving the B phone number column blank. Read source table "B" and reference the hash file, if the row is there, add the B phone number to the B pho...

chulett wrote:Just as an FYI for those in our studio audience using Oracle as their database of choice, there is actual "Full Outer Join" syntax available in 9i:

Code: Select all

SELECT a.x, b.x
FROM a FULL OUTER JOIN b
ON (a.y = b.y)

DB2 is my DB env. in DataStage. How do you implement this in DataStage?

Hello I have two input tables with 3 keys. I am taking some fields from both tables and putting them into another table. Based on the two input tables, I have a phone type field with values either "BUSINESS" or "HOME" and this indicates which type if the phone number. The tables ...

Hi, The Partitioner stage partitions data, it is processed in parallel, then the Collector stage collects it together again before writing it to a single target. A sequential file can be input to Link Partition Stage. which can take up to 64 links and colects data from this link (Link Collector) an...

Oh Boy, what a coincidence, right now I'm working on the same thing, I need to find out how to do this, I'm trying different stuff but nothing seems to work, Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in ...

I am trying to use a Link Paritioner to see if it would speed up our 2 million row load. However, I am not sure how to set it up. Where do I link? I am getting an error. Is the link partitioner output from the transformer stage or the input file stage?

Oh Boy, what a coincidence, right now I'm working on the same thing, I need to find out how to do this, I'm trying different stuff but nothing seems to work, Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in ...

I received this error a few times before. It turned out that the log files were full and needed to be either deleted or erased. The next time, the job somehow were corrupted and I created it with another name, then deleted the corrupted one. From then on, I did not get the error again. It may sound ...

I do not have any constraints in the input file but have a database error or warning, how do I write those records to a reject file. Based on a couple of suggestions and the help menu, I have tried the linkname.REJECTED option and created a new output link. Thanks for all of your input and advice, I...

I have several warnings in my log file due to some ICONV conversions that I did to convert Char values to dates, which worked. However, since there are nulls and PeopleSoft fields all have Not Null constraints that cannot be removed, I had to use an If Else statement. See log error below: DA_DEPT_EX...

I have a DB2 column and cannot populate it. My derivation is Ereplace(Oconv(Iconv(DataIN.EFFDT,"D-YMD[4'',2'',2]"), "D-YMD[4'',2'',2]"),"-",''). Here is one of the error messages: Attempt to convert String value "2004 06 28" to Date type unsuccessful Some valu...

How do you set up a breakpoint and get and/or watch the value from the particular link? Do you do this in Director or Designer?

First - the solution you asked for is: "DYMD[4'',2'',2]" [Two single quotes next to each other, following the 4 and the first 2] This says you want nothing as the delimiter. As others have said, I think you are wanting OCONV, not ICONV. Second - please tell us more of what you are doing. ...

After doing the straight value, the output came in this format: 7385-10-08 Do not code any conversion in derivation, just bring the value over to new field unchanged.[/img] That is what I did. DATE1 --> DATE1 I brought the value over with no derivations at all. It is because the char to date data t...