DSXchange

How can I do a full outer join using Hash. I need to get the ColA value if it is present either in the driving file or the look-up file.

-Thanks

The zeros were not being stripped. It was just that the CFF stage not displaying them... I used UltraEdit to view the Hexadecimal equivalent of the leading zeros.

Thanks

The problem was with 'Line Termination' in the Sequential file. When I changed the Line termination form UNIX(LF) to DOS style(CR LF) all the records appear in separate lines when viewed with Notepad.

Could someone suggest any Cobol file viewer which would help to know if the generated file is correct. I am able to view all the records properly in the created ebcdic file using a CFF stage. But when the file is viewed using a text editor all the rows appear in a single row . This happens only for ...

Thanks for all your suggestions... This is how I have implemented this...(I forgot to mention that I get the total no of records in the header) I have initially parsed the header based on the Start rec# and End record # (0& 1) and stored the 'NumberOfRecs' into a hash file. The hash file is then...

How can I parse header, detail and trailer of the incoming file using the CFF stage if no 'ID field'( a unique number to indicate Hdr, detail and Trlr) is provided in the input file. I can get the header by specifying the 'Start Rec #' and 'End Rec #' in the Selection criteria as 0 and 1 but how can...

Thanks for the suggestions!! Used Stage variables and its great.

-Davis

I need to convert the numbers usually padded with zeros to a packed decimal number (eg:00000123456789). I am using a routine to do this but all the leading zeros are being stripped. InputNbr = Oconv(InputNbr, "MCN") Ans=iconv(InputNbr, "MP") Guess this has to do with the Options....

Hey, I am looking for a way to concatenate all the reject codes that are generated as part of Data validation. All the reject codes from invalid lengths, incorrect dates, record count mismatch etc are to be written as space delimited column and appended to the incoming record and sent as reject file...

Hi, I have recently upgraded from V6 to V7.1 and when I am trying to compile the DataStage jobs I get the following message "Unable to write record DSJobName to file RT_CONFIG517" and the Compile Status says "Compile failed to save intermediate results!" Does this have to do anyt...

I am trying to create the sequence numbers as per the discussion http://www.dsxchange.com/viewtopic.php?t=60 When I give $ENV at runtime I am expecting the total number of nodes(4 in my case) Here is the sequence I implemented: 1) Add a new Env variable APT_PARTITION_COUNT in the Administrator at th...

I am trying to generate unique Sequence numbers using the Enviroment variables APT_PARTITION_COUNT and APT_PARTITION_NUMBER for my Parallel Jobs. I added 'New Environment Varible' by specifying the 'Name' and 'Prompt' for these variables. ( eg: APT_PARTITION_COUNT and Partition Count). I am using a ...

Thank you T.J.
I have sent a request to the Ascential support.

Regards,
Davis

Hi,

Can someone suggest me where I can look for Orchestrate documentation. I failed to find it on the Ascential website.

Thank You,
Davis