Hi Ray, Thanks for your reply & input. I tried the solution you gave. This is what I got. File C ------------ 100 ABC 1001 1 (keyChange) 100 ACE 2002 1 200 ASD 2001 1 200 ASD 2003 0 300 3001 1 400 XYZ 2005 1 400 XYZ 2005 0 500 DEF 2000 1 500 DEF 2000 0 I somehow couldnt group the records using a...
Hi All, Requesting your thoughts/expertise to arrive in a breakthrough for one of my project requirement in DataStage. The requirement is as follows, I have 2 files A (Master File) & B (New Record/Update to existing records file). I need to combine both these files(I will use Join Stage here) &a...
Hi Ray, Thanks for your response. To answer your point, mainframe is not expecting "masked decimals". Let me put it this way, We have a field A with datatype PIC -9(15).99.While it goes to MF system, the '.' gets truncated. We have defined this field as CHAR(19). Is there anyother way we c...
Hi All, I have a CFF stage as Target for my DataStage Parallel Job. We create this file, transmit it to MF system to do a comparison. However, when the files are NDM'd to the Source MF system, the '.' symbol of the decimal values are getting truncated due to which the comparison fails. For e.g: a de...
Hi All, I have a requirement for a Date field in one of my DataSTage job where I need to do a (DATE - 6 months) function. The Input Source is a flat file & we need to perform this calculation before getting the data loaded to the Target Table. Setting an example of the scenario here, It would be...
Thanks Hester for your reply. I dont have the privilege to login to the Administrator. I will check with the ETL admin tomorrow morning on this option. In the mean time, Is there any other way in which we can resolve this issue within the DataStage job? (like any option settings/transformation etc?)...
Hi All, Thanks for looking into this post. I have an issue which has come just couple of days before the Prodcution Implementation. Pls help me with a resolution. I am reading the data from DB2 tables & generating an extract. The extract generated has a SPECIAL CHARACTER in it due to which the d...
Hi All, I have a char field (length is 8) where I receive values like below, 88@b800 900#@12 123&c99 etc.... I need to replace the special characters & characters in it with Zero, My output should be as below, 8800800 9000012 1230099 Can you pls let me know how we can accomplish this in Para...
Thanks Ray for your reply. My understanding is, RCP will not work when the Source metadata & target metadata differs ( I have 2 additional columns in the target based on a derivation on couple of source columns). One other query I have is, I can get the OSH generated from the Designer ----> Job ...
Thanks Ray for your Reply. Since the requirement is to extract the data from 150 DB2 tables & load into another set of similar tables in a different region, we dont want to create 150 DS jobs for the same. (Table to Table Load) Can you pls let me know how to create OSH Scripts & make it gene...
Hi All, I have a requirement in my project where we have around 100 tables. We have to extract the data from Source Table & load it to Target Tables. Can we do it through OSH Scripting- This is the client requirement (A generic Script)? If yes, where can i find some useful information related to...