Search found 47 matches
- 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...
- 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
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- Wed Jun 17, 2009 8:46 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Count the records and print at end.
- Replies: 7
- Views: 12655
- 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
- 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
- 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...
- Wed Jun 03, 2009 7:58 pm
- Forum: Admin Announcements
- Topic: STAR MEMBER AWARD - FOR MAY 2009
- Replies: 27
- Views: 51924
- 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...
- 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...