Writing to Hash File

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
spracht
Participant
Posts: 105
Joined: Tue Apr 15, 2003 11:30 pm
Location: Germany

Post by spracht »

John

most likely, 2 of your records are equal in their key values. If this is the case, the earlier record is overwritten by the later. You can only have one record per key expression in a hashfile.

Stephan
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

JD

Your last line may not have a CR/LF on the end.

Kim.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If your text file lacks a final end-of-line character you can add one (for example use ExecSH to do echo "" >> filename) in a before-job subroutine.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
ariear
Participant
Posts: 237
Joined: Thu Dec 26, 2002 2:19 pm

Post by ariear »

I think there is a bug in the view file in DS 6 . Try reading from this hash and write to a seq file just for checking.
Post Reply