DSXchange

If it is variable width , Under the Format tab of sequential file If I specify the delimiter as 013 and Line Termination as UNIX style, then I can see all the LINE's. Actually iam expecting a file with Line Terminator either fixed width or variable width.So,How can i put a Line terminator if I dont ...

Actually iam expecting a file with Line Terminator either fixed width or variable width.So,How can i put a Line terminator if I dont receive it in the file? Should the file be fixed width with end of line terminators or no end of line terminators just 100 characters per "record"? There's a...

I have a input file which is fixed width of 100.But, sometimes i am receiving it with Line Terminator and sometimes without any Line terminator.How can i handle this?.

I would be grateful If anyone could shed some light on this?.

Thanks in advance.

Hi Sunshine, Yes. you are right.But my requirement is slightly changed and i need to get the 'Col1' value if col2<>4. Thanks for your time. My requirement is for my input record 'a' look for the value in reference data if it finds the key value , then it should check the col2 value=4 or not. If the ...

Hi, I want to captur the innermost 'Col1' value not the 'Col3'. Thanks for your time. Hi, I have used Ray's code and got the expected output you require. First Load your input data in a Hash File say HASH_RECURSIVE Create a Transform Function ReadRec as follows: DEFFUN ReadRec(X) Calling "DSU.R...

Ray, After reconnecting to the DS client also, i am not getting the expected value.I'm getting result as blank or might be empty space. Am i missing anything here. Thanks for your time. COMMON remains active while you're connected. Hence the error about changing its size. You need to disconnect your...

Ray, I have declared the another variable 'var1' as you suggested in the COMMON. I have assgned the value Rec<0> to the 'var1'. But, iam not getting the value.Please find the following results. FUNCTION ReadRecord(Arg1) DEFFUN ReadRecord(X) Calling "DSU.ReadRecord" COMMON /ReadRecord/Initi...

Ray, How can i lodge it in a COMMON?. you mean to say, declaring a variable at COMMON like file variable.If i declare a variable at COMMON, how can i assign the innermost key value to that variable.Please explain me. Thanks in advance for your time. Col1 is Arg at the innermost call. Lodge it in a C...

Ray, Thank you very much for your help. In the above routine, i want to capture the 'Col1' if Col2<>4.For that, what i did is: Read Rec From HashedFile.fvar, Arg Then Col2 = Rec<1> Col3 = Rec<2> If Col2 = 4 Then Ans = ReadRec(Col3) ; * recursive call Else Ans = Rec<0> But i didn't get the Col1 value...

Ray, I have one column in my input which is a key, col1 a and My reference link data is col1 col2 col3 a 4 b b 4 c c 4 d d 1 e where col1 is key. My requirement is for my input record 'a' look for the value in reference data if it finds the key value , then it should check the col2 value=4 or not. I...

Hi, Here, iam not able to open my Hash file by giving the full path.It always going to else part only. could you please explain it. Naren, Here is a shell program that is a "hint" - it doesn't use COMMON to skip re-opening the file and only uses a simple key, one column with your 0 or 1 ST...

Hi all, Let me put my requirement in this way, Input Data: a,b b,c c,d Output Data should be like a,d b,d c,d Any clues pls. Thanks Naren Provide a DEFFUN declaration that refers to the function itself. DEFFUN MyRoutine(Arg1, Arg2) Calling DSU.MyRoutine Then, within your routine, you can invoke it r...

Hi I am trying to write the routine to do a recursive lookup to the same hash file.But iam out of luck.Could anyone please help me to write a routine. Thanks in advance. Load the data to a hash file, then write a routine to do a recursive lookup to the same hash file. Recurse until a read fails. The...

could anyone please shed some light on how to write the recursive routine. Thanks in advance. Naren, this can be done with either a recursive lookup or a loop within a routine. You could chain lookups in a job, but you could only link back one level per lookup - if you know your maximum depth of rec...

Hi, I have a input record like: col1 col2 col3 66 41 55 Ref table data like: col1 col2 col3 Status 66 41 55 1 66 41 56 66 41 56 1 66 41 57 66 41 57 0 66 41 58 What i need to do is, I have to look for the record with 66 41 55 in the ref data and If finds the record then check for the status. If the s...