View previous topic :: View next topic
|
Author |
Message |
rammf Currently Banned New User
Joined: 24 Jul 2005 Posts: 17 Location: chennai
|
|
|
|
Hi
Can any one tell How to find out or retrive Last rec in a sequential fil? and KSDS file also |
|
Back to top |
|
|
rammf Currently Banned New User
Joined: 24 Jul 2005 Posts: 17 Location: chennai
|
|
|
|
How to resolve Time stamp Error? Explain Briefly
answers are Appriciated.
Cheers.,
Ram |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
hi frnd,
Quote: |
How to find out or retrive Last rec in a sequential fil? and KSDS file also |
In sequential file just read the record one by one until the EOF is reached.
Quote: |
How to resolve Time stamp Error? |
if u give me the exact detail then let me try |
|
Back to top |
|
|
Hames
New User
Joined: 03 Oct 2005 Posts: 49
|
|
|
|
Hi Ram,
Quote: |
How to resolve Time stamp Error? Explain Briefly |
Check:-
Did you bind the correct DBRM member?
Have you bound in the correct DB2 sub-system?
Are you running with the correct load library?
You should check each step of the compile/bind job, and then check the job that runs the offending program.
Also go thru this previous post:
[url] www.ibmmainframes.com/about621.html [/url] |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Quote: |
How to find out or retrive Last rec in a sequential fil? |
I remember this topic been discussed earlier too.
Well, I'll suggest adding a SEQ number to each rec & SORT the file DESCENDING & then read First record.
Regards,
Priyesh. |
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
If you have FileAid you can use to do what you want. It works for KSDS too.
Code: |
//COPYKEY EXEC PGM=FILEAID
//DD01 DD DSN=YOUR.FILE
//DD01O DD DSN=file.that.contains.last.rec
//SYSIN DD *
$$DD01 COPYBACK OUT=1
|
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
Can any one tell How to find out or retrive Last rec in a sequential fil? and KSDS file also |
You can now do this kind of thing quite easily using the new SUBSET operator of DFSORT's ICETOOL available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008) like this:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT DD DSN=... output file
//TOOLIN DD *
SUBSET FROM(IN) TO(OUT) KEEP INPUT LAST
/*
|
For complete details on the new SUBSET function and the other new functions available with PTF UK90013, see:
Use [URL] BBCode for External Links |
|
Back to top |
|
|
|