Search found 47 matches

by anilanju
Wed Feb 08, 2012 7:48 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: need to retrive diff records from same table using diff crit
Replies: 0
Views: 2227

need to retrive diff records from same table using diff crit

HI i have a table who has many col. one col is ref as parent record and other col as its child record. ex : I need a record with this selection .this is a parent one qry1 : Src='IPT' and ID='125AG' and then below this record i need its child records which will be selected using qry 2 : AG_ABC_SRC='I...
by anilanju
Thu Jan 19, 2012 4:54 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need to replcae hexadecimal value in FB format file
Replies: 2
Views: 5414

Hi

Thanks it workied. I used X'41' in Input and used c' ' in out.
worked fine

Thanks
by anilanju
Wed Jan 18, 2012 8:48 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need to replcae hexadecimal value in FB format file
Replies: 2
Views: 5414

Need to replcae hexadecimal value in FB format file

Hi I need to sort a file, replacing the special char to spaces. i am using OPTION COPY INREC FINDREP=(IN=(C'/',C'.',C'..'), OUT=C' ',STARTPOS=11,ENDPOS=120) Now i need to replace a hexadecimal value in the same file from 41 to 40. at any position in the file. How do i do that. i tried using this OPT...
by anilanju
Tue Jun 08, 2010 7:24 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Replace special characters with spaces
Replies: 1
Views: 5227

Replace special characters with spaces

Hi i have a file with rec len : 432, FB It has some special characters eg ( / , * , & , : ) at some positions between 10 - 30,which i want to replace with spaces.But the alteration should be between these column only.The position is not fixed for these special characters.It can be anywhere between t...
by anilanju
Thu Nov 12, 2009 2:05 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Removing duplicates to other file.
Replies: 4
Views: 6985

HI For records Starting with J and ending at X, we need a check at position 7-9 for 777,as i want to copy the record with 777 at position 7-9 to other file only. For rest of the duplicate records, we can move the first duplicate record to other file.For them there is no check on th second field. Tha...
by anilanju
Wed Nov 11, 2009 2:17 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Removing duplicates to other file.
Replies: 4
Views: 6985

HI Frank Yes i need the original data from header to trailer, with count changing in the trailer record. Yes the key position is from 1-6 only but along with that we need to put one more check at position 7-9. as i want to copy the record with 777 at position 7-9 to other file. The count only includ...
by anilanju
Tue Nov 10, 2009 6:05 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Removing duplicates to other file.
Replies: 4
Views: 6985

Removing duplicates to other file.

Hi I have a file of lenght=108 anf Rec format = FB. It has got hearder and trailer also. The problem is it has some duplicate records, i want to copy them into a saperate file. The data is as : HEAD00XYZ A 123 ABC 123 JOGX 456 JOG1X 456 JOGX 777 JRRX 456 JRR1X 456 JRRX 777 TRAILER08XYZ Here the firs...
by anilanju
Thu Jun 18, 2009 4:55 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Count the records and print at end.
Replies: 7
Views: 12655

Hi The code is working fine. but i just have small query. OMIT COND=(1,1,CH,EQ,C'T') SORT FIELDS=COPY OUTFIL FILES=OUT, TRAILER1=(1:C'T',1X, COUNT-1=(EDIT=(IIIIIIT))),REMOVECC END from this the trailer record i am getting is T 103235 i want these spaces to be removed, as the number of records is not...
by anilanju
Wed Jun 17, 2009 8:46 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Count the records and print at end.
Replies: 7
Views: 12655

Hi Alissa

Thank you very much. :D

Regards
by anilanju
Wed Jun 17, 2009 3:27 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Count the records and print at end.
Replies: 7
Views: 12655

Count the records and print at end.

Hi i need to count the number of recors in a fil and write them in the end of the file. example: HTEST 123968711BM 234968711CM 234968896BM 567968858DM 567968889AM TRILER HERE in trailer i want the number of records to be printed.example here total is 5. rec lenght: 38 rec format: FB Regards
by anilanju
Tue Jun 09, 2009 7:52 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to print non duplicates record from file without sortin.
Replies: 4
Views: 6759

Hi

The structure of file is:

HANJU 200812W07/06

abcabc123123
abcabc123124
abcabc123124
abcabc123125

T123456

the record lenght of file is 38 and record lenght is 27968

Thnx
by anilanju
Mon Jun 08, 2009 8:59 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to print non duplicates record from file without sortin.
Replies: 4
Views: 6759

How to print non duplicates record from file without sortin.

Hi I have 1 file.I need to eleminate the duplicate from it and move the rest of data to other file with same lenght record and record format. this file has got header and trailer also. But i dont want to perform any sort of sorting on it, i just want to remove the duplicate and move the rest data to...
by anilanju
Wed Jun 03, 2009 7:58 pm
Forum: Admin Announcements
Topic: STAR MEMBER AWARD - FOR MAY 2009
Replies: 27
Views: 51924

Hello Natrajan

Congratulation.

Thanks for your help.

Regards
by anilanju
Thu May 14, 2009 1:03 pm
Forum: JCL
Topic: Compare the total number of records in 2 files.
Replies: 7
Views: 11335

Hi The requirement has changed a bit. One file has a trailer record another one doesnot have. I just need to compare the number of records in both the files. How can i do that. Trailer record :ANU0000063852007-12-12 here from position 4 to 12 is the number ofr ecords in the file. but porblem is that...
by anilanju
Wed May 13, 2009 8:53 pm
Forum: JCL
Topic: Compare the total number of records in 2 files.
Replies: 7
Views: 11335

hi if the number is same in trailer records, then we need to perform further step and if they are diffrent they we ll not proceed further. the format of trailer record is ANU0000063852007-12-12 , starting from position 1. where 000006385 is the number of reocrds in tht file.and 2007-12-12 is the dat...