 |
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 21 matches |
| Author | Message |
|---|---|
 Topic: Put a Seqnum for all rows selected |
|
| dhulipalla Replies: 9 Views: 3846 |
 Forum: Database Posted: Mon May 21, 2007 10:25 am Subject: Put a Seqnum for all rows selected |
| Hi,
Is there a way I can get the desired result. COLA COLB ---- ---- AAA AAA AAA BBB BBB BBB EXPECTED RESULT: --------------- COLA COLB ---- ---- AAA 1 AAA 2 AAA 3 BBB ... |
|
| Topic: Creating a multiple generations in COBOL Program |
|
| dhulipalla Replies: 1 Views: 1385 |
Forum: Job Control Language(JCL) Posted: Tue Sep 05, 2006 2:15 pm Subject: Creating a multiple generations in COBOL Program |
| Is there a way to create multiple GDG generations in using COBOL?
Ex: I/P --- Records 1 - 1000 Records 2 - 2000 Records 3 - 3000 o/p ---- G0001v00 Records 1 - 1000 G0002v00 Records 2 ... |
|
| Topic: SQL Query for getting Rows into Columns |
|
| dhulipalla Replies: 2 Views: 1517 |
Forum: Database Posted: Wed Jan 18, 2006 9:37 am Subject: SQL Query for getting Rows into Columns |
| Thanks Kolusu.. | |
| Topic: SQL Query for getting Rows into Columns |
|
| dhulipalla Replies: 2 Views: 1517 |
Forum: Database Posted: Tue Jan 17, 2006 1:01 pm Subject: SQL Query for getting Rows into Columns |
| Hi,
ONE TWO 001 A 001 B 001 C Is ther a way i could get my output like 001 A,B,C |
|
| Topic: Reading 1 record from all generations |
|
| dhulipalla Replies: 3 Views: 2272 |
Forum: Utilities Posted: Fri Dec 16, 2005 10:09 am Subject: Reading 1 record from all generations |
| Kolusu,
We are not sure of having the same no of generations all the time, in that case is there any alternative.. In my shop if we dont open / refer a dataset for certain time period it is goin ... |
|
| Topic: Reading 1 record from all generations |
|
| dhulipalla Replies: 3 Views: 2272 |
Forum: Utilities Posted: Thu Dec 15, 2005 2:53 pm Subject: Reading 1 record from all generations |
| I have a GDG with 10 generations. Suggest me in opening all the generations and read one record from each generation using FileAid | |
| Topic: Get the matching records from 2 diferent files |
|
| dhulipalla Replies: 30 Views: 57920 |
Forum: Utilities Posted: Sun Nov 20, 2005 7:49 pm Subject: Get the matching records from 2 diferent files |
| Kolusu,
I handled that part and I am new to writing a program which handles Header and Trailer..In other terms how can I validate the Header and Trailer while reading? |
|
| Topic: Get the matching records from 2 diferent files |
|
| dhulipalla Replies: 30 Views: 57920 |
Forum: Utilities Posted: Sun Nov 20, 2005 7:30 pm Subject: Get the matching records from 2 diferent files |
| Kolusu,
There are 2 files file1 and file2, both are having the same layout. HEADER FIELD1 X VALUE '1' FIELD2 X(6) VALUE 'HDRABC' FIELD3 X(10) VAL ... |
|
| Topic: Passing data into a query |
|
| dhulipalla Replies: 5 Views: 2807 |
Forum: Job Control Language(JCL) Posted: Fri Nov 18, 2005 10:03 am Subject: Passing data into a query |
| Kolusu,
I got the required query...here is the one.. SELECT FIELDS FROM TABLENAME ... |
|
| Topic: Passing data into a query |
|
| dhulipalla Replies: 5 Views: 2807 |
Forum: Job Control Language(JCL) Posted: Thu Nov 17, 2005 9:50 pm Subject: Passing data into a query |
| Kolusu,
I do have some similar requirement where I need to pass the last month(mmyyyy) to the query..Is there a way to accomplish the task? |
|
| Topic: Populate Primary code to secondary code rows using SQL |
|
| dhulipalla Replies: 8 Views: 4125 |
Forum: Database Posted: Wed Nov 16, 2005 6:46 pm Subject: Populate Primary code to secondary code rows using SQL |
| Kolusu,
That's working fine..Thanks.. |
|
| Topic: Populate Primary code to secondary code rows using SQL |
|
| dhulipalla Replies: 8 Views: 4125 |
Forum: Database Posted: Wed Nov 16, 2005 9:40 am Subject: Populate Primary code to secondary code rows using SQL |
| Kolusu
We can tie the PCODE BBBBB, CCCCC with XXXXX. SCODE PCODE TYPE ----- ----- ---- XXXXX AAAAA P XXXXX BBBBB S XXXXX CCCCC S In this case XXXXX is having AAAAA ... |
|
| Topic: Populate Primary code to secondary code rows using SQL |
|
| dhulipalla Replies: 8 Views: 4125 |
Forum: Database Posted: Wed Nov 16, 2005 9:08 am Subject: Populate Primary code to secondary code rows using SQL |
| Kolusu,
I have a table with the following data where each SCODE is having multiple PCODEs with type P & S SCODE PCODE TYPE ----- ----- --- XXXXX AAAAA P BBBBB S ... |
|
| Topic: Populate Primary code to secondary code rows using SQL |
|
| dhulipalla Replies: 8 Views: 4125 |
Forum: Database Posted: Tue Nov 15, 2005 11:50 pm Subject: Populate Primary code to secondary code rows using SQL |
| Shekhar..I formatted my data..thanks for your suggestion..
Table ----- Scode char(5) Pcode char(5) type char(1) having values p/s XXXXX AAAAA P BBBBB S CCCCC S YYYYY DDDDD ... |
|
| Topic: Populate Primary code to secondary code rows using SQL |
|
| dhulipalla Replies: 8 Views: 4125 |
Forum: Database Posted: Tue Nov 15, 2005 9:54 pm Subject: Populate Primary code to secondary code rows using SQL |
| Table
----- Scode char(5) Pcode char(5) type char(1) having values p/s XXXXX AAAAA P BBBBB S CCCCC S YYYYY DDDDD P EEEEE S FFFFF S ... |
|
All times are GMT - 5 Hours |