DSXchange

Hi, My job has two sources for Join Stage, 1 of them is DB2 API Stage connected to MVS DB and the other is DB2 EE Stage connected to AIX DB2. The Join Stage use column 'FILE_ID' as Join Key to perform a Left Outter join. The mode of this Join Stage is Defaulf(Parallel) and the Partition Type in the ...

Hi, I have a flat file which will be loaded into DB tables everyday.Suppose for example, if I get 10 records today in the flatfile,I need to assign a Surrogate Key to these records and load it into the DB table.So next day, when I get new set of records I need to track the highest Surrogate Value in...

Hi Guys, I'm wondering that whether there is such stage in DataStage 7.5.x could perform external scripts, shell scripts in Unix I mean, or not. I wanna perform a shell script before a job running, and also perform 2 shell scripts after a job running successfully or unsuccessfully respectively. If t...

Hi All,

I have a sequential file having some records say 20(This is not fixed it may change)..I need to get 20th record(last record of file) for loading into some other table..will that be possible with Transformer stage..if so how to do that..plss let me know if any of u have some solution..

Hi all, I'm trying to read a csv file and convert it to an output file to be read by another program. The problem I'm having is with embedded single quotes in the input file. For example, if I have in the input csv file: 123,Michael's Place,123 Main St. I want the output to look like: '123' 'Michael...

Hi,. I am having a simple job to identify the deletes and inserts from the source and flag the records. I am using a merge stage instead of lookup so that i can capture the deleted records from the source. when i try to run the job, its getting struck at the merge stage. even with 1 record its not r...

I have a requirement where in i need to join 2 tables based on 2 keys. But the keys will change according to value of one column in reference table. Scenario is: Table A is primary table and Table B is reference table. and the keys are key1 and key2. Now I need to join these tables on both the keys ...

HI,Can anyone please suggest me the procedure to implement a TYPE 2 SCD in Parallel jobs although I am familiar with server jobs SCD2, where the changed columns are updated and the new columns are inserted and also new rows for the Effective Date column and Expiry date column are created or say vers...

I'm trying to lookup an oracle table in a server job & when I compile I receive this message. I have no constraints in my transform stage. What am I doing wrong? Pin\%%V0S1P17.Column\%%1 = #<>~ ^ "GE" unexpected, Was expecting: Assignment Operator 1 Errors detected, No Object Code Prod...

can any one please how to implement reject link in join stage? i have data to be joined and if i get any rejects in the data i have to store it in reject link.

Hello, no, we don't get timeouts. System is runing fine since months. Only this problem exists. For your information a put here some output of the logs form &PH&: DataStage Job 2338 Phantom 570 CRITICAL ERROR! Notify the system administrator. DataStage Job 2330 Phantom 15605 Program "D...