McaVishalGupta,
I'm pretty sure that this is due to lowvalues / junk in your files.
Remove them and try it.
It will work.
Thanks!
Search found 15 matches
- Mon Feb 27, 2012 10:39 am
- Forum: JCL
- Topic: Email sending Problem
- Replies: 10
- Views: 14305
- Sat Feb 25, 2012 8:36 am
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 154846
- Sat Feb 25, 2012 8:29 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: If (Input File = Table) -> Write-to (Output file)
- Replies: 1
- Views: 5113
If (Input File = Table) -> Write-to (Output file)
Input File:
abc123
def455
ghi347
Db2 Table data:
amnjgh
def798
anh762
ksj934
ghi121
Output file:
def798
ghi121
How will you do this with cursor?
Can we do this without cursor? If yes, how?
P.S: Not using the CODE tags for highlighting purposes...Thanks!
abc123
def455
ghi347
Db2 Table data:
amnjgh
def798
anh762
ksj934
ghi121
Output file:
def798
ghi121
How will you do this with cursor?
Can we do this without cursor? If yes, how?
P.S: Not using the CODE tags for highlighting purposes...Thanks!
- Sat Feb 25, 2012 8:22 am
- Forum: COBOL INTERVIEW QUESTIONS
- Topic: Editing a Copybook - How to?
- Replies: 2
- Views: 6716
Editing a Copybook - How to?
You have some changes to be made in a copybook.
Like adding a new field and renaming another field.
What all precautions should you take when doing this???
How will you proceed?
Like adding a new field and renaming another field.
What all precautions should you take when doing this???
How will you proceed?
- Thu Feb 23, 2012 7:09 pm
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: VARCHAR in DB2
- Replies: 4
- Views: 8426
- Thu Feb 23, 2012 4:24 pm
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: Regarding Cursor
- Replies: 4
- Views: 9198
- Thu Feb 23, 2012 8:42 am
- Forum: JCL INTERVIEW QUESTIONS
- Topic: concatenate datasets using multiple sortin
- Replies: 10
- Views: 22800
- Thu Feb 23, 2012 8:34 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: VARCHAR in DB2
- Replies: 4
- Views: 8426
- Thu Feb 23, 2012 8:30 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: Where would you specify the DECLARE CURSOR statement?
- Replies: 4
- Views: 8038
- Thu Feb 23, 2012 8:27 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: Regarding Cursor
- Replies: 4
- Views: 9198
- Thu Feb 23, 2012 8:26 am
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: FILLER is executable or not?
- Replies: 4
- Views: 8789
- Thu Feb 23, 2012 7:27 am
- Forum: COBOL INTERVIEW QUESTIONS
- Topic: how to refer the data field?
- Replies: 3
- Views: 8986
- Thu Feb 23, 2012 7:26 am
- Forum: COBOL INTERVIEW QUESTIONS
- Topic: I want to find the 50th city code.how?
- Replies: 4
- Views: 12145
- Thu Feb 23, 2012 7:13 am
- Forum: JOB DISCUSSION
- Topic: IBM Mainframe Training to corporate & individuals
- Replies: 2
- Views: 4492
- Thu Feb 23, 2012 7:07 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Necessity of Group by CLAUSE
- Replies: 1
- Views: 3742
If there is an orders table with customers and price of the goods they have bought. Then, If you want to get the total amount they have spent on the goods, the below query will help. Example: SELECT Customer,SUM(Price) FROM Qual.Orders GROUP BY Customer; Customer SUM(Price) ________ __________ Amar ...