 |
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 25 matches |
| Author | Message |
|---|---|
 Topic: Split File but Like records should be copied together |
|
| 20cents Replies: 6 Views: 3276 |
 Forum: Utilities Posted: Thu Jul 20, 2006 10:21 pm Subject: Split File but Like records should be copied together |
| 20cents,
It is little trickier to get what you are asking. Is easytrieve an option? Kolusu We are currently using easytrieve to split the file. But, the performance team advised to change ... |
|
| Topic: Split File but Like records should be copied together |
|
| 20cents Replies: 6 Views: 3276 |
Forum: Utilities Posted: Thu Jul 20, 2006 8:00 pm Subject: Split File but Like records should be copied together |
/prays before the SORT-gods... answer my prayer please.  |
|
| Topic: Split File but Like records should be copied together |
|
| 20cents Replies: 6 Views: 3276 |
Forum: Utilities Posted: Thu Jul 20, 2006 2:59 am Subject: Split File but Like records should be copied together |
| shekar123,
First, thanks for the prompt reply. Yes. but do take note that records with the same account number (cols 1 to 10) must reside on the same file. 111111111A 111111111B 111111111C ... |
|
| Topic: Split File but Like records should be copied together |
|
| 20cents Replies: 6 Views: 3276 |
Forum: Utilities Posted: Thu Jul 20, 2006 1:50 am Subject: Split File but Like records should be copied together |
| I need to split a file into 3 files (equal as much as possible) but all same accounts (cols 1 to 9) must reside in one file.
Any way to split it in three files? Such that: 123456789A0F4POL123 ... |
|
| Topic: Use of indexes in DECLARE cursor |
|
| 20cents Replies: 5 Views: 2613 |
Forum: Database Posted: Thu Apr 06, 2006 6:47 pm Subject: Use of indexes in DECLARE cursor |
| 20cents,
Now use this information and open the cursor declared as below. SELECT * FROM TABLE WHERE ACT_NO = ... |
|
| Topic: Use of indexes in DECLARE cursor |
|
| 20cents Replies: 5 Views: 2613 |
Forum: Database Posted: Wed Apr 05, 2006 7:35 pm Subject: Use of indexes in DECLARE cursor |
| thanks, my master. | |
| Topic: Use of indexes in DECLARE cursor |
|
| 20cents Replies: 5 Views: 2613 |
Forum: Database Posted: Wed Apr 05, 2006 7:05 am Subject: Use of indexes in DECLARE cursor |
| Forgot to include what the array contains:
array_month[1] = 06; array_year[1] = 2005 array_month[2] = 07; array_year[2] = 2005 array_month[3] = 08; array_year[3] = 2005 array_month[4] = 09; arra ... |
|
| Topic: Use of indexes in DECLARE cursor |
|
| 20cents Replies: 5 Views: 2613 |
Forum: Database Posted: Wed Apr 05, 2006 7:01 am Subject: Use of indexes in DECLARE cursor |
| Hi,
Good day. I don't mean to be rude, but let me get straight to the point. I have a table which has 4 indexes - ACCTNO, YEAR, MONTH, and TIMEADD ACCTNO - account number YEAR - format CCYY ... |
|
| Topic: DB2 table load |
|
| 20cents Replies: 5 Views: 2495 |
Forum: Database Posted: Wed Jan 18, 2006 12:20 am Subject: DB2 table load |
Big Tango to all.
 |
|
| Topic: DB2 table load |
|
| 20cents Replies: 5 Views: 2495 |
Forum: Database Posted: Tue Jan 17, 2006 6:02 am Subject: Thanks all |
| Thanks all.
My LOAD is working fine now. But, I do have another query: I need to add into my job to load NULL value to a DATE field. How do I tackle this? my Input file: 000010038010000000 ... |
|
| Topic: DB2 table load |
|
| 20cents Replies: 5 Views: 2495 |
Forum: Database Posted: Mon Jan 16, 2006 10:38 pm Subject: DB2 table load |
| Here's the scenario:
1. I got a file (FILE1) which contains the account numbers (column 20-38 ) 2. I need to load these account numbers into a table (TABLE1), such that the table fields would c ... |
|
| Topic: DB2 - Update Error (-180) |
|
| 20cents Replies: 2 Views: 4022 |
Forum: Database Posted: Thu Jan 12, 2006 6:00 am Subject: DB2 - Update Error (-180) |
| Thanks kolusu for the prompt reply.
I saw the error... KCO-DATE-CHGOF-RVRSL contained 0833102005 which is an invalida date format. What puzzles me... the re-formatting done in the Working Storage ... |
|
| Topic: DB2 - Update Error (-180) |
|
| 20cents Replies: 2 Views: 4022 |
Forum: Database Posted: Thu Jan 12, 2006 4:53 am Subject: DB2 - Update Error (-180) |
| What's wrong with this code?
EXEC SQL UPDATE TBC_CHGOF SET DATE_CHGOF_RVRSL = :K ... |
|
| Topic: COBOL : IGYOP3093-W |
|
| 20cents Replies: 3 Views: 9911 |
Forum: Application Programming Posted: Thu Dec 29, 2005 2:42 am Subject: COBOL : IGYOP3093-W |
| Vinodch,
Thanks. That info you just gave cleared a lot of things. Do you think thst such warning errors may cause my compilation not to complete? My real problem is that I cant seem to stage the ... |
|
| Topic: COBOL : IGYOP3093-W |
|
| 20cents Replies: 3 Views: 9911 |
Forum: Application Programming Posted: Wed Dec 28, 2005 10:26 pm Subject: COBOL : IGYOP3093-W |
| What does this statement mean?
7456 IGYOP3093-W The "PERFORM" statement at "PERFORM (line 7456.01)" cannot reach its exit. Line 7456: LineID PL SL ----+-*A-1-B--+----2----+----3----+---- ... |
|
All times are GMT - 5 Hours |