 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 11 matches |
| Author | Message |
|---|---|
 Topic: Adjustment Amounts |
|
| nag77 Replies: 2 Views: 1372 |
 Forum: Database Posted: Fri Feb 24, 2006 12:27 am Subject: Adjustment Amounts |
| Hi,
I have to get the sum of the amounts for an account number till the current year. The conditions are that all amounts with Indicator = 'C' should be added and all the amounts with Indicato ... |
|
| Topic: Combine 2 files with diferent fields as 1 record |
|
| nag77 Replies: 2 Views: 1494 |
Forum: Utilities Posted: Fri Feb 10, 2006 1:11 am Subject: Combine 2 files with diferent fields as 1 record |
| Hi
I have two files,want to concatenate the different fields in those two files using sort step. for example first 4 fields from the first file and last 3 fields from the second file. thanks ... |
|
| Topic: Pad Zeroes for a Numeric item |
|
| nag77 Replies: 1 Views: 964 |
Forum: Application Programming Posted: Sat Jan 28, 2006 8:30 am Subject: Pad Zeroes for a Numeric item |
| Hi
I have one variable named as numeric-item with SIZE 10. Some NIs are with size 5 and 0 NI ----- 1243231231 1243231231 12432BBBBB 12432BBBBB BBBBBBBBBB B denotes Blank Space. ... |
|
| Topic: String |
|
| nag77 Replies: 3 Views: 12370 |
Forum: Application Programming Posted: Sat Jan 28, 2006 6:17 am Subject: String |
| Hi kolusu
STRING EMP_NAME SPACE VAR_NAME2 DELIMITED BY SIZE INTO VAR_NAME3 when i am trying with this ,I am getting errors. Thanks NAG |
|
| Topic: Pad Zeroes for a Numeric item in a Db2 table |
|
| nag77 Replies: 3 Views: 1584 |
Forum: Database Posted: Sat Jan 28, 2006 6:05 am Subject: Pad Zeroes for a Numeric item in a Db2 table |
| Hi kolusu
I have other variables also in this table ex: Fn pic x(10). Ln Pic x(10). NI pic x(10). when this case i have to give the que ... |
|
| Topic: String |
|
| nag77 Replies: 3 Views: 12370 |
Forum: Application Programming Posted: Sat Jan 28, 2006 5:52 am Subject: String |
| Hi
I have a string "BHARAT KUMAR", I am moving this string to another variable with size 20. How can i delimit the size in the variable,spaces should not be contianed in the string. How ca ... |
|
| Topic: Pad Zeroes for a Numeric item in a Db2 table |
|
| nag77 Replies: 3 Views: 1584 |
Forum: Database Posted: Sat Jan 28, 2006 5:12 am Subject: Pad Zeroes for a Numeric item in a Db2 table |
| Hi
I have one variable named as numeric-item with SIZE 10. Some NIs are with size 5. NI ----- 1243231231 1243231231 12432 12432 If the 6th-10th bytes are not available ,I have to insert ... |
|
| Topic: Maximum balance without duplicates |
|
| nag77 Replies: 2 Views: 1340 |
Forum: Database Posted: Tue Jan 24, 2006 8:45 am Subject: Maximum balance without duplicates |
| THANKS KOLUSU | |
| Topic: Maximum balance without duplicates |
|
| nag77 Replies: 2 Views: 1340 |
Forum: Database Posted: Tue Jan 24, 2006 7:38 am Subject: Maximum balance without duplicates |
| Hi,
I have a table with 5 cols.. Name SSN Balance opening Date closing date Rahul 001 10,000 12/01/06 12/01/06 Priya 002 20,000 12/01/06 12/01/06 Shukla ... |
|
| Topic: Problem in Balance amount |
|
| nag77 Replies: 1 Views: 1078 |
Forum: Database Posted: Fri Jan 13, 2006 12:51 am Subject: Problem in Balance amount |
| Hi
We have a database ,in which we have lot of aCcount details. If we select two account numbers (Say A/c No:00070 and A/c no :00080) the available balance it shows 10,000 and 20,000 respec ... |
|
| Topic: JCL which retrives fields from a file. |
|
| nag77 Replies: 2 Views: 1193 |
Forum: Job Control Language(JCL) Posted: Tue Jan 03, 2006 11:09 pm Subject: JCL which retrives fields from a file. |
| Hi
I am trying to develop a Jcl which retrieves some fields from a file.Provide some sample jcl which can help to retrive fields from a file. Thanks in advance NAG |
|
All times are GMT - 5 Hours |