Search found 18 matches

by kunnu
Sat Jul 23, 2011 5:45 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Matrix logic using ICETOOL.
Replies: 1
Views: 2601

Matrix logic using ICETOOL.

Hi, Could you please help me in getting the desired output through ICETOOL. Explanation: The records from both the input files should be matched based on the field EMPNO and needs to be written in the fashion as shown below. The output should written as a matrix form which you will be able to exactl...
by kunnu
Fri Jun 17, 2011 8:50 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging of two files with non-unique keys.
Replies: 8
Views: 10211

Thanks Frank for the given solution.....but unfortunately the given functions like JOINKEYS doesnt work on my machine as I dont have the latest version of Syncsort installed. Would you mind giving me the solution which would work by using simple ICETOOL. Please help me with this.

Thanks
Kunnu
by kunnu
Thu Jun 16, 2011 10:50 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging of two files with non-unique keys.
Replies: 8
Views: 10211

Frank, Extremely sorry for the inconvenience caused. Yes you are correct the key is DEPT to be matched on. Also the way you are assuming my output to be is exactly correct. I have provided you the expected output for the scenario you have mentioned. Please do have a look and let me know if you have ...
by kunnu
Thu Jun 16, 2011 2:33 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging of two files with non-unique keys.
Replies: 8
Views: 10211

Guys please help me on this.
by kunnu
Thu Jun 16, 2011 8:51 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging of two files with non-unique keys.
Replies: 8
Views: 10211

Ohhh GOD....guys one more mistake....i think my mind is not stable with this issue...please forgive me.....please have a look at the below output and ignore the above mentioned output. Output: DEPT LOC SAL 001 UK 1001 001 BRA 2000 002 HOL 2002 002 SWI 3003 003 CAN 4000 004 GER 4004 004 IND 6000 004 ...
by kunnu
Thu Jun 16, 2011 8:32 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging of two files with non-unique keys.
Replies: 8
Views: 10211

Actually in the above output structure I have mistakenly given the last record with DEPT as 006...that can be ignored....apologies.....could you please let me know the desired solution.
by kunnu
Wed Jun 15, 2011 5:42 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging of two files with non-unique keys.
Replies: 8
Views: 10211

Merging of two files with non-unique keys.

Hi, Could you please help me in getting the desired output. Explanation: The records from the file-1 will be placed first and below that the file-2 will be placed. The output file should have matching records from both the files by overlaying the records from the file-2. If the file-1 has 1 record a...
by kunnu
Mon May 30, 2011 9:52 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Hello,

Please can you help me on the above issue.

Thanks in advance
Kunnu
by kunnu
Sun May 29, 2011 10:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Thanks for the solution Frank and Dick. In the above given input i have a got a small requirement. Please help me on this. In the input after the age field there are blank hexadecimal values i.e. there should not be F0F0F0F0 just complete blank hexadecimal. I want the same blanks to be copied in the...
by kunnu
Thu May 12, 2011 1:54 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Hi Frank,

Sorry to bother you but can you please help me with this.
by kunnu
Wed May 11, 2011 11:18 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Thanks once again for your quick reply. The expected output exactly is my requirement which I have mentioned above. And yes as mentioned in my last record even, I dont want the blank (as on the 10th character) to be appeared in the output. So the output should be just *DAVIDJONE* i.e blank to be tru...
by kunnu
Wed May 11, 2011 7:13 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Hi Frank, I have executed the above code but it is not giving the required output also as mentiond above. for e.g. in the input name field is given as ,BILLIE GILLS, and in the output it should be as *BILLIE GIL* whereas the code which I executed showed as *BILLIE GILLS*. Could you please help with ...
by kunnu
Mon May 09, 2011 10:52 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Thanks a ton Frank.....If you dont mind could you please explain what the below lines of code is doing

IFTHEN=(WHEN=INIT,FINDREP=(INOUT=(C',',C'*',C' ',X'FF'))), and
IFTHEN=(WHEN=INIT,FINDREP=(IN=X'FF',OUT=C' '))
by kunnu
Mon May 09, 2011 8:56 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse in ICETOOL.
Replies: 12
Views: 14093

Parse in ICETOOL.

Hi, Could you please help me in getting the desired output. Explanation: The input is a comma delimited and want the output to be written as replacing comma with * as shown below. Also the field STATUS and its value in all the records and header should be written as %, The EMPNO should be written as...
by kunnu
Thu Jan 13, 2011 4:49 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Report writing in ICETOOL
Replies: 6
Views: 6344

Thanks a lot Frank....;-:

In the above report for the place field, it should print only once as shown in my output report above. Please do let me know how to achieve this scenario.

Thanks in advance.
Kunnu